Senior Data Engineer - Power BI

Fmr LLC
Durham, United States of America
1 month ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Durham, United States of America

Tech stack

Third Normal Form
Agile Methodologies
Amazon Web Services (AWS)
Amazon Web Services (AWS)
Business Analytics Applications
Data analysis
Automation of Tests
Computer Security
Continuous Integration
Information Engineering
Data Integrity
Relational Databases
Database Queries
Github
Python
PostgreSQL
Microsoft SQL Server
Oracle Applications
Power BI
Snowflake
Reliability of Systems
Cloudformation
Build Management
Amazon Web Services (AWS)
Information Technology
Deployment Automation
Cybercrime
Data Analytics
Star Schema
Apache Nifi
Data Pipelines
Jenkins
Control M

Job description

The Cyber Data Analytics chapter within the Enterprise Cybersecurity organization is seeking a Senior Data Engineer to join our team. You will be at the forefront of fortifying data protection product areas by building scalable data solutions, including complex data pipelines, migrations, and sophisticated data modeling. Our team serves as a proactive shield against cyber threats, supporting multiple executive leaders with high-impact analytics for decision-making., * Serve as a technical mentor and thought leader, providing guidance and innovative solutions to the broader team.

  • Integrate automated testing and continuous validation into the sprint cycle to ensure production reliability.
  • Develop end-to-end solutions using distributed platform design patterns and modern analytics technologies.
  • Support and enhance production systems, focusing on high performance, speed, and overall system reliability., Our Cyber Data Analytics Squad is at the forefront of enterprise cybersecurity, dedicated to providing brand new data analytics solutions. We are part of the Enterprise Cyber Security organization. Our team boasts a diverse range of skills, including data scientists, analysts, engineers, and cybersecurity experts. Together, we build a dynamic environment that fosters innovation and problem-solving, envisioning a future where our analytics solutions serve as a proactive shield against cyber threats.

Requirements

Do you have experience in Snowflake?, * Bachelor's or Master's degree in computer science, Engineering, or a related technical field.

  • 7+ years of relevant work experience in data engineering or architecture.
  • Strong SQL skills and knowledge of multiple RDBMS, specifically Snowflake (including SnowSQL), Postgres, SQL Server, and Oracle.
  • Proven experience building data pipelines using Python, with NiFi and dbt knowledge being a significant advantage.
  • Experience in building Power BI Reports that transform data into aesthetically appealing visuals.
  • Hands-on knowledge of AWS infrastructure, including S3, EC2, RDS, EKS, Batch, and CloudFormation.
  • Deep understanding of data modeling principles, specifically 3NF and Star Schema models.
  • Experience with CI/CD workflows using Jenkins and GitHub for automated deployment.
  • Familiarity with workload scheduling and orchestration tools like Control-M.
  • Proven data analysis skills to ensure data quality such as accuracy, consistency, and completeness and to identify gaps and anomalies.
  • Ability to work independently in an Agile environment (Scrum and Kanban) brings technical stories to completion.
  • Excellent communication and presentation skills
  • Design and build scalable data solutions, including data processing pipelines, migrations, and complex data modeling.
  • Identify new development opportunities within a scalable public Cloud environment to enhance organizational capability.
  • Collaborate with product owners and business partners to translate high-level requirements into actionable technical tasks.
  • Analyze and manipulate datasets to ensure rigorous data integrity, accessibility, and security throughout the entire lifecycle.

Apply for this position