Data Engineer

·       Position’s Contributions to Work Group

·       Team culture

·       Surrounding team & key projects

·       Purpose of this team

·       Reason for the request

Position’s Contributions to Work Group:

The PSLD Transformation Analytics group engages with various stakeholders across the organization to help solve their business problems. The individual will run the entire project end to end, so strong skills in gathering/understanding customer requirements, creating and maintaining optimal data pipeline architecture, choosing appropriate tools/techniques and delivering actionable insights are must. They will also learn all relevant BU specific data and often combine them with relevant enterprise data domains to bring insights that are not possible if BU data alone is analyzed.

Reason/motivation for request:

• Backfill

Typical Day in the Role

·       Typical task breakdown and rhythm

·       Interaction level with team

·       Work environment description

See above and below.

Candidate Requirements

·       Years of experience required

·       Degrees or certifications required

·       Disqualifiers

·       Performance indicators

Specific responsibilities are –

• Extract large, complex data sets that meet business requirements. Work to build the on-prem /cloud infrastructure for optimal extraction, transformation, and loading of a wide variety of complex business data from on-prem/cloud databases.

• Identify ways to improve data reliability, efficiency, and quality.

• Work with internal and external stakeholders to assist with data-related technical issues and support data needs.

• Own the design and development of ongoing business metrics/KPI, reports and dashboards to drive key business decisions.

• Prepare data for predictive and prescriptive modeling.

Typical Day:

Work is typically directed by a direct supervisor, project or team lead. Decisions on routine, medium risk issues that may affect the project team, suppliers or internal customers may be made by this position. Challenges include meeting expectations in delivering results, learning to refine solutions to better fit complex situations, making timely decisions, and communicating effectively with all project stakeholders.

Critical Technical Skills:

• Familiarity with database such as Snowflake, DB2, SQL Server, Oracle (2-3 of these are required)

• Programming languages - SQL(required), Python(required) and SAS(preferred)

• Experience working with large data sets, preferably in several GB or millions of transactions.

• Visualization - PowerBI(required), Tableau(preferred)

• Experience working with platform integration tool like Snaplogic is preferred

• Experience working with AWS (required)

Top 3 technical skills: Python, Snowflake, PowerBI

Soft Skills Required:

Communication, Team-work, Problem Solving, Customer Focus