Data Architect - Azure Data & Analytics; Data Factory, Synapse, Databricks

Job Summary

The Principal 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.

50% Continuously delivers and improves prioritized enterprise data assets that enable the growth of global analytics, reporting and visualization solutions.

20% Provides expertise in all end-to-end components in our BI/DW architecture and knows how they contribute to compose solutions for business partners. Demonstrates strong command of both technical delivery as well as comprehension of various business functions. Understands the role of various enterprise applications.

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.

10% Operates independently, functions as the lead representative for D&A on projects. Drives and sets design patterns for all of D&A.

10% Drives process improvement to continually raise the bar as the primary owner of function, platform or process. Drives best practices across the organization. Recognizes process deficiencies and takes independent action to improve.

5% Performs other duties as assigned.

• Bachelor's degree, applicable certification or equivalent experience.
• Typically requires 8+ years of professional experience and mastery of relevant technical or business skills required to accomplish the job.
• Master'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.

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 of expertise.

• Problem Solving:
  Identifies and solves complex problems that impact multiple areas. Applies independent analysis based on in-depth research and critical thinking to recommend solutions.
• Decisions:
  Routinely analyzes unique issues or problems and functions with a high degree of autonomy.
• Knowledge:
  Requires specialized knowledge and expertise in own job discipline and deep experience in integrating related disciplinary knowledge. Applies specialized knowledge of industry standards/practices on key projects and initiatives.
• Business Acumen:
  Interprets internal/external business challenges. Recommends best practices to improve products, processes, or services to distinguish from the competition.
• Communication & Influence:
  Communicates difficult concepts and negotiates with others to adopt a different point of view. Converts technical information to compelling business context and advice.
• Impact:
  Decisions will have significant impact to multiple departments or disciplines.
• Leadership:
  Manages projects and end to end programs with moderate resource…