Architect - Data Engineering

Job description

Overview

Primary focus would be to lead development work within the Enterprise Data Warehouse (EDW) platform on Teradata, Azure Data Lake environment and other related ETL technologies, with the responsibility of ensuring on time and on budget delivery; Satisfying project requirements, while adhering to enterprise architecture standards. Role will lead key EDW and data lake projects and resources, including innovation related initiatives (e.g. adoption of technologies like Databricks, Presto, Denodo, Azure data factory; database encryption; enabling rapid experimentation etc.)). This role will also have L3 and release management responsibilities for ETL processes

Responsibilities

·  Lead delivery of key Enterprise Data Warehouse and Azure Data Lake projects within time and budget
·  Drive solution design and build to ensure scalability, performance and reuse of data and other components
·  Ensure on time and on budget delivery which satisfies project requirements, while adhering to enterprise architecture standards. 
·  Manage work intake, prioritization and release timing; balancing demand and available resources.  Ensure tactical initiatives are aligned with the strategic vision and business needs
·  Oversee coordination and partnerships with Business Relationship Managers, Architecture and IT services teams to develop and maintain EDW and data lake best practices and standards along with appropriate quality assurance policies and procedures
·  May lead a team of employee and contract resources to meet build requirements:
·  Set priorities for the team to ensure task completion
·  Coordinate work activities with other IT services and business teams. 
·  Hold team accountable for milestone deliverables
·  Provide L3 support for existing applications
·  Release management
Qualifications

Years of Experience

·  Bachelor’s degree in Computer Science, MIS, Business Management, or related field
·  10 + years’ experience in Information Technology or Business Relationship Management
·  7 + years’ experience in Data Warehouse/Azure Data Lake
·  Minimum 2 years’ experience in project management

Mandatory Technical Skills

·  Advanced data modeling or database experience; experience with ER/Studio and/or Erwin modeling tools
·  Good understanding of PepsiCo business processes, data, and EDW/MDM environments
·  Proven experience in managing Data, BI or Analytics projects
·  Solutions Delivery experience - expertise in system development lifecycle, integration, and sustainability
·  Thorough knowledge of data warehousing concepts and data catalog tools (Alation)

Mandatory Non-Technical Skills

·  Excellent remote collaboration skills
·  Experience working in a matrix organization with diverse priorities
·  Experience dealing with and managing multiple vendors
·  Exceptional written and verbal communication skills along with collaboration and listening skills
·  Ability to work with agile delivery methodologies
·  Ability to ideate requirements & design iteratively with business partners without formal requirements documentation
·  Ability to budget resources and funding to meet project deliverables

Differentiating Competencies

·  Strong project & resource management skills
·  Ability to work with virtual teams (remote work locations); lead team of technical resources (employees and contractors) based in multiple global locations
·  Lead technical discussions, driving clarity of complex issues/requirements to build robust solutions
·  Strong communication skills to meet with delivery teams and business-facing teams, understand sometimes ambiguous, needs, and translate to clear, aligned requirements