Note: The job is a remote job and is open to candidates in USA. MSR Technology Group is seeking a hands-on Senior Data Engineer to support a large-scale Enterprise Data Warehouse and Analytics Program. The role focuses on designing, developing, and maintaining scalable data ingestion and transformation pipelines for healthcare analytics, regulatory reporting, and enterprise decision support. The position also involves data quality, cloud modernization, production support, and collaboration across technical and business teams.
Responsibilities
- Design, develop, and maintain enterprise ETL pipelines using Azure Data Factory (ADF), Informatica PowerCenter, and Python-based frameworks
- Build and optimize scalable data processing solutions using Python, Apache Spark, and Databricks
- Develop and optimize SQL queries, stored procedures, and database objects across platforms such as Snowflake, Oracle, and SQL Server
- Apply data engineering best practices to ensure performance, scalability, reliability, reusability, and security
- Support healthcare analytics and regulatory reporting initiatives
- Develop robust data validation, reconciliation, and audit-ready data pipelines
- Partner with analysts, QA teams, and reporting stakeholders to ensure data quality, accuracy, and timeliness
- Implement controls and monitoring processes to maintain trusted and compliant data assets
- Participate in cloud migration and modernization initiatives leveraging Azure-based data architectures
- Support production operations, incident management, troubleshooting, and root cause analysis
- Contribute to code reviews, source control management, and CI/CD processes using Azure DevOps and GitHub
- Collaborate across cross-functional teams to deliver scalable and maintainable data solutions
Skills
- 5+ years of experience in data engineering with a focus on enterprise data warehousing
- 5+ years of hands-on ETL development experience using Informatica PowerCenter, Teradata, Azure Data Factory, or similar technologies
- 5+ years of experience developing solutions in Python for data engineering and automation
- 5+ years of experience working with Teradata, including Teradata loading and utility tools
- 3+ years of experience with Spark-based processing frameworks such as Databricks
- Strong SQL expertise and experience working with relational databases, including Snowflake, Oracle, and SQL Server
- 3+ years of experience with Snowflake, including SnowSQL and Snowpark (Python)
- Experience with source control and DevOps practices using Azure DevOps, GitHub, and CI/CD pipelines
- Strong analytical, problem-solving, and troubleshooting skills
- Ability to work effectively in a fast-paced, collaborative environment
- Willingness to travel periodically as required
- Bachelor's degree or higher in Computer Science, Engineering, Analytics, or a related field
- Azure certifications related to Data Engineering or Analytics
- Experience supporting Enterprise Data Warehouse (EDW) environments
- Healthcare, payer, public sector, or regulated-industry analytics experience
- Data modeling experience in enterprise data warehouse environments
- Automation and orchestration scripting using PowerShell or Bash
- Experience designing, integrating, or consuming REST APIs within data platforms
- Familiarity with data quality frameworks, reconciliation processes, and audit support requirements
Benefits
- Remote (U.S.-based)
- Periodic travel may be required based on project or customer needs
Company Overview
Company H1B Sponsorship