Data Scientist​/Data Engineer Indianapolis, IN; Hybrid

DMS Systems is actively seeking an experienced, high‑caliber, and technical Data Scientist / Data Engineer with 8+ years of progressive professional experience in big data engineering, cloud analytics, and advanced data science architectures to join our client project on a hybrid basis in Indianapolis, IN (open to C2C and W2 arrangements for local candidates). In this critical data infrastructure and analytics role, you will be responsible for designing, building, securing, and scaling robust data pipelines, data warehouses, and Medallion architecture frameworks on Microsoft Azure.

You will leverage your deep specialist expertise in Azure Databricks, PySpark, Azure Synapse, and data governance frameworks to deliver uncompromised data reliability, high performance, and operational excellence. This opportunity offers competitive compensation, executive technical visibility, and exceptional career growth prospects within a premier global IT recruitment and staffing enterprise.

As a Data Scientist / Data Engineer supporting DMS Systems in Indianapolis, IN (Hybrid), you will take full operational, tactical, and technical ownership of cloud data platform engineering, PySpark data transformations, data lakehouse governance, and ETL/ELT workflow execution across mission‑critical enterprise systems. Your day‑to‑day responsibilities include designing, developing, testing, and maintaining scalable data pipelines utilizing Azure Databricks, Spark SQL, Delta Lake, Medallion Architecture, Unity Catalog, Delta Live Tables (DLT), and Auto Loader, architecting and optimizing Azure Synapse analytics environments utilizing dedicated and serverless SQL pools, star‑schema modeling, MPP architectures, Poly Base, and CETAS, establishing robust workflow orchestration and CI/CD deployment pipelines utilizing Azure Data Factory (ADF), Databricks Workflows, Azure Dev Ops, Git, and ADLS Gen2, enforcing strict data governance protocols including HIPAA compliance, PHI/PII protection, and Unity Catalog Role‑Based Access Control (RBAC), collaborating closely with cross‑functional software engineering, data science, and business analytics squads in Agile sprint cycles, conducting rigorous performance tuning, query optimization, and root cause analysis (RCA) across large‑scale datasets, preparing comprehensive technical documentation of data models, pipeline topologies, and operational runbooks, and managing application requirements by ensuring strict compliance with local candidate residency in Indianapolis and C2C/W2 visa transparency.

You will utilize your proactive troubleshooting and analytical problem‑solving skills to resolve complex data pipeline failures and latency bottlenecks under strict service level agreements. Furthermore, you will manage application requirements ensuring strict compliance with local candidate residency in Indianapolis and C2C/W2 visa transparency.

• Design, develop, test, optimize, and maintain scalable data pipelines utilizing Azure Databricks, PySpark, Spark SQL, and Delta Lake.
• Implement modern data lakehouse patterns including Medallion Architecture, Unity Catalog, Delta Live Tables (DLT), and Auto Loader.
• Architect, configure, and optimize Azure Synapse Analytics environments with dedicated and serverless SQL pools and star‑schema models.
• Build, maintain, and troubleshoot automated workflow orchestration pipelines utilizing Azure Data Factory (ADF) and Databricks Workflows.
• Enforce rigorous enterprise data governance standards including HIPAA compliance, PHI/PII data protection, and Unity Catalog RBAC.
• Implement CI/CD deployment pipelines and version control workflows utilizing Azure Dev Ops, Git, and ADLS Gen2 storage.
• Provid…