Senior Data Engineer - Power BI

Technology Senior Data Engineer - Power BI Published: Jun 05

ID: 2128957

Time onsite: required to work in office (~25%, 50% or 100% role dependent) Onsite Location Durham, NC Team Technology Experience Level Manager Job Description: Senior Data Engineer - Power BI Note: Fidelity will not provide immigration sponsorship for this position 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. The Expertise You Have and The Skills You Bring 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. 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. The Team 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. Certifications: Category: Information Technology Please be advised that Fidelity’s business is governed by the provisions of the Securities Exchange Act of 1934, the Investment Advisers Act of 1940, the Investment Company Act of 1940, ERISA, numerous state laws governing securities, investment and retirement-related financial activities and the rules and regulations of numerous self-regulatory organizations, including FINRA, among others. Those laws and regulations may restrict Fidelity from hiring and/or associating with individuals with certain Criminal Histories. Benefits that balance life and work From our fully paid parent leave to our on-site health and wellness centers, our benefits support the belief that more balance you have, the better you can achieve your goals. Company overview Company overview At Fidelity, we are passionate about making our financial expertise broadly accessible and effective in helping people live the lives they want. We are a privately held company that places a high degree of value in creating and nurturing a work environment that attracts the best talent and reflects our commitment to our associates. We are proud of our diverse and inclusive workplace where we respect and value our associates for their unique perspectives and experience. Reasonable accommodations Fidelity will reasonably accommodate applicants with disabilities who need adjustments to participate in the application or interview process. To initiate a request for an accommodation contact the HR Accommodation Team by sending an email to View email address on click.appcast.io, or by calling View phone number on click.appcast.io, prompt 2, option 3. Equal opportunity employer Fidelity Investments is an equal opportunity employer. We believe that the most effective way to attract, develop, and retain a diverse workforce is to build an enduring culture of inclusion and belonging. Applicant screening At Fidelity, we value honesty, integrity, and the safety of our associates and customers within a heavily regulated industry. Certain roles may require candidates to go through a preliminary credit check during the screening process. Candidates who are presented with a Fidelity offer will need to go through a background investigation and may be asked to provide additional documentation as requested. This investigation includes but is not limited to a criminal, civil litigations and regulatory review, employment, education, and credit review (role dependent). These investigations will account for 7 years or more of history, depending on the role. Where permitted by federal or state law, Fidelity will also conduct a pre-employment drug screen, which will review for the following substances: Amphetamines, THC (marijuana), cocaine, opiates, phencyclidine. AI Guidelines Learn about our guidelines for use of AI when applying for a Fidelity job #J-18808-Ljbffr Habitat for Humanity of Durham