Data Engineer

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 OverviewAs 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.ResponsibilitiesThis 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 optimizationSet up and maintain effective data compliance policiesBuild scalable data pipelines using ETL tools and processesDeploy data solutions to production environmentsMigrate data from legacy data warehouses leveraging cloud architecture principlesAutomate the flow of data for efficient consumptionBuild and implement business processes that enable data governanceDesign and advise on data quality rulesMust be a US citizenAs a US Citizen, you will be expected to work within compliance and security guidelines, ensuring that all deliverables meet organizational and regulatory standards.Bachelor’s Degree or equivalent OR 4 years’ relevant experience in lieu of degree7 additional years of relevant experienceAbility to gain and hold a Public Trust clearanceTechnical 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 environmentsStrong understanding of data engineering principles and data lifecycle managementProfessional Requirements:Ability to work independently and collaboratively in cross-functional teamsStrong organizational, time management, and multitasking skillsHigh attention to detail and commitment to data quality and accuracyPreferred QualificationsExperience with modern cloud data architecture and platformsProficiency with ETL tools such as Informatica, Talend, Azure Data Factory, or dbtExperience with cloud-based governance frameworks and implementationExperience with automation or scripting (E.g., Python, SQL, CI/CD pipelines)Attention CandidatesWe'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 (View email address on click.appcast.io) or a corporate email address (View email address on click.appcast.io). If you have any concerns, please don't hesitate to reach out to us at View email address on click.appcast.io 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. #J-18808-Ljbffr Index Analytics LLC