Lead Integrated Risk Data Architect (Fabric)

Initial Therapeutics, Inc.; Indianapolis (IN); On-site; USD 124,500 - 182,600; Full time

Benefits offered by this job

Company bonus

401(k)

Pension

Vacation benefits

Health benefits

Job summary

Lilly is seeking an Integrated Risk Data Engineer to own the data foundation powering enterprise risk intelligence. This role leads data architecture, builds unified pipelines, and ensures accessible, secure, and governance-driven risk data across the organization.

You will work in the IRM Analytics team, design medallion data models, and deliver datasets powering dashboards, models, and risk assessments while collaborating with data scientists and developers.

Qualifications

• Bachelor's Degree or related field required.
• 5+ years of relevant professional experience in data engineering, ETL, or data integration.

Responsibilities

• Own the Microsoft Fabric architecture for IRM, defining standards and best practices.
• Design, build, and maintain enterprise risk data pipelines using Fabric with medallion architecture.
• Architect and implement data workflows using Fabric Data Factory, Synapse, and Dataflows Gen2.
• Design unified data models and Power BI semantic models for cross-functional risk analytics.
• Establish and own the data governance framework including data quality, validation, monitoring, and access controls.
• Lead data migration and integration initiatives as new risk technologies are adopted.

Skills

Microsoft Fabric

SQL

Python/PySpark

Power BI modelling

Data governance

Data pipelines

Education

Bachelor's Degree in Computer Science, Information Systems, Data Engineering, or related field

Tools

Fabric Data Factory

Synapse Data Engineering

Dataflows Gen2

ServiceNow GRC

Databricks

Power BI

Job description

Lilly is seeking an Integrated Risk Data Engineer to own the data foundation powering enterprise risk intelligence. This role leads data architecture, builds unified pipelines, and ensures accessible, secure, and governance-driven risk data across the organization.

You will work in the IRM Analytics team, design medallion data models, and deliver datasets powering dashboards, models, and risk assessments while collaborating with data scientists and developers.