Data Engineer (Analytics)

Applied Information Sciences is seeking a Data Engineer (Analytics) to support a federal law enforcement mission by building analytics solutions that help teams make informed decisions.

Responsibilities

• Gather business and technical requirements from stakeholders to support reporting and analytics needs
• Collect, integrate, and analyze data from multiple structured and unstructured data sources
• Design, develop, and maintain dashboards, reports, and visualizations tied to mission objectives
• Create and optimize scalable, high-performance SQL queries and analytics solutions
• Research and combine disparate data sources to produce actionable 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
• Adapt to evolving mission requirements and deliver solutions within established timelines
• Support ongoing improvement of data engineering, analytics, and reporting processes

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 substitute for education)
• 5+ years of experience in data engineering, data analytics, business intelligence, or a related field
• Experience building reports, dashboards, and data visualizations
• Strong SQL skills and knowledge of relational database concepts
• Experience 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 (Virginia onsite)

Technologies

• SQL, Spark
• Oracle, PostgreSQL
• Elasticsearch, OpenSearch
• Power BI, Tableau
• AWS (S3, RDS, EC2, Lambda, Step Functions, EventBridge)
• JSON, Git, Jenkins
• Data Warehouses, Data Marts, Data Lakes, Delta Lakes, Lakehouses, Data Mesh Architectures
• DevSecOps

Project Summary

• Design, develop, and maintain data analytics solutions for informed decision-making and operational effectiveness
• Work with stakeholders, data engineers, analysts, and technical teams to transform complex data into actionable insights via reporting and dashboard development
• Operate in a fast-paced, mission-focused environment using strong analytics and database expertise

Nice to Have Skills

• 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 (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

Contract Details

• Job type: contract
• Contingent upon contract award
• Proposal status: currently pursuing a proposal and seeking qualified candidates for submission and potential future hiring on the program once awarded

Compensation

• Targeted base salary range: $110,000 - $166,000 per year
• Final offer will be based on factors including skillset and competencies, level of experience, education, certifications, and location

Why AIS

• Employee Ownership: contributions directly impact company success
• Continuous Learning: access to resources, training, and mentorship
• Inclusive Culture: diversity celebrated; everyone’s voice valued
• Mission-Driven Work: projects that make a meaningful difference for clients and communities