***Applicants arepermittedto work remotely from an at home worksite anywhere in the UnitedStates.***

Designs and implements single and multi-tenant data solutions using cloud database technologies. Develops and implements Proof of Concepts (PoCs), 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,maintains, and performs tunning of stored procedures.Assistsin planning and execution of user acceptance testing. Proposes modifications and improvements based on user needs 

Primary Responsibilities:

• Participates in architecture design teams.

• Defines and implementsapplication levelarchitecture.

• Develops applications on complex projects, components, and subsystems for the division.

• Recommendsdevelopmenttesting tools and methodologies and reviews and validates test plans.

• Responsible for QA readiness of software deliverables.

• Developscomprehensive documentation for multiple applications or subsystems.

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

• Responsible for meeting project goalson-timeandon-budget

• Advises onrisk assessment and risk management strategies for projects.

• Plans and coordinates project schedules and assignments for multiple projects.

• Acts as a primary liaison for business units to resolve various project/technology issues.

• Provides technology solutions to daily issues and technical evaluation estimates on technology initiatives.

• Advisessenior management on technical strategy.

• Mentors junior team members.

• Develops comprehensive documentation for multiple applications in support of corporate initiatives.

• Performs independent and complex technical and functional analysis for multiple simultaneous projects.

• Conferswith systems analysts and other software engineers/developers to design systems and to obtain information on project limitations and capabilities, performancerequirementsand interfaces

Education and Experience

Bachelor’s degree in Computer Science, 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

Or, alternatively,Master’s degree in Computer Science, 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

Skills and Knowledge

Candidate must alsopossess

• Demonstrated Expertise (“DE”)performing conceptual data modeling, designing, and developing multi-tenant data solutions for websites using MySQL Workbench, andDataGrip;coordinating database operations and data storage and retrieval using SQL, stored procedures, and triggers on MySQL, Snowflake, and Cloud technologies

• DEperforming ETL, ELT, and data integration processes with complex data transformations, using SQL, Python,PowerDesigner, 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

• DEinterpreting requirements within an Agile environment and developing APIs to move data to and from multiple sources including files and Application Programming Interfaces(APIs) toon-premiseor Cloud databases (AWS or Azure) usingSpringBoot, Java, and Python

• DEapplying Continuous Integration/Continuous Deployment (CI/CD) practices to database releases-- automated deployments-- using Jenkins,JenkinsCoreand Urban Code Deploy (uDeploy), applying SDLC best practices -- source code management (Git, Stash, and SourceTree) and documentation using software--Atlassian Confluence and draw.io

Salary:$141,450.00- $166,000.00/year.

#PE1M2

#LI-DNI