Job description

Company Overview Index Analytics, LLC, is a rapidly growing, Baltimore-based small business providing health-related consulting services to the federal government. At the center of our company culture is a commitment to instilling a dynamic and employee-friendly place to work. We place a priority on promoting a supportive and collegial team environment and enhancing staff experience through career development and educational opportunities. Position Overview Index Analytics is seeking a Data Engineer to support Government clients to design, build, and optimize scalable data pipelines and cloud-based solutions. The Data Engineer plays a key role in modernizing the organization’s data ecosystem by implementing data solutions using a contemporary infrastructure. As part of a cross-functional team including Data Engineers, Software Engineers, Analysts, the engineer will support efforts to implement a robust environment capable of ingesting diverse data sources to support advanced analytics and reporting needs. Core responsibilities include implementing structural, interface, and business requirements for data solutions; implementing relational and non-relational databases and their associated integration components; and implementing a Snowflake-based system with automated data pipelines. This role blends advanced data engineering with hands‑on cloud solutions engineering, leveraging AWS, Snowflake, and modern DevOps practices. The ideal candidate has experience delivering high‑quality solutions in an Agile environment. Responsibilities • Collaborate closely with stakeholders, cross‑functional and internal technical teams to understand requirements and business rules and develop a thorough understanding of the business context and objectives • Collaborate to implement secure, scalable, and cost‑optimized data solutions • Build and maintain scalable, reliable ETL/ELT data pipelines using AWS, Snowflake and Snowflake tools • Develop and optimize data models, both conceptual and physical, to support analytics, reporting, dashboards and operational consumption • Implement data quality, validation, and monitoring frameworks to ensure accuracy and reliability • Ensure data workflows are modular, testable, and properly version‑controlled • Operationalize pipelines with monitoring, alerting, and automated recovery mechanisms • Conduct advanced data analysis using languages such as Python and SQL • Support the development of documentation to include data models, data dictionaries, and data usage guides • Improve end-to-end performance of data workflows • Build and maintain CI/CD pipelines to support automated testing, deployments, and continuous integration • Meet schedule deadlines and commitments with a high-level of quality of deliverables • Collaborate with a team of cross-functional resources in an Agile delivery environment to deliver iterative value • US citizen or lived in the US for 3 of the last 5 years. Must be able to obtain a U.S. Federal government client badge and pass a government background investigation • Bachelor’s degree or equivalent with six (6) or more years of experience as a Data Engineer or similar role • Strong proficiency in Snowflake, AWS services • Hands-on experience using Snowflake tools, SQL and Python is required • Strong proficiency in GitHub for source control, branching strategy and reviews • Knowledge of data integration patterns, data warehousing, and modern data architecture • Strong analytical and communication skills, including the ability to analyze data, create meaningful insights, and present information clearly to stakeholders. • Experience with object‑oriented programming and building with software engineering principles • DevOps exposure, including CI/CD tools • Understanding of Data Lake concepts • Strong written and verbal communication skills are required, ability to collaborate, present, and report on findings • Knowledge of Agile framework, Scrum methodologies and knowledge of tools used to support them • Prior experience with government agencies and fraud detection systems is a plus Attention Candidates If you are selected for an interview, please be advised that Index Analytics LLC reserves the right to prohibit the use of artificial intelligence (AI) tools, including but not limited to AI-generated responses, real-time transcription, or automated assistance during the interview process. We value authentic interactions and the opportunity to engage directly with candidates. Any unauthorized use of AI may result in disqualification from consideration. We're dedicated to ensuring a safe and transparent recruitment process for all candidates and have implemented robust measures to protect your personal information. Please be aware that all employment-related communications will originate from a secure portal ( @msg.paycomonline.com ) or a corporate email address ( @index-analytics.com ). If you have any concerns, please don't hesitate to reach out to us at recruiting@index-analytics.com . Index Analytics provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training. Share job details to

Requirements

Must-haves

Company Overview
Position Overview
Collaborate closely with stakeholders, cross‑functional and internal technical teams to understand requirements and business rules and develop a thorough understanding of the business context and objectives
Collaborate to implement secure, scalable, and cost‑optimized data solutions
Build and maintain scalable, reliable ETL/ELT data pipelines using AWS, Snowflake and Snowflake tools
Develop and optimize data models, both conceptual and physical, to support analytics, reporting, dashboards and operational consumption
Implement data quality, validation, and monitoring frameworks to ensure accuracy and reliability
Ensure data workflows are modular, testable, and properly version‑controlled
Operationalize pipelines with monitoring, alerting, and automated recovery mechanisms
Conduct advanced data analysis using languages such as Python and SQL
Support the development of documentation to include data models, data dictionaries, and data usage guides
Improve end-to-end performance of data workflows
Build and maintain CI/CD pipelines to support automated testing, deployments, and continuous integration
Meet schedule deadlines and commitments with a high-level of quality of deliverables
Collaborate with a team of cross-functional resources in an Agile delivery environment to deliver iterative value
US citizen or lived in the US for 3 of the last 5 years. Must be able to obtain a U.S. Federal government client badge and pass a government background investigation
Bachelor’s degree or equivalent with six (6) or more years of experience as a Data Engineer or similar role
Strong proficiency in Snowflake, AWS services
Hands-on experience using Snowflake tools, SQL and Python is required
Strong proficiency in GitHub for source control, branching strategy and reviews
Knowledge of data integration patterns, data warehousing, and modern data architecture
Strong analytical and communication skills, including the ability to analyze data, create meaningful insights, and present information clearly to stakeholders.
Experience with object‑oriented programming and building with software engineering principles

Nice-to-haves

Prior experience with government agencies and fraud detection systems is a plus

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

awsagilepythonsqlci/cdscrumai

Platform: paycom
Effort: medium