Principal Data Engineer

3 months ago

Westlake, United States Fidelity Investments Full time

Job Description

:

Position Description:

Develops Web based applications for database use within Cloud environments – Snowflake and Amazon Web Services (AWS). Designs software capabilities for data engineering, modeling, and analysis in an Oracle Exadata Platform and Snowflake Enterprise Data Lake. Develops and deploys pipelines within a Cloud native infrastructure. Performs data analysis on database platforms using SQL. Develops Extract, Load, Transform/Extract, Transform, Load (ELT/ETL) pipelines using Informatica PowerCenter and schedule jobs (Ctrl-M). Performs Shell scripting and scheduling using programming languages — Python and Spark. Designs, builds, and maintains OBIEE and/or Power BI Reporting Platforms. Coordinates project functionalities using DevOps and Continuous Integration/Continuous Delivery (CI/CD) tools and methodologies. Enhances application-level architecture by delivering Amazon Web Services (AWS) data engineering services across the enterprise. Implements process improvements throughout the Software Development Lifecycle (SDLC) according to Agile methodologies – Kanban and SCRUM.

Primary Responsibilities:

Develops and maintains complex data platforms.

Establishes full project life cycle plans for complex projects across multiple platforms.

Builds data pipelines to facilitate consistent delivery of functional software from release-to-release.

Responsible for meeting project goals on time and on budget.

Plans and coordinates project schedules and assignments for multiple projects.

Builds technical solutions to drive an enhanced data consumption and reports strategy.

Simplifies and communicates technical challenges, solutions options, and recommendations to business partners and technology leadership.

Provides technical leadership and support in data and solutioning to team members. 

Advises senior management on technical strategy. 

Develops, maintains, and enhances Web application reporting.

Leads a team of data engineers to enhance Web applications and enhance and increase the resiliency of reporting platforms.

Builds reliable products using test automation frameworks and Agile methodologies.

Designs, develops, implements, and supports complex technology products on behalf of customers.

Develops and maintains databases according to database warehousing and data mart concepts and principles.

Mentors junior team members.

Education and Experience:

Bachelor’s degree (or foreign education equivalent) in Computer Science, Engineering, Information Technology, Information Systems, Mathematics, Physics, or a closely related field and five (5) years of experience as a Principal Data Engineer (or closely related occupation) performing complex data analysis to implement data warehouse and ETL solutions, in a retirement benefits administration environment.

Or, alternatively, Master’s degree (or foreign education equivalent) in Computer Science, Engineering, Information Technology, Information Systems, Mathematics, Physics, or a closely related field and three (3) years of experience as a Principal Data Engineer (or closely related occupation) performing complex data analysis to implement data warehouse and ETL solutions, in a retirement benefits administration environment.

Skills and Knowledge:

Candidate must also possess:

Demonstrated Expertise (“DE”)designing, implementing, testing, and performing code review of ETL data pipelines to create and perform quality assurance of code, using Informatica workflows, sessions, and mappings; and automating and scheduling jobs in Ctrl-M.

DEperforming database optimization and performance tuning using Realtime SQL; monitoring reports using Oracle Enterprise Manager on an Oracle Exadata Platform (Oracle 12c); optimizing queries, using SQL Profiling and Optimizer Hints; and designing and developing SQL and PL SQL — stored procedures, functions, views, indexes, materialized views, triggers, and partitioning tables — using SQL Developer.

DEperforming data engineering, migration, and modelling in a Cloud based data warehouse platform using Snowflake; and developing code, maintaining version controls, and performing automated deployments using CI/CD tools (GIT, Source Tree, Jenkins and UDeploy).

DE identifying and implementing current and emerging technologies according to enterprise requirements; and gathering and streamlining business requirements to create strong and concise technical specifications.

#PE1M2

