Job Details | Principal Data Warehouse Architect

Registered employers can post jobs, search for candidates, and/or post a company profile on ChicagoJobs.com

Quick Search
Run a quick search through the entire listings of jobs on this website. Filter your search by one, two or all three of the following criteria:





View Job

This job posting is no longer active on ChicagoJobs.com and therefore cannot accept online applications.


    

This posting cannot receive an online application from your ChicagoJobs.com account. To apply, follow the employer's instructions within their job description.

U.S. Cellular

Location: ChicagoIL 60601 Document ID: AC274-4EC6 Posted on: 2018-09-2609/26/2018 Job Type: Full-time

Job Schedule:Full-time
2018-10-26
 

Principal Data Warehouse Architect

Principal Data Warehouse Architect - INF001145

The Principal Data Warehouse Architect will lead the design of a high performing Enterprise Data Warehouse, using both Kimball & Inmom methodologies along with actively participating in enhancing the EDW by utilizing a multi-platform, modern architecture approach. The architect will collaborate with the stakeholders and build solutions that support their reporting, analytics, data exploration and data science needs. This role will lead process improvement initiatives and in setting the best practice standards around Data Architecture, Metadata, Governance, Masterdata Management, Federation and Data Quality flows.

Essential Duties and Key Responsibilities

  • Provide expertise and guidance in the creation and refinement of agile technical stories for data architecture and development.
  • Work across the organization to architect data driven solutions that focus on fulfilling stakeholders needs:
    • Lead the translation of business needs into feasible and acceptable data centric semantic layer designs
    • Document and present relationships between business entities using Kimball, Inmom and other modern frameworks
    • Lead discussions to prioritize and balance technical and business needs of the conceptual and logical data warehouse
  • Architect physical data models
    • Architect and document 3NF integration layer (normalized) of the data warehouse
    • Architect and document dimensional presentation layer (de-normalized) of the data warehouse
    • Lead enhancement of existing models to ensure compliancy with best practices around master data management and a 3 layer architecture across technology platforms
    • Oversee design, develop, documentation and articulate architecture of the enterprise data warehouse
  • Evaluate reusability of current solutions for additional analysis, while maintaining integrity and confidentiality of information in accordance with a minimum viable product
  • Lead discussions to document database standards and procedures for the definition of reference architecture
  • Mentor other architects on best practices in data warehouse design and implementation, including metadata management, data quality and master data management


Experience and Educational Requirements

  • College degree, specialized training or equivalent work experience
  • 7+years of recent Data Warehouse Architecture experience to build and articulate conceptual, logical and physical dimensional data models and third normal form artifacts
  • Expert in using standard modeling tools like Erwin, ERStudio
  • Experience in delivering solutions using Agile (traditional and SAFe) and supporting tools like Jira or Remedy
  • Proven expertise in designing well performing solutions with an ability to tune data warehouse objects for efficiency and accuracy
  • Experience with architecting solutions across platforms and using multiple data layers presented in a federated schematic layer
  • An understanding of Big Data technologies and modern data architectures like Spark and NoSQL structures
  • Experience with the following databases: Oracle & Exadata and a solid understanding of Hive, HBase and Spark


Job : Information Technology

Location(s) : Illinois-CHICAGO_IL

U.S. Cellular® is an EEO employer and gives consideration to qualified applicants without regard to race/color/age/religion/sex/sexual orientation/gender identity/national origin/disability/veteran status, pregnancy or genetic information.
     
Minimize

Facebook

Minimize