Avatar for MSRCOSMOS
MSRCOSMOS
Actively Hiring
IT services firm specializing in cloud, data, AI, automation, and enterprise apps

Senior Data Engineer (ETL / Python Developer) (Remote)

Posted: 3 weeks ago
Hires remotely in
Remote Work Policy

Remote only

Company Location
Stockton
Visa Sponsorship

Not Available

RelocationAllowed
Skills
Python
SQL
SQL Server
Oracle
Github
Teradata
Snowflake
Spark
Stored procedures
Informatica PowerCenter
databricks
CI/CD
Azure DevOps
Snowsql
Azure Data Factory (ADF)
Snowpark (Python)
Teradata Loader Utilities

About the job

Senior Data Engineer (ETL / Python Developer) (Remote) (W2 Only)

Primary Responsibilities

Pipeline Development & Engineerin

  • 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, Spark, and Databricks
  • Write and optimize SQL and stored procedures across relational platforms such as Snowflake, Oracle, and SQL Server
  • Follow data engineering best practices for performance, reliability, reusability, and security

Analytics, Reporting & Data Qualit

  • Support Medicaid analytics and federal reporting initiatives (e.g., T-MSIS, PERM, MARS, Quality of Care)
  • Develop robust data validation, reconciliation, and audit-traceable data pipelines
  • Collaborate with analysts, QA, and reporting teams to ensure data quality, accuracy, and timeliness

Modernization, Operations & Collaboration

  • Participate in cloud migration and modernization initiatives within Azure-based architectures
  • Support production operations, incident resolution, and root cause analysis
  • Participate in code reviews, source control, and CI/CD processes using Azure DevOps and GitHub

.Required Qualification

  • 5+ years of data engineering experience with a focus on enterprise data warehousing
  • 5+ years of hands-on ETL development using Informatica PowerCenter, Teradata, Azure Data Factory, or similar tools
  • 5+ years of Python development for data engineering and automation
  • 5+ years of Teradata experience, including Teradata loader utilities
  • 3+ years of experience with Spark-based processing frameworks (Databricks or equivalent)
  • Solid SQL expertise and experience with relational databases (such as Snowflake, Oracle, SQL Server)
  • 3+ years of experience with Snowflake using SnowSQL and Snowpark (Python)
  • Experience with source control and DevOps practices (Azure DevOps, GitHub, CI/CD)
  • Proven solid analytical, problem-solving, and troubleshooting skills
  • Periodic travel may be required based on project or customer needs

Preferred Qualification

  • Bachelor’s degree or higher in Computer Science, Engineering, Analytics, or a related field
  • Azure certifications related to data engineering or analytics
  • Experience supporting State Medicaid EDW or MMIS analytics environments
  • Healthcare or public sector analytics experience (Medicaid / Medicare preferred)
  • Data modeling experience in enterprise data warehouse environments
  • Scripting experience (PowerShell, Bash) for automation and orchestration
  • Experience designing or consuming APIs (REST) within data platforms
  • Familiarity with data quality frameworks, reconciliation, and audit support

.

About the company

MSRCOSMOS company logo

MSRCOSMOS

Actively Hiring
IT services firm specializing in cloud, data, AI, automation, and enterprise apps501-1000 Employees
Company Location
Stockton
Company Size
501-1000
Learn more about MSRCOSMOS image