Data Engineer OCMO Business Intelligence-(3299838) - Partners Healthcare System

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.

Data Engineer OCMO Business Intelligence

Principal Duties and Responsibilities

·Works with cross-functional teams to understand functional product requirements and deliver on strategic data and analytics initiatives

·Design, build, test and maintain architectures within the OCMO space of our cloud-based enterprise data warehouse.

·Build ETL/ELT ingestions for OCMO related data, and handle related monitoring and support duties.

·Define and implement the processes and tooling through which enterprise curated data models are built and maintained.

·Partners with data analysts and data visualization developers to understand data extraction and transformation needs, and builds a platform and related processes suited to them.

·Develop and enforce change management and versioning processes for code promotion.

·In collaboration with lead analytic staff, architect and enforce thorough quality assurance, testing and peer review procedures to ensure the accuracy, reliability, and validity of end products.

·Proactively monitor performance and identify application bottlenecks, and develop applicable solutions.

·Triage, troubleshoot and resolve data issues from end users and internal team members.

·Partner with the MGB Digital team to leverage existing tools, methods, and practices to efficiently develop modeling solutions, ensure that work is not duplicated, and is appropriately transitioned between teams.

·Uses 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

·Other duties and responsibilities as assigned

Qualifications

·Bachelor's or Master’s degree in computer science, informatics, statistics, or related field and an interest in healthcare and the use of technology to support clinical care

·1-3 years of experience as an Analytics Engineer, Data Engineer, or similar role

·1-3 years of experience in business intelligence/analytics, preferably working with healthcare data

·Experience working with cloud data platforms such as Snowflake, Azure Synapse, Amazon Redshift, etc.

·Experience implementing scalable ETL/ELT pipelines

·Experience with transforming and modeling workflow tools, such as dbt or Informatica

·Proficiency in querying complex data structures using SQL is required

·Strong programming skills and proficient in other programming languages (e.g., SAS, R, and Python)

·Experience with general source control principles and implementing CI/CD pipelines.

·Working knowledge of traditional data warehousing and cloud data warehousing concepts

·Working knowledge of data visualization (Tableau) software a plus

·Proficiency or Certification in Epic Clarity / Caboodle data model a plus

Skills/Abilities/Competencies

·Ability to function effectively and independently in a fast-paced environment, organize and prioritize work independently, and meet tight deadlines

·Ability to manage multiple projects simultaneously, set priorities, and collaborate with team members and others throughout the organization

·Possess strong interpersonal skills to effectively communicate with cross functional teams including staff at all levels of the organization

·Willing to contribute to and foster a team player culture where all are encouraged and willing to share information accurately.

·Able and motivated to mentor/train junior staff members.

·Knowledge of agile principles and experience working within an agile team is preferred

·Practical problem-solving abilities, i.e. the ability to formulate hypotheses, test options and move forward in a fast-paced environment

·Excellent interpersonal skills, including strong customer service orientation and the ability to translate complex technical concepts to non-technical audiences.

·Advanced SQL DML skills required, with comparable experience in writing data functions (e.g. TSQL procs, Snowflake UDFs, etc).

Mass General Brigham is an Equal Opportunity Employer. By embracing diverse skills, perspectives, and ideas, we choose to lead. All qualified applicants will receive consideration for employment without regard to race, color, religious creed, national origin, sex, age, gender identity, disability, sexual orientation, military service, genetic information, and/or other status protected under the law. We will ensure that all individuals with a disability are provided a reasonable accommodation to participate in the job application or interview process, perform essential job functions, and receive other benefits and privileges of employment.