Analyst - Risk Data Engineer

Role Summary

The Risk Data Engineer creates the data foundation that powers risk intelligence across the enterprise by integrating fragmented systems, building unified data pipelines, and ensuring risk leaders have access to complete, accurate, and timely risk data. You will architect and implement data solutions using Microsoft Fabric that connect disparate risk platforms into cohesive data ecosystems that enable comprehensive risk visibility. This role focuses on designing and maintaining robust data infrastructure, implementing data pipelines and transformation workflows, and establishing data governance frameworks to ensure data quality, security, and accessibility across all IRM functions.

Responsibilities

• Design, build, and maintain enterprise risk data pipelines using Microsoft Fabric with medallion architecture (bronze, silver, gold layers) that integrate data from multiple risk domains and enterprise systems
• Implement data engineering workflows using Fabric Data Factory, Synapse Data Engineering (Spark notebooks), and Dataflows Gen2 to consolidate fragmented risk data from ServiceNow GRC, SAP, Workday, SuccessFactors, assurance platforms, and other enterprise and function-specific systems
• Create unified data models and Power BI semantic models that enable cross-functional risk analytics, ensuring data consistency, accuracy, and accessibility across all risk functions
• Develop and maintain data quality frameworks, validation rules, and monitoring processes that ensure leadership has reliable, credible risk intelligence
• Establish and enforce data governance standards, security protocols, and access controls that protect sensitive risk information while enabling appropriate data sharing

Qualifications

• Required: Bachelor's Degree in Computer Science, Information Systems, Data Engineering, or related field
• Required: 3+ years of relevant professional experience in data engineering, ETL development, or data integration
• Required: Strong proficiency with Microsoft Fabric or similar cloud data platforms (Azure Data Factory, Synapse Analytics, Databricks)
• Required: Advanced SQL skills and experience with both relational and non-relational database technologies
• Required: Experience designing and implementing ETL processes and data pipelines
• Required: Demonstrated ability to translate business requirements into technical data solutions
• Required: Understanding of Power BI data modeling and semantic model design
• Required: Qualified applicants must be authorized to work in the United States on a full-time basis
• Preferred: Hands-on experience with Microsoft Fabric components including Data Factory, Synapse Data Engineering, Data Warehouse, Lakehouse, and Dataflows Gen2
• Preferred: Experience implementing medallion architecture or similar layered data lake design patterns
• Preferred: Knowledge of Power BI semantic models, DirectLake, and optimizing datasets for analytical performance
• Preferred: Experience with ServiceNow platform, ServiceNow GRC, or other governance, risk, and compliance systems
• Preferred: Proficiency in dimensional modeling, star schema design, and data warehouse concepts
• Preferred: Experience in pharmaceutical, healthcare, or highly regulated industries with complex data governance requirements
• Preferred: Background in risk management, audit, compliance, or assurance domain data
• Preferred: Familiarity with Power Platform integration (Power Automate, Power Apps) with Fabric
• Preferred: Strong problem-solving skills with ability to diagnose and resolve sophisticated data integration challenges
• Preferred: Excellent collaboration skills with both technical teams and non-technical business stakeholders
• Preferred: Detail-oriented with commitment to data quality and comprehensive documentation
• Preferred: Self-starter who works independently and proactively identifies opportunities for improvement
• Preferred: Demonstrated strong motivation, rapid learning agility, and growth mindset

Education

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

Additional Requirements

• Travel: Up to 5-10% travel based on business needs