Data and Analytics Engineer

Center for Organ Recovery and Education

Pittsburgh (Allegheny County)

On-site

USD 120,000 - 160,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Center-For-Organ-Recovery-and-Educa seeks a Data and Analytics Engineer to design, build, and maintain a scalable analytics data platform. You will implement dimensional models, automate ETL/ELT pipelines, and ensure data quality, security, and governance across enterprise data sets for reporting, analytics, and AI readiness.

You will collaborate with executives and SMEs to translate requirements into robust technical solutions, maintain platform reliability, and support Power BI and other

Qualifications

  • Strong SQL skills and experience with data warehousing.
  • Hands-on experience with dimensional modeling and star schemas.
  • Proven ability to design and manage ETL/ELT pipelines.
  • Experience with data governance, metadata, and data quality controls.
  • Knowledge of data security and privacy requirements.

Responsibilities

  • Design, build, and maintain enterprise analytics data structures and data warehouse.
  • Automate data acquisition and integration across systems via ETL/ELT processes.
  • Ensure platform reliability, security, and performance with monitoring and documentation.
  • Collaborate with stakeholders to translate requirements into technical solutions.
  • Prepare governance artifacts, lineage, and data dictionaries.

Skills

Advanced SQL
Dimensional modeling
ETL/ELT design
Data governance
Data quality
Security and encryption
Cloud platforms
Analytics tools

Education

Bachelor's degree in Computer Science or related field

Tools

SSIS / Azure Data Factory
Azure Synapse
Power BI
Git / Source control

Job description

