Senior Data Engineer (Analytics)

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.

Additional information

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

Pay and benefits

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.