Mass General Brigham
Principal Data Engineer
Mass General Brigham, Somerville, Massachusetts, us, 02145
About Us
As a not-for-profit organization, Mass General Brigham is committed to supporting patient care, research, teaching, and service to the community by leading innovation across our system. Founded by Brigham and Women’s Hospital and Massachusetts General Hospital, Mass General Brigham supports a complete continuum of care including community and specialty hospitals, a managed care organization, a physician network, community health centers, home care and other health-related entities. Several of our hospitals are teaching affiliates of Harvard Medical School, and our system is a national leader in biomedical research.
We’re focused on a people-first culture for our system’s patients and our professional family. That’s why we provide our employees with more ways to achieve their potential. Mass General Brigham is committed to aligning our employees’ personal aspirations with projects that match their capabilities and creating a culture that empowers our managers to become trusted mentors. We support each member of our team to own their personal development—and we recognize success at every step.
Our employees use the Mass General Brigham values to govern decisions, actions and behaviors. These values guide how we get our work done: Patients, Affordability, Accountability & Service Commitment, Decisiveness, Innovation & Thoughtful Risk; and how we treat each other: Diversity & Inclusion, Integrity & Respect, Learning, Continuous Improvement & Personal Growth, Teamwork & Collaboration.
Position Overview
We are seeking a highly skilled and experienced Principal Data Engineer to join our dynamic team. As a key member of our data engineering team, you will play a crucial role in designing, developing, and maintaining our data infrastructure and platform integration solutions. The Principal Data Engineer will be responsible for advancing our data engineering capabilities, ensuring data quality, and contributing to the success of data-driven initiatives.
Principal Duties And Responsibilities
Infrastructure, Architecture and Design:
Design end-to-end data solutions on the Azure data platform, considering Scalability, Security, Compliance and Performance.Contribute to technical foundation of the Data Lake platform, expanding and optimizing the data ecosystem and pipeline architecture.Provide expertise in selecting and implementing appropriate data platform services (e.g. Azure, Databricks, Snowflake) for various data processing and storage needs.Collaborate with cross-functional teams to integrate data solutions with existing MGB data platform systems and applications, integrate new data management technologies aligned with the latest vendor products & capabilities (Microsoft Azure and Fabric, Databricks, Snowflake, Collibra, etc.) and software engineering tools into existing structures.Design, develop, construct, test, and maintain Data Lake architectures and large-scale data processing systems.Support big data, data lake, lakehouse ecosystem related tool selection and POC analysis.Data Pipeline Development
Gather and process raw data at scale including large complex data sets, meeting functional/non-functional business requirements (using ADF, Databricks, Python, Pyspark, scripts, REST API calls, SQL Queries, etc.).Develop data set processes for data modeling, mining, and production.Create and maintain optimal data pipeline architecture on cloud-based platforms (e.g., Azure) and relational data systems (SQL Server, SSIS, Snowflakes).Cross-Functional Collaboration
Work on cross-functional teams delivering enterprise solutions for internal and external clients.Collaborate with Software Developers, Database Architects, Data Analysts, and Data Scientists on data initiatives.Support stakeholders, including the Management team, Product owners, and Architecture teams, in addressing data-related technical issues and fulfilling data infrastructure needs.Partner with integrated platform & data science teams to define integrated solutions to meet the evolving needs of data analysts, developers & consumers (e.g. data ingestion framework, AI/ML capabilities, scalable compute), contributing to the innovation and leadership of the organization.Data Optimization And Automation
Identify, design, and implement internal process improvements, automation of manual processes, optimization of data delivery, etc.Build the data infrastructure required for optimal extraction, transformation, and loading of data from traditional/legacy sources.Subject Matter Expertise And Leadership
Act as a subject matter expert for internal or external data products.Contribute to solution architecture design and advise on engineering solution best practices.Mentor and guide junior data engineers by leading code reviews and documenting best practices.Use Mass General Brigham values to govern decisions, actions, and behaviors.Perform other duties and responsibilities as assigned.Minimum Qualifications
Bachelor's or Master's degree in Computer Science, Information Technology, or related fields; or comparable work experience.8+ years of related professional experience including 5+ years in data lake development in large reporting environment(s).Expert in Azure cloud computing, specializing in Azure data engineering stacks like ADF (Azure Data Factory), ADLS, Event Hubs, Snowflake, Databricks, streaming, Azure PowerShell, and Log Analytics.Hands-on development experience with Design and Architecture of big data frameworks/tools: Azure Data Lake, Snowflake, Azure Data Bricks.Expert experience with Hadoop based technology (e.g. Spark) and programming (Python, SQL, PySpark).Knowledgeable about cloud computing costs and performance and capable of providing ongoing suggestions for cost & performance optimization.Solid understanding of Snowflake computing, including its integration with Azure Data Lake, utilizing ADLS as a source for data processing.Experience with Design and Architecture of relational SQL and NoSQL databases, including MS SQL Server, Snowflake.Experience with Azure DevOps, familiar with CI/CD (Continuous Integration/Continuous Deployment) processes and capable of scaling them across engineering teams, leveraging Azure native resources for data ingestion.Experience leading and working with cross-functional teams in a dynamic environment, demonstrated track record of team leadership, technical acumen, innovation, tactical and strategic.Proven verbal, communication, and presentation skills, ability to clearly and concisely communicate complex technical concepts to both technical and non-technical audiences.Proven ability to work independently.Skills/Abilities/Competencies
Advanced hands-on SQL, Spark, Python, PySpark knowledge and experience working with relational databases for data querying and retrieval on multiple platform.Proficiency in Data Modeling tools (e.g. Erwin, Visio).Strong interpersonal and communication skills, both written and verbal.Strong Scrum/Agile development experience.Excellent organizational skills and attention to detail, manage multiple tasks and projects, meet deadlines, follow through, and manage to schedule.Strong innovation capabilities and the ability to think creatively.Strong collaboration and team building skills within, across and outside of an organization.Maintain and promote a positive team environment.Maintains stable performance under pressure, demonstrating sensitivity to diverse organizational culture.Ability to effectively cope with change, remain flexible and adaptable within a fast-paced environment with rapidly changing requirements, and ability to negotiate situations when the big picture is not clearly defined.Preferred Skills/Abilities/Competencies
Strong root cause analysis and problem-solving skills.Ability to juggle multiple projects in a high volume, fast-paced Production environment.Ability to identify process improve opportunities and areas of potential conflict.Working knowledge of MGB data products and platforms a plus.Ability to quickly adapt to new technologies, concepts, and approaches.Familiar with current healthcare and data management trends and industry practices.Demonstrated ability to manage multiple priorities.Microsoft Certified: Azure Solutions Architect Expert (Nice to Have).Microsoft Certified: Azure Data Engineer (Nice to Have).Primary Location
MA-Somerville-MGB Assembly Row
Work Locations
MGB Assembly Row
Job
Data/Analytics
Organization
Mass General Brigham
Schedule
Full-time
Standard Hours
40
Shift
Day Job
Employee Status
Regular
Recruiting Department
MGB Digital
Job Posting
Mar 12, 2024#J-18808-Ljbffr
As a not-for-profit organization, Mass General Brigham is committed to supporting patient care, research, teaching, and service to the community by leading innovation across our system. Founded by Brigham and Women’s Hospital and Massachusetts General Hospital, Mass General Brigham supports a complete continuum of care including community and specialty hospitals, a managed care organization, a physician network, community health centers, home care and other health-related entities. Several of our hospitals are teaching affiliates of Harvard Medical School, and our system is a national leader in biomedical research.
We’re focused on a people-first culture for our system’s patients and our professional family. That’s why we provide our employees with more ways to achieve their potential. Mass General Brigham is committed to aligning our employees’ personal aspirations with projects that match their capabilities and creating a culture that empowers our managers to become trusted mentors. We support each member of our team to own their personal development—and we recognize success at every step.
Our employees use the Mass General Brigham values to govern decisions, actions and behaviors. These values guide how we get our work done: Patients, Affordability, Accountability & Service Commitment, Decisiveness, Innovation & Thoughtful Risk; and how we treat each other: Diversity & Inclusion, Integrity & Respect, Learning, Continuous Improvement & Personal Growth, Teamwork & Collaboration.
Position Overview
We are seeking a highly skilled and experienced Principal Data Engineer to join our dynamic team. As a key member of our data engineering team, you will play a crucial role in designing, developing, and maintaining our data infrastructure and platform integration solutions. The Principal Data Engineer will be responsible for advancing our data engineering capabilities, ensuring data quality, and contributing to the success of data-driven initiatives.
Principal Duties And Responsibilities
Infrastructure, Architecture and Design:
Design end-to-end data solutions on the Azure data platform, considering Scalability, Security, Compliance and Performance.Contribute to technical foundation of the Data Lake platform, expanding and optimizing the data ecosystem and pipeline architecture.Provide expertise in selecting and implementing appropriate data platform services (e.g. Azure, Databricks, Snowflake) for various data processing and storage needs.Collaborate with cross-functional teams to integrate data solutions with existing MGB data platform systems and applications, integrate new data management technologies aligned with the latest vendor products & capabilities (Microsoft Azure and Fabric, Databricks, Snowflake, Collibra, etc.) and software engineering tools into existing structures.Design, develop, construct, test, and maintain Data Lake architectures and large-scale data processing systems.Support big data, data lake, lakehouse ecosystem related tool selection and POC analysis.Data Pipeline Development
Gather and process raw data at scale including large complex data sets, meeting functional/non-functional business requirements (using ADF, Databricks, Python, Pyspark, scripts, REST API calls, SQL Queries, etc.).Develop data set processes for data modeling, mining, and production.Create and maintain optimal data pipeline architecture on cloud-based platforms (e.g., Azure) and relational data systems (SQL Server, SSIS, Snowflakes).Cross-Functional Collaboration
Work on cross-functional teams delivering enterprise solutions for internal and external clients.Collaborate with Software Developers, Database Architects, Data Analysts, and Data Scientists on data initiatives.Support stakeholders, including the Management team, Product owners, and Architecture teams, in addressing data-related technical issues and fulfilling data infrastructure needs.Partner with integrated platform & data science teams to define integrated solutions to meet the evolving needs of data analysts, developers & consumers (e.g. data ingestion framework, AI/ML capabilities, scalable compute), contributing to the innovation and leadership of the organization.Data Optimization And Automation
Identify, design, and implement internal process improvements, automation of manual processes, optimization of data delivery, etc.Build the data infrastructure required for optimal extraction, transformation, and loading of data from traditional/legacy sources.Subject Matter Expertise And Leadership
Act as a subject matter expert for internal or external data products.Contribute to solution architecture design and advise on engineering solution best practices.Mentor and guide junior data engineers by leading code reviews and documenting best practices.Use Mass General Brigham values to govern decisions, actions, and behaviors.Perform other duties and responsibilities as assigned.Minimum Qualifications
Bachelor's or Master's degree in Computer Science, Information Technology, or related fields; or comparable work experience.8+ years of related professional experience including 5+ years in data lake development in large reporting environment(s).Expert in Azure cloud computing, specializing in Azure data engineering stacks like ADF (Azure Data Factory), ADLS, Event Hubs, Snowflake, Databricks, streaming, Azure PowerShell, and Log Analytics.Hands-on development experience with Design and Architecture of big data frameworks/tools: Azure Data Lake, Snowflake, Azure Data Bricks.Expert experience with Hadoop based technology (e.g. Spark) and programming (Python, SQL, PySpark).Knowledgeable about cloud computing costs and performance and capable of providing ongoing suggestions for cost & performance optimization.Solid understanding of Snowflake computing, including its integration with Azure Data Lake, utilizing ADLS as a source for data processing.Experience with Design and Architecture of relational SQL and NoSQL databases, including MS SQL Server, Snowflake.Experience with Azure DevOps, familiar with CI/CD (Continuous Integration/Continuous Deployment) processes and capable of scaling them across engineering teams, leveraging Azure native resources for data ingestion.Experience leading and working with cross-functional teams in a dynamic environment, demonstrated track record of team leadership, technical acumen, innovation, tactical and strategic.Proven verbal, communication, and presentation skills, ability to clearly and concisely communicate complex technical concepts to both technical and non-technical audiences.Proven ability to work independently.Skills/Abilities/Competencies
Advanced hands-on SQL, Spark, Python, PySpark knowledge and experience working with relational databases for data querying and retrieval on multiple platform.Proficiency in Data Modeling tools (e.g. Erwin, Visio).Strong interpersonal and communication skills, both written and verbal.Strong Scrum/Agile development experience.Excellent organizational skills and attention to detail, manage multiple tasks and projects, meet deadlines, follow through, and manage to schedule.Strong innovation capabilities and the ability to think creatively.Strong collaboration and team building skills within, across and outside of an organization.Maintain and promote a positive team environment.Maintains stable performance under pressure, demonstrating sensitivity to diverse organizational culture.Ability to effectively cope with change, remain flexible and adaptable within a fast-paced environment with rapidly changing requirements, and ability to negotiate situations when the big picture is not clearly defined.Preferred Skills/Abilities/Competencies
Strong root cause analysis and problem-solving skills.Ability to juggle multiple projects in a high volume, fast-paced Production environment.Ability to identify process improve opportunities and areas of potential conflict.Working knowledge of MGB data products and platforms a plus.Ability to quickly adapt to new technologies, concepts, and approaches.Familiar with current healthcare and data management trends and industry practices.Demonstrated ability to manage multiple priorities.Microsoft Certified: Azure Solutions Architect Expert (Nice to Have).Microsoft Certified: Azure Data Engineer (Nice to Have).Primary Location
MA-Somerville-MGB Assembly Row
Work Locations
MGB Assembly Row
Job
Data/Analytics
Organization
Mass General Brigham
Schedule
Full-time
Standard Hours
40
Shift
Day Job
Employee Status
Regular
Recruiting Department
MGB Digital
Job Posting
Mar 12, 2024#J-18808-Ljbffr