Principal Data Architect I

JOB SUMMARY

Responsible for architecting and leading data engineering functions including, but not limited to: data extract, transformation, loading, integration in support of enterprise data infrastructures, data warehouse, operational data stores and master data management. Involved in architecting innovative solutions. Subject matter expert for multiple programs/systems.

MAJOR DUTIES AND RESPONSIBILITIES

Actively and consistently supports all efforts to simplify and enhance the customer experience.

Lead the implementation of data services and data movement infrastructures.

Architect data structures/models and data movement infrastructures.

Lead the implementation programming concepts such as data structures, error handing, data manipulation and I/O processing.

Re-design jobs based on job failures, including but not limited to error handing, data manipulation and I/O processing.

Lead the implementation of database concepts and practices including definition and query language.

Architect the implementation of database concepts and practices including definition and query language.

Design, implement, monitor, enhance, and troubleshoot requirements and architecture specifications of data warehousing systems and/or processing infrastructure.

Lead the Insights team to design, implement, and support end-to-end data solutions across multiple platforms, environments, domains, and locations.

Architect development of ETL processes, programs and solutions as per established standards.

Monitors and administer automated and manual data integration and ETL jobs to verify execution and measure performance.

Mentor and guide junior developers, vendors, consultants, and external partners to quickly identify and resolve data integration and ETL job issues.

Diagnose highly complex issues and evaluates, recommends, and executes the best resolution.

Influence the overall data insights program.

Deliver quality results to the data development team.

Ensure alignment to drive consistency and global solutions.

REQUIRED QUALIFICATIONS

Required Skills/Abilities and Knowledge

Ability to read, write, speak and understand English

Extensive experience with building use cases and providing development support to data scientists

Extensive with building use cases and providing development support to data engineers

Extensive experience with data lake - all data sources - building out data sets for uses cases

Extensive experience with building SQL/HIVE databases and tables

Extensive experience with querying and designing efficient warehousing structures

Extensive knowledge of data access methods from relational databases using SQL

Extensive knowledge of and hands on with web services (WSDL Soap, Restful) to access data from various source systems

Extensive knowledge of FTP/sFTP

Extensive experience with designing or architecting for highly complex ETL processing and warehousing

Effective written and verbal communication skills

Effective analytical and troubleshooting abilities

Required Education

Bachelor's degree or equivalent experience

Required Related Work Experience and Number of Years

ETL experience - 8+

Experience with SQL, Shell Script, Python, JSON - 6+

Data integration experience - 5

Data visualization experience (Tableau, Alterx, Microstrategy) - 5

Software engineering experience - 5

Preferred Qualificaitions

Experience with Redshift, Snowflake and/or other massively parallel processing (MPP) data warehouse platforms.

Experience working with ETL workflow and scheduling applications utilizing Airflow.

Experience in developing automated frameworks, templates and design patterns

Experience working with Telecom/Cable MSO data and applications

Preferred Education

Master's degree, or equivalent experience with design, architecture, and leadership

WORKING CONDITIONS

Office environment