Certifications:

  • Principal, Data Engineer

    4 weeks ago

    Westlake, United States Fidelity TalentSource LLC Full time

    Job Description:Principal Data Engineer\u00A0The RoleIf you are an experienced Data Engineer with a passion for crafting and delivering Data solutions using leading-edge technologies, looking for a collaborative team environment where you will have wealth of opportunities to innovate and have intellectual curiosity to learn, a career in the Data Platform...

  • Principal Data Engineer

    3 weeks ago

    Westlake, Ohio, United States Fidelity TalentSource LLC Full time

    Job DescriptionPosition OverviewFidelity TalentSource LLC is seeking a highly skilled Principal Data Engineer to join our team. As a Principal Data Engineer, you will be responsible for designing, developing, and implementing scalable and efficient data architectures using data warehousing solutions, including Amazon Redshift, Oracle, Snowflake, and ETL...

  • Principal Data Engineer

    2 months ago

    Westlake, United States Fidelity TalentSource LLC Full time

    Job Description:Position Description: ***Multiple Positions Available*** Develops PL/SQL and Extract Transfer and Load (ETL) code using Oracle and Informatica to ensure other teams have the correct data. Works in an agile manner within squad and across other teams to deliver and release valuable source code to the application and its users, uses JIRA....

  • Principal Data Engineer

    4 days ago

    Westlake, United States Fidelity TalentSource LLC Full time

    Job Description:We are looking for an experience Data Engineer with a passion for crafting and delivering Data solutions, collaborating in a team environment, with a deep interest in building products that make it easier for our customers to service their client! The Team This is an exciting role within the Workplace Investing (WI) Solutions Office team. Our...

  • Principal Data Modeler

    18 hours ago

    Westlake, Ohio, United States Fidelity Investments Full time

    Job Title: Principal Data ModelerAt Fidelity Investments, we are seeking a highly skilled Principal Data Modeler to join our team. As a key member of our Customer Data and Marketing Technology group, you will play a critical role in enabling our application and data engineers to build and maintain large-scale data processing systems for analytical and...

  • Data Engineer

    2 days ago

    Westlake, Ohio, United States Fidelity TalentSource LLC Full time

    Job Title: Principal Data EngineerFidelity TalentSource LLC is seeking a highly skilled Principal Data Engineer to join our team. As a key member of our Customer Data Technology group, you will play a critical role in our migration to the Cloud.The RoleAs a Principal Data Engineer, you will be responsible for designing and implementing cloud-based data...

  • Principal Data Modeler

    3 days ago

    Westlake, Ohio, United States Fidelity Investments Full time

    Job Description:As a Principal Data Modeler at Fidelity Investments, you will play a critical role in designing and developing our next-generation data platforms. You will collaborate with cross-functional teams to understand data requirements and create data models that align with business needs.The ideal candidate will have a strong background in data...

  • Principal Software Engineer

    4 weeks ago

    Westlake, Ohio, United States Fidelity TalentSource LLC Full time

    Job Overview:Principal Full Stack EngineerPosition SummaryAre you a seasoned Principal Full Stack Engineer with a strong inclination towards crafting and implementing innovative data solutions utilizing cutting-edge technologies? Would you like to contribute to a recommendation platform that fosters a collaborative environment, providing ample opportunities...

  • Principal Software Engineer Data

    1 week ago

    Westlake, TX, United States Fidelity Investments Full time

    Principal Data Modeler – RDBMS/DATA WAREHOUSING/OLAP/SNOWFLAKE/CLOUD As a Data Modeler, the candidate will collaborate with collaborators and multi-functional teams, Architects, Tech Leads and senior development resources across our team, as well as other technical and business collaborators across the organization in a fast paced agile environment to...

  • Principal Software Engineer/Developer

    15 minutes ago

    Westlake, Ohio, United States Fidelity TalentSource LLC Full time

    Job Description:As a Principal Software Engineer/Developer at Fidelity Investments, you will play a key role in designing, developing, and implementing scalable and secure software solutions for our clients. You will work closely with cross-functional teams to deliver technology solutions that meet business needs, using data architecture patterns and DevOps...

  • Principal Software Engineer

    4 days ago

    Westlake, Ohio, United States Fidelity Investments Full time

    Job Title: Principal, Full Stack EngineerAbout the Role:Fidelity Investments is seeking a highly skilled Principal, Full Stack Engineer to join our Enterprise Technology team. As a key member of our Agile scrum team, you will be responsible for designing, developing, and deploying scalable and secure software solutions that meet the needs of our business...

  • Senior Data Engineer

    2 weeks ago

    Westlake, Ohio, United States Fidelity TalentSource LLC Full time

    Job DescriptionPosition OverviewFidelity TalentSource LLC is seeking a highly skilled Principal Data Engineer to join our team. As a Principal Data Engineer, you will be responsible for designing, developing, and implementing scalable and efficient data architectures using data warehousing solutions, including Amazon Redshift, Oracle, and Snowflake. You will...

  • Senior Fullstack Principal Software Engineer

    5 days ago

    Westlake, Texas, United States Fidelity Investments Full time

    Job Title: Senior Fullstack Principal EngineerWe are seeking a highly skilled and experienced Senior Fullstack Principal Engineer to join our team at Fidelity Investments. As a key member of our engineering team, you will be responsible for designing and implementing web applications that meet the highest standards of quality and performance.Key...

  • Principal Software Engineer/Developer

    5 days ago

    Westlake, Ohio, United States Fidelity TalentSource LLC Full time

    Job Title: Principal Software Engineer/DeveloperJob Summary:Fidelity Investments is seeking a highly skilled Principal Software Engineer/Developer to join our team. As a key member of our software development team, you will be responsible for designing and implementing Customer Relationship Management (CRM) solutions using Salesforce platforms.Key...

  • Principal Network Engineer

    2 weeks ago

    Westlake, Texas, United States Fidelity Investments Full time

    Job DescriptionThe Network Core and Site Engineering team at Fidelity Investments is responsible for designing, engineering, and implementing the company's datacenter and co-location core network routing and switching. We are seeking a Principal Network Engineer to join our team and contribute to the stability, automation, and innovation of our network...

  • Senior Fullstack Principal Software Engineer

    6 days ago

    Westlake, Texas, United States Fidelity Investments Full time

    Job Title: Senior Fullstack Principal EngineerWe are seeking a highly skilled Senior Fullstack Principal Engineer to join our team at Fidelity Investments. As a key member of our engineering team, you will be responsible for designing and implementing web applications that deliver exceptional user experiences.Key Responsibilities:Design and implement robust...

  • Principal Software Engineer

    2 days ago

    Westlake, Texas, United States Fidelity Investments Full time

    Job Title: Principal Software EngineerAbout the RoleWe are seeking a highly skilled Principal Software Engineer to join our Common Library Team at Fidelity Digital Assets. As a key member of our team, you will design and build common capabilities that support projects spanning multiple engineering groups. Your expertise will be instrumental in creating...

  • Principal Research Engineer

    22 hours ago

    Westlake, Ohio, United States GKN Aerospace Inc Full time

    Job SummaryAs a Principal Research Engineer at GKN Aerospace Inc, you will be part of a cross-discipline team developing innovative additive manufacturing (AM) technology for aerospace structural applications.Key ResponsibilitiesSupport AM process development by researching and executing experiments to develop and characterize titanium and other aerospace...

  • Principal Site Reliability Engineer

    1 week ago

    Westlake, Ohio, United States Qualitative Financials Full time

    About the RoleWe are seeking a highly skilled Principal Site Reliability Engineer to join our team at Qualitative Financials. As a key member of our Non-Prod Environment Stability organization, you will play a critical role in improving the stability and reliability of our test environments.Key ResponsibilitiesTroubleshoot complex issues in test environments...

  • Principal, Software Engineer

    1 week ago

    Westlake, United States Fidelity Investments Full time

    Fidelity is hiring a Principal Software Engineer- Java API Development Platform.As a lead engineer on the team, your primary role will be building, testing, and engineering REST APIs on our API marketplace platform which is hosted on Open source API gateway.8+ years of development experience (currently hands on) in Java, Spring MVC / Spring boot / Web...