Data Engineer (Analytics)

AIS (Applied Information Sciences)•Remote - VA, VA

5d•$110,000 - $166,000•Onsite

About The Position

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 Data Engineer (Analytics). AIS is seeking a Data Engineer (Analytics) to support a federal law enforcement mission by designing, developing, and maintaining data analytics solutions that enable informed decision-making and operational effectiveness. The successful candidate will work closely with stakeholders, data engineers, analysts, and technical teams to transform complex data into actionable insights through reporting, dashboard development, and advanced data analysis. This role requires strong analytical skills, database expertise, and the ability to work in a fast-paced, mission-focused environment.

Requirements

U.S. Citizenship with the ability to obtain and maintain a DHS 6C Public Trust clearance.
Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, or a related discipline. Relevant experience may be substituted for education.
5+ years of experience in data engineering, data analytics, business intelligence, or a related field.
Experience developing reports, dashboards, and data visualizations.
Strong SQL skills and understanding of relational database concepts.
Experience working with Oracle and/or PostgreSQL databases.
Experience querying and analyzing data using Elasticsearch or OpenSearch.
Experience integrating and analyzing data from multiple disparate data sources.
Strong analytical, troubleshooting, and problem-solving skills.
Excellent verbal and written communication abilities.
Ability to work onsite in Washington, DC during core business hours.

Nice To Haves

Experience with AWS services including S3, RDS, EC2, Lambda, Step Functions, EventBridge, and OpenSearch.
Experience working with JSON data structures and data transformation techniques.
Experience developing dashboards and reports using Power BI and/or Tableau.
Familiarity with DevSecOps practices and tools such as Git and Jenkins.
Knowledge of modern data architectures and data management patterns, including: Data Warehouses, Data Marts, Data Lakes, Delta Lakes, Lakehouses, Data Mesh Architectures
Experience supporting government, law enforcement, or other high-security environments.
Experience with emerging analytics and cloud technologies.

Responsibilities

Gather business and technical requirements from stakeholders to support reporting and analytical needs.
Collect, integrate, and analyze data from multiple structured and unstructured data sources.
Design, develop, and maintain dashboards, reports, and visualizations to support mission objectives.
Create and optimize scalable, high-performance SQL queries and analytics solutions.
Research, understand, and combine disparate data sources to deliver meaningful insights.
Collaborate with cross-functional teams to identify and resolve data quality and performance issues.
Communicate technical findings and recommendations to both technical and non-technical stakeholders.
Respond to evolving mission requirements and deliver solutions within established timelines.
Support continuous improvement of data engineering, analytics, and reporting processes.