Data Engineer (Databricks + Informatica + Azure)

Halcyon Labs is a global consulting and technology services firm with offices in the US, India, and Argentina. We help organizations accelerate growth, drive innovation, and solve complex challenges by combining strategy, design, and advanced technology. Our expertise covers defining business vision, optimizing processes, and creating engaging digital experiences. We architect and modernize secure, scalable solutions using cloud platforms and top engineering practices. Halcyon Labs also empowers clients to unlock data value through analytics and visualization and leverages artificial intelligence to automate processes and enhance decision-making. Our agile, cross-functional teams work closely with clients, either integrating with their teams or providing independent guidance—to deliver measurable results and build lasting partnerships. We are seeking a skilled Data Engineer to join our consulting team on a strategic project with one of our key clients in the healthcare industry. You will be responsible for designing, building, and optimizing scalable data solutions that support analytics, reporting, and advanced data use cases in regulated environments. In this role, you will work alongside data architects, analysts, and business stakeholders, translating healthcare data requirements into robust technical solutions. You will operate within high-performing teams in an environment where technical excellence, autonomy, and data-driven decision-making are valued. Role & Responsibilities: Design, develop, and maintain scalable data pipelines using modern distributed data processing platforms and cloud environments. Build and optimize ETL/ELT processes following industry best practices and cloud-native architectures. Implement data models aligned with modern Data Lakehouse principles and data architecture frameworks. Ensure data quality, consistency, and performance across ingestion, staging, and curated data layers. Collaborate with data architects, analysts, and business stakeholders to understand complex healthcare data requirements. Develop reusable data transformation logic and modular processing components for efficient, maintainable systems. Support deployment processes following CI/CD and DevOps best practices. Monitor and optimize data workflows for performance, scalability, and reliability in production environments. Contribute to data governance, security, and compliance practices relevant to regulated healthcare environments. Hard Skills - Must have: Proven hands-on experience with Informatica as a data integration and ETL platform. Strong experience with Databricks or similar distributed data processing platforms. Core expertise in data architecture, data integrations, data warehousing, and ETL/ELT process design. Applied experience developing and deploying custom scripts and modules for distributed computing environments (custom code execution across parallel executors and worker nodes). Strong proficiency in SQL, Python, and PySpark (or equivalent distributed processing languages) for data transformation and processing. Solid knowledge of cloud and hybrid relational database systems such as MS SQL Server, PostgreSQL, Oracle, Azure SQL, AWS RDS, or comparable engines. Hands-on experience with batch and streaming data processing techniques and data compaction strategies. Soft Skills / Business Specific Skills: Strong analytical and problem-solving skills. Ability to work effectively in cross-functional and distributed teams. Clear communication skills, with the ability to explain technical concepts to non-technical stakeholders. Proactive mindset with a strong sense of ownership. Commitment to delivering high-quality, reliable data solutions. At Halcyon Labs , we value differences. Halcyon Labs is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. Halcyon Labs makes employment decisions without regard to race, color, creed, religion, age, ancestry, national origin, veteran status, sex, sexual orientation, gender, gender identity, gender expression, marital status, disability or any other legally protected category. This policy applies to all terms and conditions of employment, including but not limited to, recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training. Originally posted on Himalayas