Job Summary:
The Sr Data Engineer is responsible for the design, development, testing, maintenance, and support of enterprise data assets. Provides technical design, development and analytical support. Enables improvements in environment design, efficiency, controls, and the overall user experience of enterprise data assets, and leads activities. Coordinates with senior leadership, several enterprise support organizations, and end users.
Responsibilities:
65% Continuously delivers and improves prioritized enterprise data assets that enable the growth of global analytics, reporting, and visualization solutions.
15% Designs, builds, tests, and maintains end-to-end data management solutions within a global data lake and data warehouse environment. Shows a firm grasp of solution design, appropriate design patterns, and industry standards. Demonstrates proficiency in the application of reference data modeling techniques.
5% Identifies project risks and impediments, notifies management, and proactively works with other team members to complete assigned tasks as defined by project scope, timelines, and budgets.
5% Participates in the use of Agile practices to elicit and refine requirements through an iterative process of planning, defining acceptance criteria, prioritizing, developing, and delivering enterprise data asset solutions.
5% Operates independently as a single point of contact for Data Engineering as the primary representative on projects. Collaborates with architecture team to analyze and drive solution architecture within assigned projects.
5% Solves problems that affect multiple projects. Drives process improvements when needed. Mentors and leads other engineers on project approach, technical training, and application of best practices.
5% Performs other duties as assigned.
Additional Requirements:
- Bachelor's degree, applicable certification or equivalent experience.
- Typically requires 5-8 years of professional experience and strong competency with the various tools, systems, or procedures required to accomplish the job.
- Bachelor's Degree required Computer Science, Information Systems or a related field. An equivalent combination of education and experience may be considered.
- Expert in SQL and query optimization for data platforms such as Azure SQL DW, HDInsight, Teradata, SAP BW/HANA, or Oracle
- Expert in database concepts, including normalization, indexing, physical and logical modeling, creation of SQL queries and performance tuning
- Familiarity with the Kimball methods of data warehousing techniques, standards and best practices
- Experience with management of a star schema implementation and related concepts such as slowly changing and late arriving dimensions
- 4+ years professional experience with one or more ETL tools such as Informatica, SQL Server Integration Services, Business Objects Data Services, or IBM Datastage
- Sound judgment and decision-making, and the appropriate sense of urgency and is a self-starter
- Familiarity with data content from typical Supply Chain scenarios, or experience in environments integrated with data from SAP ERP or Microsoft Dynamics a plus
- Experience with large scale data processing, data structure optimization and scalability of algorithms a plus
- Experience with Microsoft Azure: Data factory, data lake and data warehouse a bonus
- Travel: Occasional - 10%
- Work Schedule: Standard Hours
Career Band: Professional
Jobs on this career band have a knowledge management focus and are primarily responsible for results achieved through their own work. Requires the application of theoretical knowledge, typically gained through formal education or equivalent work experience that provides knowledge of and exposure to fundamental theories, principles and concepts of a defined profession. Jobs at higher career levels may guide small teams in their area of subject matter expertise. Jobs at the at the most senior levels of this career band set disciplinary strategy within their areas of expertise.
Criteria & Management Requirements:
- Problem Solving: Solves complex problems and develops independent creative solutions based on the evaluation of multiple options.
- Decisions: Independently analyzes issues of a diverse scope and functions with a moderate degree of autonomy. Receives minimal direction, seeks guidance for highly complex issues.
- Knowledge: In depth knowledge of principles, concepts, and theories within own discipline and working knowledge of related disciplines. Applies broader knowledge of industry standards/practices to assignments and others.
- Business Acumen: Understands best practices; is aware of the differences between the company and its competition in the supported function. Understands how their own functional area integrates with others to deliver results.
- Communication & Influence: Explains difficult or sensitive information; works to build consensus. May provide process and subject matter advice.
- Impact: Work performed will have impact on cross-functional projects beyond the department.
- Leadership: No supervisory responsibility. Acts as a resource for colleagues with less experience. May lead projects with manageable risks and resource requirements. May contribute input to the performance review of other team members.
Work Environment: Typical Office
Other Work Environment Requirements:
Typical Office: Operates in a typical office environment, routinely uses computer and other standard office equipment.
Other Physical Requirements:
Typical Office: Generally sedentary for prolonged periods, may occasionally require ability to move about or adjust/move items weighing up to 10 lbs. in all directions; Constantly requires collaboration and the ability to communicate with others to exchange information while in a typical office setting. Collaboration is generally conducted in person unless the role has been pre-approved for remote work.
This job description is not meant to be an all-inclusive list of duties and responsibilities, but constitutes a general definition of the position's scope and function in the company.
