Senior Data Engineer (Analytics)

Applied Information Sciences; Washington (District of Columbia); On-site; USD 110,000 - 166,000; Full time

Job summary

Applied Information Sciences in the Washington, DC area is seeking a Senior Data Engineer (Analytics) to support a federal law enforcement mission. You will deliver reports, dashboards, queries, and analytics, collaborating with clients and cross-functional teams in a fast-paced environment.

The role requires strong data analytics and relational database expertise, plus effective communication skills to translate business needs into technical solutions. Must be a U.S.

Qualifications

• 5+ years of experience in data engineering, analytics, reporting, or related field.
• Experience building reports and dashboards.
• Strong SQL skills and data concepts.
• Experience with relational databases (Oracle/PostgreSQL).
• Experience with ElasticSearch/OpenSearch.
• Excellent written and verbal communication.

Responsibilities

• Gather requirements and design reports to address stakeholder needs.
• Develop scalable, high-performance queries and analytics tools.
• Integrate data from disparate sources.
• Create dashboards and analytics products supporting business needs.
• Communicate requirements and translate them into technical solutions.
• Collaborate with cross-functional teams and clients.
• Respond to evolving client requirements within tight timelines.

Skills

SQL

Data modeling

ETL/ELT

Data integration

Communication

Education

Bachelor's degree or higher in CS or related

Tools

Oracle

PostgreSQL

ElasticSearch/OpenSearch

Power BI

Tableau

AWS (S3, RDS, EC2)

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.