Position Summary:The Data and Analytics Engineer designs, builds, secures, and maintains CORE's enterprise analytics data platform. This hands-on position establishes a scalable and governed data warehouse using dimensional modeling, including fact and dimension tables; automates data acquisition and integration through ETL or ELT processes; and delivers reliable, reusable data structures for reporting, advanced analytics, and future artificial intelligence capabilities.Working under the supervision of the Chief Information and Supply Chain Officer, the engineer supports CORE's donor management system and integration of clinical, operational, financial, workforce, and other enterprise data. The position partners closely with the Chief Performance Officer, Performance Team, Data Analyst, system owners, vendors, and business and clinical subject matter experts to translate approved requirements into sustainable technical solutions. The engineer is responsible for platform reliability, technical data quality, security, performance, monitoring, documentation, and controlled change management.Essential Job Functions:Data warehouse architecture and dimensional modeling -Design, build, and maintain scalable analytics data structures, including fact and dimension tables, conformed dimensions, defined grain, keys, historical tracking, schemas, views, stored procedures, and reusable transformation layers. Establish architecture standards that support enterprise reporting and analysis.Data integration automation and migration support - Develop, test, deploy, monitor, and maintain ETL or ELT pipelines that integrate data from the donor management system and other clinical, operational, financial, workforce, and enterprise systems. Use appropriate database connections, APIs, secure file transfers, incremental loads, and migration processes. Support source-to-target mapping, historical conversion, reconciliation, and cutover activities.Platform operations security and reliability - Manage the technical operation of the analytics platform, including role-based access, secrets and connection management, environment separation, deployment controls, performance tuning, capacity monitoring, backup and recovery coordination, and incident troubleshooting. Maintain appropriate development, testing, and production practices.Data quality testing metadata and lineage - Implement automated and repeatable controls for completeness, validity, timeliness, duplicates, referential integrity, and reconciliation. Maintain technical metadata, data lineage, source-to-target mappings, transformation logic, data dictionaries, runbooks, and pipeline documentation. Coordinate exceptions with the Data Analyst, Performance Team, and data owners.Analytics semantic models and AI readiness - Develop and maintain curated datasets and governed semantic models that support Power BI, advanced analytics, and approved AI use cases. Organize data so it is reusable, well-described, appropriately secured, and suitable for controlled analytical and AI experimentation. Support technical prototypes when requested.Requirements collaboration governance and professional development - Translate approved requirements into technical designs and estimates; participate in data governance, project, vendor, and departmental meetings; communicate risks and dependencies; complete assigned action items; and maintain relevant knowledge of data engineering, cloud platforms, security, analytics, and responsible AI practices.Promotes the Mission, Vision, and Core Values of CORE.Maintains confidentiality of all employee and donor/recipient information.Perform other duties and special projects as assigned.Non-Essential Job Functions:Participate in committees, workgroups, and special organizational initiatives as assigned.Provide backup support for approved analytics-platform operations, data integrations, and technical documentation.Represent CORE in external professional associations, conferences, or user groups when assigned.Required Education and Experience:Bachelor's degree in computer science, information systems, data engineering, software engineering, data science, analytics, or a related field, or equivalent education and directly relevant experience.Five or more years of experience in data engineering, data warehousing, analytics engineering, business intelligence engineering, or database development, including hands-on responsibility for production data solutions.Advanced SQL skills, including database design, complex queries, stored procedures, query optimization, troubleshooting, and performance tuning in SQL Server or a comparable relational database platform.Demonstrated experience with dimensional data modeling, including fact and dimension tables, grain, surrogate keys, conformed dimensions, historical tracking, and star-schema design.Experience designing and operating ETL or ELT pipelines across databases, APIs, secure files, and other enterprise sources, including incremental processing, error handling, monitoring, and recovery.Experience with source control, structured testing, release management, operational monitoring, and separation of development, testing, and production environments.Experience implementing data-quality controls, reconciliation, metadata, lineage, and operational documentation.Knowledge of data security, role-based access, encryption, credential management, and privacy requirements for confidential information.Strong analytical, problem-solving, organizational, documentation, and communication skills.Preferred Education and Experience:Experience with SQL Server, SSIS, Azure Data Factory, Microsoft Fabric, Azure Synapse, Power BI semantic models, SSRS, or comparable cloud and hybrid data platforms.Experience in healthcare, organ procurement, transplantation, clinical operations, or another regulated and mission-critical environment.Experience with Python, PowerShell, PySpark, APIs, and healthcare interoperability formats or standards such as HL7 or FHIR.Experience preparing governed data for forecasting, predictive analytics, machine learning, natural-language interfaces, or other responsible AI use cases.Experience with data governance, master and reference data, data catalogs, infrastructure as code, CI and CD practices, or relevant technical certifications.Work Authorization/Security Clearance RequirementsMust be legally authorized to work in the United States. Employment is contingent upon successful completion of a background investigation conducted by CORE and satisfactory results in accordance with CORE requirements.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data and Analytics Engineer
Data and Analytics Engineer

Core • Pittsburgh

On-site
USD 110,000 - 160,000
Manager, Data Engineering
Manager, Data Engineering

Beacon Health System • Granger (IN)

On-site
USD 120,000 - 180,000
Sr. Data Engineer
Sr. Data Engineer

ProArch • United States

Remote
USD 140,000 - 190,000
Sr. Data Engineer
Sr. Data Engineer

ProArch • Atlanta (GA)

On-site
USD 120,000 - 180,000
Enterprise Epic Architect (Onsite)
Enterprise Epic Architect (Onsite)

Reid Health • United States

On-site
USD 150,000 - 210,000
Sr. Data Engineer
Sr. Data Engineer

ProArch • Oregon

Hybrid
USD 130,000 - 180,000
Enterprise Epic Architect
Enterprise Epic Architect

Interscripts, Inc. • Richmond (VA)

Hybrid
USD 150,000 - 230,000
Data & Integration Engineer
Data & Integration Engineer

compasshealthcenter • Chicago (IL)

On-site
USD 110,000 - 170,000
Senior Data Analyst
Senior Data Analyst

Avem Health Partners • Oklahoma City (OK)

On-site
USD 90,000 - 140,000
Analytics Data Engineer
Analytics Data Engineer

Saint Francis Health System • Bixby (OK)

On-site
USD 90,000 - 120,000