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 is seeking a Senior Data Engineer (Analytics) to support a federal mission by delivering dashboards, reports, and queries. The role emphasizes data analytics, relational databases, and collaboration with clients and cross-functional teams in a fast-paced environment.

The ideal candidate has 5+ years in data engineering, strong SQL, experience with Oracle/PostgreSQL, ElasticSearch/OpenSearch, and AWS services, plus Power BI/Tableau expertise.

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.

Responsibilities

• Gather requirements, collect data, and design and develop reports to address stakeholder needs.
• Develop scalable, high-performance queries and analytics tools.
• Research, understand, and integrate data from disparate sources.
• Create reports, dashboards, and 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.

Skills

SQL

Data modeling

ETL/ELT

Big data

Data visualization

Power BI

Tableau

AWS

OpenSearch/ElasticSearch

Communication

Education

Bachelor's degree in CS or related field

Tools

Oracle

PostgreSQL

ElasticSearch/OpenSearch

Power BI

Tableau

Jenkins

Git

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 SummaryWe 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 ResponsibilitiesGather 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 Qualifications5+ 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 warehousesData martsData lakesDelta lakesLakehousesData mesh architecturesU.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. 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.Applied Information Sciences does not discriminate on the basis of race, national origin, religion, color, gender, sexual orientation, age, disability, protected veteran status, or any other basis. Employment decisions are based solely on qualifications, merit, and business needs.