Senior Data Engineer (Analytics)

Applied Information Sciences
  • Washington
    3 days ago

    Job Description

    Why AIS?

    When you join AIS, you’re joining a mission-driven team that’s passionate about making a difference. You’ll work on projects that matter, alongside industry-leading experts, in an environment that fosters innovation, driving client success, and empowering our team to make a lasting impact. As an employee-owned company, we value collaboration, inclusivity, continuous growth, and shared success.

    • Employee Ownership: Your contributions directly impact the company’s success, and you share in its achievements.

    • Continuous Learning: Access to resources, training, and mentorship to support your professional growth.

    • Inclusive Culture: A workplace where diversity is celebrated, and everyone’s voice is valued.

    • Mission-Driven Work: Engage in projects that make a meaningful difference for our clients and communities.

     

    What are we looking for?

    At AIS, we're looking for more than just skills - we're looking for driven individuals who are passionate about making a difference, eager to grow, and aligned with our core principles.

     

    What you will be doing?

    This position is contingent upon contract award. We are currently pursuing a proposal and are seeking qualified candidates to include in our submission and identify candidates for future hiring needs on the program once awarded.

    At AIS, we are dedicated to providing our employees with diverse opportunities to grow their careers while supporting a variety of impactful projects. For this position, we are seeking a talented individual to join AIS as a Senior Data Analytics Engineer.
    • Core Knowledge & Skills: Optimizes complex SQL; applies advanced data modeling; leads robust ETL/ELT; uses big data technologies (e.g., Spark); enforces governance; implements ML/predictive solutions; manages scalable pipelines.

    • Work & Complexity: Solves high-complexity integration and performance challenges; runs multiple projects; delivers custom analytics solutions and automation for scale.

    • Quality & Independence: Sets benchmarks for data quality; drives continuous improvement; makes significant technical decisions with minimal oversight.

    • Teamwork & Communication: Leads cross-functional work; mentors engineers; communicates complex insights to senior leaders; integrates multi-stakeholder feedback.

    • Consulting & Engagement: Provides strategic consultation, leads client interactions, and advances consulting best practices.

    As your initial project assignment, you will support the unique needs of our client as a Senior Data Engineer (Analytics).

    Position Summary

    We are seeking a Senior Data Engineer – Data Engineer (Analytics) to support a federal law enforcement mission by delivering reports, dashboards, queries, and analytics that respond to emerging stakeholder needs. This position requires strong technical expertise in data analytics and relational databases, along with excellent communication skills and the ability to collaborate with clients and cross-functional teams in a fast-paced environment.

    Key Responsibilities

    • Gather requirements, collect data, and design and develop reports to address emerging stakeholder needs.
    • Develop scalable, high-performance queries and analytics tools.
    • Research, understand, and integrate data from disparate sources.
    • Create reports, dashboards, and other analytics products supporting mission and business requirements.
    • Communicate effectively with clients to understand requirements and translate them into technical solutions.
    • Collaborate with cross-functional technical and business teams.
    • Respond to evolving client requirements within tight timeframes.

    Required Qualifications

    • 5+ years of relevant experience in data engineering, analytics, reporting, or a related field.
    • Experience developing reports and dashboards.
    • Strong SQL skills and knowledge of data concepts.
    • Experience with relational databases, particularly Oracle and/or PostgreSQL.
    • Experience developing queries using ElasticSearch and/or OpenSearch.
    • Experience researching, understanding, and integrating disparate data sources.
    • Strong written and verbal communication skills.
    • Bachelor’s degree or higher; Computer Science or a related technical discipline preferred. A degree is not required with suitable relevant experience.
    • Experience with AWS services, including S3, RDS, EC2, Lambda, Step Functions, EventBridge, and OpenSearch/ElasticSearch.
    • Experience with JSON and JSON format mediation techniques.
    • Experience developing reports and dashboards using Power BI and Tableau.
    • Familiarity with DevSecOps tools such as Jenkins and Git.
    • Knowledge of modern data management patterns, including:
      • Data warehouses
      • Data marts
      • Data lakes
      • Delta lakes
      • Lakehouses
      • Data mesh architectures
    • U.S. citizenship and ability to obtain and maintain a DHS 6C Public Trust (Full BI).
    At AIS, we are committed to offering competitive and fair compensation that reflects the skills, experience, and contributions of each team member. The targeted base salary range for this role is $110,000-$166,000 per year. Please note that this range is provided as a guideline and the final offer will be based on several factors, including but not limited to, skillset and competencies, level of experience, education, certifications, and location. We value transparency in our hiring process and are happy to discuss how your unique qualifications align with our compensation structure during the interview process.

    Applied Information Sciences does not discriminate on the basis of race, national origin, religion, color, gender, sexual orientation, age, disability, protected veteran status, or any other basis. Employment decisions are based solely on qualifications, merit, and business needs.

    Numbers & Facts

    LocationWashington

    Skills

    • AWS Lambdaunmatched
    • Amazon Elastic Compute Cloud (EC2)unmatched
    • Amazon Relational Database Service (RDS)unmatched
    • Amazon Simple Storage Service (S3)unmatched
    • Amazon Web Services (AWS)unmatched
    • Automationunmatched
    • Benchmarkingunmatched
    • Best Practicesunmatched
    • Big Dataunmatched
    • Business Intelligenceunmatched
    • Communication Skillsunmatched
    • Computer Scienceunmatched
    • Consultingunmatched
    • Continuous Improvementunmatched
    • Cross-Functionalunmatched
    • Customer Relationsunmatched
    • Data Analysisunmatched
    • Data Collectionunmatched
    • Data Managementunmatched
    • Data Martunmatched
    • Data Qualityunmatched
    • Data Warehousingunmatched
    • Database Extract Transform and Load (ETL)unmatched
    • Diversityunmatched
    • Elasticsearchunmatched
    • Federal Laws and Regulationsunmatched
    • Gitunmatched
    • Homeland Securityunmatched
    • Information Scienceunmatched
    • JSONunmatched
    • Jenkinsunmatched
    • Law Enforcementunmatched
    • Mentoringunmatched
    • Multitaskingunmatched
    • Oracleunmatched
    • Performance Analysisunmatched
    • PostgreSQLunmatched
    • Power BIunmatched
    • Presentation/Verbal Skillsunmatched
    • Process Improvementunmatched
    • Product Supportunmatched
    • Query Analysisunmatched
    • Relational Databases (RDBMS)unmatched
    • Reporting Dashboardsunmatched
    • Reporting Skillsunmatched
    • Requirements Managementunmatched
    • SQL (Structured Query Language)unmatched
    • Sales Pipelineunmatched
    • Scalable System Developmentunmatched
    • Tableauunmatched
    • Team Playerunmatched
    • United States Citizenunmatched
    • Writing Skillsunmatched

    Level up your application

    Professional resume templates

    Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

    Free resume templates

    Resume Builder

    Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

    Resume Builder