About Smile Brands:

At Smile Brands, we value our team as our most important asset. We are dedicated to creating a supportive and inclusive environment where every team member has the opportunity to thrive. Our commitment to fostering a culture of collaboration, continuous growth, and active community involvement ensures that we not only meet our goals but exceed them together

Become a part of a team that is passionate about making a difference in the lives of patients and in the communities we serve. At Smile Brands, your work matters, and your contributions are recognized and celebrated.

About IT:

Team members in India will have opportunities to support a large and diverse technology environment including enterprise infrastructure, cloud platforms, Fortinet-based networking, cybersecurity technologies, Microsoft 365 services, endpoint management platforms, and critical business applications. The GCC will also become an significant center for building technical capabilities, standardizing processes, driving operational improvements, and developing future technology leaders. This is a unique opportunity to help build a technology organization from the ground up while supporting a business that directly impacts patient care and healthcare delivery.

Responsibilities:

Data Pipeline Engineering and Modernization:

- Design, build, and optimize scalable, reusable batch and incremental data pipelines using Microsoft Fabric Data Factory, Fabric Pipelines, Notebooks, Python, and PySpark.
- Modernize existing Pentaho and Qlik Replicate/Attunity workloads into Microsoft Fabric while maintaining operational continuity, data accuracy, and recoverability.
- Integrate structured and unstructured data from PostgreSQL, Oracle, SQL Server, APIs, SFTP, file shares, and cloud storage across Azure, AWS, and on-premises environments.
- Implement metadata-driven patterns, parameterization, restartability, error handling, logging, monitoring, and alerting for production pipelines.

Data Modeling, Warehousing, and Business Intelligence:

- Design and maintain Microsoft Fabric Lakehouse, Warehouse, and One Lake architectures that support governed, scalable enterprise analytics.
- Develop dimensional models, fact and dimension structures,



slowly changing dimensions, historical snapshots, and point-in-time reporting solutions.
- Design and support Power BI semantic models, including DAX, Power Query, Direct Lake, row-level security, refresh performance, and reusable business measures.
- Collaborate with business stakeholders and analysts to translate functional requirements into reliable, understandable, and actionable data products.

Performance, Data Quality, Security, and Operations:

- Optimize SQL, indexing, partitioning, storage design, Spark workloads, Fabric capacity utilization, and end-to-end query performance.
- Perform root-cause analysis, source-to-target reconciliation, and data-quality validation to identify and resolve inconsistencies.
- Implement security best practices using Microsoft Entra ID, Azure Key Vault, role-based access control, service principals, managed identities, encryption, and appropriate data privacy controls.
- Own production reliability through proactive monitoring, incident response, documentation, runbooks, and continuous improvement.

Cross-Team Collaboration and Technical Leadership:

- Partner with Data Architects, Analysts, Infrastructure, Security, vendors, and business teams to shape and execute the organization's data strategy.
- Establish and promote engineering standards for source control, code review, testing, CI/CD, deployment, documentation, and environment management.
- Mentor engineers, contribute to team knowledge sharing, and provide clear technical guidance to both technical and nontechnical stakeholders.

Qualifications:

Demonstrated senior-level capability is required; there is no strict minimum number of years of experience. Candidates will be evaluated on technical depth, ownership of complex production solutions, architectural judgment, leadership, accomplishments, and measurable business impact.





- Data Pipeline Engineering and Microsoft Fabric Modernization: Proven ability to design, build, migrate, and operate scalable batch and incremental ETL/ELT pipelines using Microsoft Fabric Data Factory, Fabric Pipelines, Notebooks, Azure Data Factory, or comparable platforms, with strong production patterns for monitoring, restartability, logging, and automation.
- Advanced SQL and Database Engineering: Expert SQL skills with PostgreSQL and working experience with Oracle or comparable enterprise databases, including query tuning, indexing, partitioning, database objects, and high-volume processing.
- Data Modeling, Warehousing, and Power BI Semantic Architecture: Strong experience with dimensional modeling, OLTP and OLAP design, historical data patterns, Fabric One Lake, Lakehouse, Warehouse, SQL endpoints, and Power BI semantic models, including DAX, Power Query, Direct Lake, security, and performance optimization.
- Python, PySpark, Azure Dev Ops, and Modern Engineering Practices: Hands-on experience with notebook development, data transformation, validation, APIs, file processing, Git, pull requests, code review, testing, CI/CD, documentation, and promotion across Development, UAT, and Production.
- Production Ownership, Data Quality, Security, and Technical Leadership: Proven ability to troubleshoot complex issues, perform root-cause analysis and reconciliation, implement quality and governance controls, and own production reliability. Strong understanding of Microsoft Entra ID, Azure Key Vault, role-based access control, service principals, and managed identities, with the ability to communicate across teams, establish standards, and mentor others.

Preferred Skills:

- Experience supporting hybrid Azure, AWS, and on-premises data environments, including Amazon RDS PostgreSQL, Amazon S3, Azure Data Factory, and enterprise data gateways.
- Hands-on experience modernizing or supporting Pentaho Data Integration and Qlik Replicate/Attunity workloads.
- Familiarity with Microsoft Purview, Fabric governance and lineage, Docker, and event-driven or streaming architectures.
- Relevant Microsoft certifications in Fabric, Azure Data Engineering, or Power BI.

📌 Lead Data Engineer (India)
🏢 Smile Brands India
📍 India