Principal Data Engineer

<h2></h2><h2>Job Description:</h2><p style="text-align:inherit"></p><div><div><p><u><span>Position Description</span></u><span><span>:</span></span><span> </span></p></div><div><p><span> </span></p></div><div><p><span><span>***Applicants are<span> </span></span><span>permitted</span><span><span> </span>to work remotely from an at home worksite anywhere in the United<span> </span></span><span>States.*</span><span>**</span></span><span> </span></p></div><div><p><span> </span></p></div><div><p><span><span>Designs and implements single and multi-tenant data solutions using cloud database technologies. Develops and implements Proof of Concepts (</span><span>PoCs</span><span>), frameworks, and real-time pipelines, using SQL, Amazon Web Services (AWS), Snowflake, and Python. Manages data integration, ensuring high data quality and accessibility, using Snowflake and Extract, Transform, Load (ETL) / Extract, Load, Transform (ELT) tools (Informatica). Builds RESTful APIs using Spring Boot, Java, and Python. Develops scalable and robust data solutions for websites using SQL, MySQL, and SQLMI. Builds,<span> </span></span><span>maintains</span><span>, and performs tunning of stored procedures.<span> </span></span><span>Assists</span><span><span> </span>in planning and execution of user acceptance testing. Proposes modifications and improvements based on user needs</span><span>. </span></span><span> </span></p></div><div><p><span> </span></p></div><div><p><u><span>Primary Responsibilities:</span></u><span> </span></p></div><div><p><span> </span></p></div><div><ul><li><p><span><span>Participates in architecture design teams.</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Defines and implements<span> </span></span><span>application level</span><span><span> </span>architecture.</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Develops applications on complex projects, components, and subsystems for the division.</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Recommends<span> </span></span><span>development</span><span><span> </span>testing tools and methodologies and reviews and validates test plans. </span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Responsible for QA readiness of software deliverables. </span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Develops</span><span><span> </span>comprehensive documentation for multiple applications or subsystems.</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Establishes full project life cycle plans for complex projects across multiple platforms.</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Responsible for meeting project goals<span> </span></span><span>on-time</span><span><span> </span>and<span> </span></span><span>on-budget</span><span>.</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Advises on</span><span><span> </span>risk assessment and risk management strategies for projects.</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Plans and coordinates project schedules and assignments for multiple projects.</span></span><span> </span></p></li></ul></div></div><div><div><ul><li><p><span><span>Acts as a primary liaison for business units to resolve various project/technology issues.</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Provides technology solutions to daily issues and technical evaluation estimates on technology initiatives.</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Advises</span><span><span> </span>senior management on technical strategy.</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Mentors junior team members.</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Develops comprehensive documentation for multiple applications in support of corporate initiatives.</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Performs independent and complex technical and functional analysis for multiple simultaneous projects.</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Confers</span><span><span> </span>with systems analysts and other software engineers/developers to design systems and to obtain information on project limitations and capabilities, performance<span> </span></span><span>requirements</span><span><span> </span>and interfaces</span><span>.</span></span><span> </span></p></li></ul></div><div><p><span> </span></p></div><div><p><span> </span></p></div><div><p><u><span>Education and Experience</span></u><span><span>:</span></span><span> </span></p></div><div><p><span> </span></p></div><div><p><span><span>Bachelor’s degree in Computer Science</span><span>, Engineering, Information Technology, Information Systems, or a closely related field (or foreign education equivalent) and five (5) years of experience as a Principal Data Engineer (or closely related occupation) developing ETL framework to transfer files, creating PL/SQL scripts, and creating implementation plan during production implementation</span><span>.</span></span><span> </span></p></div><div><p><span> </span></p></div><div><p><span><span>Or, alternatively,<span> </span></span><span>Master’s degree in Computer Science</span><span>, Engineering, Information Technology, Information Systems, or a closely related field (or foreign education equivalent) and three (3) years of experience as a Principal Data Engineer (or closely related occupation) developing ETL framework to transfer files, creating PL/SQL scripts, and creating implementation plan during production implementation</span><span>.</span></span><span> </span></p></div><div><p><span> </span></p></div><div><p><span> </span></p></div><div><p><u><span>Skills and Knowledge</span></u><span><span>:</span></span><span> </span></p></div><div><p><span> </span></p></div><div><p><span><span>Candidate must also<span> </span></span><span>possess</span><span>:</span></span><span> </span></p></div><div><p><span> </span></p></div></div><div><div><ul><li><p><span><span>Demonstrated Expertise (“DE”)<span> </span></span><span>performing conceptual data modeling, designing, and developing multi-tenant data solutions for websites using MySQL Workbench, and<span> </span></span><span>DataGrip</span><span>;</span><span><span> </span>coordinating database operations and data storage and retrieval using SQL, stored procedures, and triggers on MySQL, Snowflake, and Cloud technologies</span><span>.</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>DE<span> </span></span><span>performing ETL, ELT, and data integration processes with complex data transformations, using SQL, Python,<span> </span></span><span>PowerDesigner</span><span>, Unix shell scripting, and JSON/ XML Parsing; performing full life cycle analysis and development of Operational and Transactional applications built using Angular; and tuning SQL query performance using TOAD, SQL Developer, and MySQL workbench</span><span>. </span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>DE<span> </span></span><span>interpreting requirements within an Agile environment and developing APIs to move data to and from multiple sources including files and Application Programming Interfaces</span><span><span> </span></span><span>(APIs) to<span> </span></span><span>on-premise</span><span><span> </span>or Cloud databases (AWS or Azure) using<span> </span></span><span>SpringBoot</span><span>, Java, and Python</span><span>. </span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>DE<span> </span></span><span>applying Continuous <span style="overflow-wrap: break-word; display: inline; text-decoration: inherit; hyphens: auto;">Integration/Continuous</span> Deployment (CI/CD) practices to database releases</span><span><span> </span></span><span>-- automated deployments</span><span><span> </span></span><span>-- using Jenkins,<span> </span></span><span>JenkinsCore</span><span><span> </span>and Urban Code Deploy (</span><span>uDeploy</span><span>), applying SDLC best practices -- source code management (Git, Stash, and SourceTree) and documentation using software<span> </span></span><span>--<span> </span></span><span>Atlassian Confluence and draw.io</span><span>.</span></span><span> </span></p></li></ul></div><div><p><span> </span></p></div><div><p><span> </span></p></div><div><p><span><span>Salary:</span></span><span><span> </span></span><span><span>$</span><span>141,450.00</span><span><span> </span>- $166,000.00/</span><span>year.</span></span><span> </span></p></div><div><p><span> </span></p></div><div><p><span><span>#</span><span>PE1M2</span></span><span> </span></p></div><div><p><span><span>#LI-DNI</span></span></p></div></div><h1></h1><h2></h2><p style="text-align:inherit"></p><h2>Certifications:</h2><h2></h2><p style="text-align:inherit"></p><h2>Category:</h2><h2></h2>Information Technology<p style="text-align:left"><span>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.</span></p>