DenverRecruiter Since 2001
the smart solution for Denver jobs

Principal Data Architect I

Company: SPECTRUM
Location: Denver
Posted on: June 25, 2022

Job Description:

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
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.
Excellent written and verbal communication skills.
Excellent analytical and troubleshooting abilities.

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

Related Work Experience 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

WORKING CONDITIONS
Office environment
MPD639 313444 313444BR

Here, employees dont just have jobs, they build careers. Thats why we believe in offering a comprehensive package that rewards employees for their contributions to our success, supports all aspects of their well-being, and delivers real value at every stage of life.

The pay for this position has a salary range of $107,600.00 to $191,200.00. The actual salary offer will carefully consider a wide range of factors, including your skills, qualifications, experience and location. Also, certain positions are eligible for additional forms of compensation such as bonuses.Required

Preferred
Job Industries
  • Transportation

Keywords: SPECTRUM, Denver , Principal Data Architect I, Other , Denver, Colorado

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Log In or Create An Account

Get the latest Colorado jobs by following @recnetCO on Twitter!

Denver RSS job feeds