Data Engineer (Analytics)

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). Project Summary

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., * 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.

• 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 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, 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.

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.

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.