Senior Data Engineer - Power BI

Based in Durham, North Carolina, this on-site Senior Data Engineer position concentrates on Power BI within Fidelity Investments' Cyber Data Analytics team, delivering scalable data pipelines, data models, and analytics to support cybersecurity decision-making.

Responsibilities

• Strengthen data protection product areas by designing scalable data solutions, including intricate pipelines, migrations, and advanced data modeling.
• Provide high-impact analytics to multiple executive leaders to inform strategic decisions.
• Identify new development opportunities within a scalable public cloud environment to expand organizational capabilities.
• Collaborate with product owners and business partners to convert strategic requirements into concrete technical tasks.
• Analyze and transform datasets to ensure data integrity, accessibility, and security across the data lifecycle.
• Act as a technical mentor and thought leader, offering guidance and innovative solutions to the broader team.
• Incorporate automated testing and continuous validation within the sprint cycle to maintain production reliability.
• Develop end-to-end solutions using distributed platform design patterns and modern analytics technologies.
• Support and enhance production systems with a focus on performance, speed, and overall reliability.

Requirements

• Bachelor’s or Master’s degree in computer science, engineering, or a related technical field.
• 7+ years of relevant experience in data engineering or data architecture.
• Strong SQL skills with hands-on experience across Snowflake (SnowSQL), PostgreSQL, SQL Server, and Oracle.
• Proven ability to build data pipelines with Python; knowledge of NiFi and dbt is a significant advantage.
• Experience creating Power BI reports that translate data into visually compelling visuals.
• Hands-on experience with AWS infrastructure, including S3, EC2, RDS, EKS, Batch, and CloudFormation.
• Solid understanding of data modeling principles, including 3NF and Star Schema designs.
• Experience with CI/CD workflows using Jenkins and GitHub for automated deployment.
• Familiarity with workload scheduling and orchestration tools such as Control-M.
• Proven ability to analyze data to ensure quality attributes like accuracy, consistency, and completeness, and to identify gaps and anomalies.
• Ability to work independently in an Agile environment (Scrum and Kanban) to deliver technical stories.
• Excellent communication and presentation skills.

Technologies

• Power BI
• Snowflake
• SnowSQL
• PostgreSQL
• SQL Server
• Oracle
• Python
• NiFi
• dbt
• AWS
• S3
• EC2
• RDS
• EKS
• Batch
• CloudFormation
• Jenkins
• GitHub
• Control-M

The Team

Our Cyber Data Analytics Squad leads enterprise cybersecurity analytics, within the Enterprise Cyber Security organization. The team comprises data scientists, analysts, engineers, and cybersecurity experts, collaborating to deliver innovative analytics solutions and supporting a proactive security posture.