Job description

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’s experience through career development and educational opportunities. Job Overview As a Data Engineer in this role, you will apply advanced data engineering principles to create reusable workflows that cover ingestion, quality assurance, transformation, and optimization of data. You will be responsible for building scalable pipelines using ETL tools, ensuring that data is efficiently extracted, transformed, and loaded into target systems. Your work will involve deploying robust data solutions into production environments and migrating information from legacy data warehouses by leveraging modern cloud architecture, particularly within Microsoft Azure SQL and Snowflake environments. Automating the flow of data for seamless consumption will be a key aspect of your daily responsibilities. You will also play a pivotal role in establishing business processes that support strong data governance practices. This includes designing and advising on comprehensive data quality rules and setting up effective data compliance policies to ensure organizational standards are met. Exposure to ETL pipeline development, cloud-based data migration, and the implementation of data governance frameworks will be highly beneficial. Experience with optimizing data workflows, deploying solutions in cloud environments, and automating data processes will help you excel in this position. Responsibilities This role is centered on Snowflake as the primary data platform. Candidates are expected to demonstrate deep experience designing, developing, and optimizing enterprise-scale data solutions within Snowflake environments. • Apply data engineering principles to develop reusable workflows for data ingestion, quality, transformation, and optimization • Set up and maintain effective data compliance policies • Build scalable data pipelines using ETL tools and processes • Deploy data solutions to production environments • Migrate data from legacy data warehouses leveraging cloud architecture principles • Automate the flow of data for efficient consumption • Build and implement business processes that enable data governance • Design and advise on data quality rules • U.S. citizen or otherwise authorized to work in the United States and able to demonstrate physical residency in the U.S. for at least three (3) of the past five (5) years. Must be able to obtain a U.S. Federal government client badge and pass a Public Trust clearance. • Bachelor’s Degree or equivalent OR 4 years’ relevant experience in lieu of degree • 7 additional years of relevant experience • Ability to gain and hold a Public Trust clearance Technical Requirements: • Hands-on experience with: • Microsoft SQL Server (Intermediate proficiency) • Snowflake platform (Intermediate proficiency) • ETL pipeline design and development (Intermediate proficiency) • Microsoft Azure SQL (Intermediate proficiency) • Experience building and deploying data pipelines in production environments • Strong understanding of data engineering principles and data lifecycle management Professional Requirements: • Ability to work independently and collaboratively in cross-functional teams • Strong organizational, time management, and multitasking skills • High attention to detail and commitment to data quality and accuracy Preferred Qualifications • Experience with modern cloud data architecture and platforms • Proficiency with ETL tools such as Informatica, Talend, Azure Data Factory, or dbt • Experience with cloud-based governance frameworks and implementation • Experience with automation or scripting (E.g., Python, SQL, CI/CD pipelines) Attention Candidates 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 ( NAME@msg.paycomonline.com ) or a corporate email address ( NAME@index-analytics.com ). If you have any concerns, please don't hesitate to reach out to us at recruiting@index-analytics.com . 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. The salary range provided represents the estimated compensation for new hires in this position, applicable across all locations. Actual offers may vary based on factors such as the candidate's skills, qualifications, experience, and market conditions. Index complements its base salary offering with a competitive package that includes health and retirement benefits, discretionary bonuses, and reimbursement for professional development opportunities. 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.

Requirements

Must-haves

Job Overview
This role is centered on Snowflake as the primary data platform. Candidates are expected to demonstrate deep experience designing, developing, and optimizing enterprise-scale data solutions within Snowflake environments.
Apply data engineering principles to develop reusable workflows for data ingestion, quality, transformation, and optimization
Set up and maintain effective data compliance policies
Build scalable data pipelines using ETL tools and processes
Deploy data solutions to production environments
Migrate data from legacy data warehouses leveraging cloud architecture principles
Automate the flow of data for efficient consumption
Build and implement business processes that enable data governance
Design and advise on data quality rules
Bachelor’s Degree or equivalent OR 4 years’ relevant experience in lieu of degree
7 additional years of relevant experience
Ability to gain and hold a Public Trust clearance
Microsoft SQL Server (Intermediate proficiency)
Snowflake platform (Intermediate proficiency)
ETL pipeline design and development (Intermediate proficiency)
Microsoft Azure SQL (Intermediate proficiency)
Experience building and deploying data pipelines in production environments
Strong understanding of data engineering principles and data lifecycle management

Nice-to-haves

Experience with modern cloud data architecture and platforms
Proficiency with ETL tools such as Informatica, Talend, Azure Data Factory, or dbt
Experience with cloud-based governance frameworks and implementation
Experience with automation or scripting (E.g., Python, SQL, CI/CD pipelines)
Attention Candidates

Application prep

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

Keywords to mirror

azuresqlpythonci/cdai

Platform: paycom
Effort: medium

Benefits

Benefits detected in the listing.

Professional Development