Principal Data Engineer

Birdi is seeking a Principal Data Engineer to lead the architecture, development, and optimization of their data infrastructure. This senior-level role involves transitioning to cloud-based solutions and ensuring data solutions meet high standards of performance and compliance in the healthcare sector.

Responsibilities:

• Lead the architecture, development, and optimization of scalable ETL/ELT pipelines to ingest, transform, and integrate data from diverse sources
• Design and implement enterprise-level data warehouse solutions and data models to support advanced analytics and BI
• Spearhead the migration of SQL Server databases and SSRS reports
• Provide recommendations and assist in implementing Self-service reporting solution
• Develop and enforce best practices for building and maintaining Tableau dashboards and transitioning legacy reporting tools to modern platforms
• Implement comprehensive data quality frameworks, ensuring accuracy, consistency, and completeness across data assets
• Conduct performance tuning and root cause analysis to resolve data pipeline and infrastructure issues
• Collaborate with analysts, data scientists, and business stakeholders to translate business needs into scalable technical solutions
• Maintain detailed technical documentation, including data dictionaries, flow diagrams, and SOPs
• Evaluate emerging technologies and AWS services to drive innovation and continuous improvement
• Participate in strategic planning, architectural reviews, and incident management for data systems
• Ensure strict compliance with data governance, HIPAA, and ePHI security standards
• Serve as a mentor and technical lead for junior engineers and cross-functional collaborators
• Perform other related duties as assigned to support data infrastructure and team objectives

Requirements:

• Proven experience in a senior or principal data engineering role
• Expert-level SQL skills and deep knowledge of relational databases, including SQL Server and PostgreSQL
• Advanced ETL/ELT development experience using SSIS, Python, or equivalent technologies
• Deep understanding of data warehousing, dimensional modeling (star/snowflake schemas), and analytics architectures
• Expertise in Tableau and SSRS, with a demonstrated ability to modernize legacy reporting
• Proficient in Python, C#, and advanced SQL development for data processing and application integration
• Strong problem-solving skills and the ability to work independently on complex initiatives
• Excellent communication and interpersonal skills to engage stakeholders across business and technical teams
• In-depth knowledge of HIPAA and healthcare data security best practices
• Ability to work extended hours, weekends, and holidays in alignment with company and industry demands
• Bachelor's degree in computer science, Information Technology, or a related field; proven equivalent experience may be acceptable in lieu of degree
• 7–10 years of hands-on experience in Data Engineering, with a strong emphasis on cloud-based architecture and infrastructure
• Demonstrated experience with containerized data applications and large-scale system deployments
• Experience with Debezium or similar data capture (CDC) tools
• Hands-on experience with large-scale data migrations
• Experience with infrastructure-as-code tools such as Terraform and CloudFormation
• Proficient in Git and modern CI/CD workflows for automated deployment and version control
• Knowledge of healthcare data standards and protocols (e.g., HL7, FHIR)