Senior Data Warehouse Architect

3 weeks ago

Chicago IL United States UScellular Full time
About This Role

Employer :       U.S. Cellular Corporation

Job Title :        Senior Data Warehouse Architect

Location :        8410 W. Bryn Mawr Avenue, Chicago, IL 60631

Job Duties:

Ø  Design a high performing Enterprise Data Warehouse;

Ø  Collaborate with the stakeholders and build solutions.

Ø  Participate in process improvement initiatives and in setting best practice standards;

Ø  Provide expertise in the creation and refinement of agile technical stories for data architecture and development;

Ø  Provide expertise in the development of standards, architectural governance, design patterns, and practices;

Ø  Architect data-driven solutions;

Ø  Lead the translation of business needs into feasible and acceptable data-centric semantic layer designs;

Ø  Document and present relationships between business entities;

Ø  Participate in discussions to prioritize and balance technical and business needs of the conceptual and logical data warehouse;

Ø  Design physical data models, Data Warehouse Design;

Ø  Design and document 3NF integration layer (normalized) and create dimensional presentation layer (de-normalized) of the data warehouse;

Ø  Enhance existing models and a 3-layer architecture across technology platforms;

Ø  Design, develop, document and articulate architecture of the enterprise data warehouse and data lake;

Ø  Evaluate reusability of current solutions;

Ø  Lead discussions to document database standards and procedures;

Ø  Define Master Data Management solutions architecture and set technical direction and define component architecture;

Ø  Participate in Data Governance Council;

Ø  Coach, mentor, onboard new and junior associates.

Telecommuting within normal commuting distance of the office is permitted.

USCCTP

Minimum Requirements

Requirements:

The position of Senior Data Warehouse Architect requires a Bachelor's degree or its foreign equivalent in Computer Science, Math, Electronics, Computer Information Systems, Information Technology or a related field and five (5) years of progressively responsible, post-baccalaureate experience in a related occupation.

Specific Skills or Other Requirements: 

Additionally, the applicant must have the following:      

1)      Experience in design physical data models, Data Warehouse Design.

2)      Experience in design, develop, document and articulate architecture of the enterprise data warehouse and data lake.

3)      Expert in using standard modeling tools like Erwin, ERStudio

4)      Experience in database performance facts, monitoring tools and tuning procedures.

5)      Experience with Oracle & Exadata relational databases and Hive, HBase and Spark technologies.

USCCTP

Benefits

Associates have access to healthcare benefits (medical, dental and vision), retirement plans (a 401(k) plan with company match and a pension plan funded by the company), Paid Parental Leave (6 weeks after 6 months of employment), Basic Life Insurance (if eligibility requirements are met), Education Assistance (after 3 months of employment), paid Vacation Days (15 days accrued per year for full-time/6 days accrued per year for part-time), paid Sick/Care-Giver Days (6 days accrued per year), and seven paid national holidays and one floating holiday, among others. Short Term Disability (after 6 months of employment) and Term Disability (180 day waiting period) coverage is also available for full-time associates. Associates Scheduled to work under twenty hours per week or for a limited term are eligible for medical plans and retirement plans (a 401(k) plan with company match and a pension plan funded by the company).

View Benefits Flyer

  • Senior Data Warehouse Architect

    3 weeks ago

    Chicago, United States UScellular Full time

    Senior Data Warehouse Architect-INF001877 Employer : U.S. Cellular Corporation Job Title : Senior Data Warehouse Architect Location : 8410 W. Bryn Mawr Avenue, Chicago, IL 60631 Job Duties : ØDesign a high performing Enterprise Data Warehouse; ØCollaborate with the stakeholders and build solutions. ØParticipate in process improvement...

  • Data Warehouse Architect

    1 week ago

    Chicago, United States Avance Consulting Full time

    Job DescriptionJob DescriptionWe need a Senior DW Architect who can guide the impact analysis and the solutioningRelevant Experience: 11-12 yearsWe are looking for a solid Data Warehouse architect with the following experience:-1) Experience with Star Schema dimensional modeling2) Experience with Data Warehouse ETL Architecture3) Experience with Semantic...

  • Senior Data Warehouse Architect

    2 weeks ago

    Chicago, United States UScellular Full time

    Job DescriptionAbout This RoleEmployer :       U.S. Cellular Corporation Job Title :        Senior Data Warehouse Architect Location :        8410 W. Bryn Mawr Avenue, Chicago, IL 60631Job Duties: Ø  Design a high performing Enterprise Data Warehouse;Ø  Collaborate with the stakeholders and build solutions. Ø  Participate in process...

  • Senior Data Warehouse Architect

    3 weeks ago

    Chicago, United States UScellular Full time

    About This RoleEmployer :       U.S. Cellular Corporation Job Title :        Senior Data Warehouse Architect Location :        8410 W. Bryn Mawr Avenue, Chicago, IL 60631 Job Duties: Ø  Design a high performing Enterprise Data Warehouse; Ø  Collaborate with the stakeholders and build solutions. Ø  Participate in process improvement...

  • Data Architect

    4 days ago

    Chicago, IL, United States United Airlines Full time

    There’s never been a more exciting time to join United Airlines. We’re on a path towards becoming the best airline in the history of aviation. And we’re growing – in the years ahead, we’ll hire tens of thousands of people across every area of the airline. Our careers include a competitive benefits package aimed at keeping you happy, healthy and...

  • Data Architect

    4 days ago

    Chicago, IL, United States United Airlines Full time

    There’s never been a more exciting time to join United Airlines. We’re on a path towards becoming the best airline in the history of aviation. And we’re growing – in the years ahead, we’ll hire tens of thousands of people across every area of the airline. Our careers include a competitive benefits package aimed at keeping you happy, healthy and...

  • Senior Data Architect

    16 hours ago

    Chicago, United States Atlantic Partners Corporation Full time

    A large Asset Management firm is looking for a Data Architect with financial services exp.This person will l design and implement best-in-class data management solutions for metadata, master data and data quality management to enable data analytics capabilities across the Firm. Serving as subject matter expert on Microsoft SQL Server and Azure Data...

  • Senior Data Architect

    4 weeks ago

    Chicago, United States Atlantic Partners Corporation Full time

    A large Asset Management firm is looking for a Data Architect with financial services exp.This person will l design and implement best-in-class data management solutions for metadata, master data and data quality management to enable data analytics capabilities across the Firm. Serving as subject matter expert on Microsoft SQL Server and Azure Data...

  • Senior Data Warehouse Developer

    1 week ago

    Chicago, United States Mavens Guild Full time

    What we would like to see: Ideal candidate for this role will not only help us procure, curate and model various transactional data but also turn it into information, generating insights and aid in business decisions based on the analytical results. Incumbent's responsibilities will include conducting full development lifecycle — requirements, analysis,...

  • Senior Data Warehouse Developer

    2 days ago

    Chicago, United States Mavens Guild Full time

    What we would like to see: Ideal candidate for this role will not only help us procure, curate and model various transactional data but also turn it into information, generating insights and aid in business decisions based on the analytical results. Incumbent's responsibilities will include conducting full development lifecycle — requirements, analysis,...

  • Data Architect

    4 weeks ago

    Chicago, United States TD Synnex - SHI for Chicago Public Schools (Central Office) Full time

    Chicago Public Schools (CPS) is one of the largest school districts in the United States, serving over 320,000 students in 600+ schools and employing approximately 40,000 people, most of them teachers. CPS has set ambitious goals to ensure that every student, in every school and every neighborhood, has access to a world-class learning experience that...

  • Senior Data Architect

    1 week ago

    Chicago, United States 1872 Consulting Full time

    Senior Data Architect - Data Modeling focus Chicago or Dallas - onsite 3 days/week, remote 2 days/week SUMMARY We are seeking a Senior Data Architect, with strong data modeling skills, to improve our current data posture on what is a leading real estate analytics platform. You'll spend a lot of your time developing data models using a variety of canonical...

  • Senior Data Architect Manager

    5 days ago

    Chicago, United States Bank of America Full time

    Job Description:At Bank of America, we are guided by a common purpose to help make financial lives better through the power of every connection. Responsible Growth is how we run our company and how we deliver for our clients, teammates, communities and shareholders every day.One of the keys to driving Responsible Growth is being a great place to work for our...

  • Senior Data Architect Manager

    1 week ago

    Chicago, Illinois, United States Bank of America Full time

    Job Description:At Bank of America, we are guided by a common purpose to help make financial lives better through the power of every connection. Responsible Growth is how we run our company and how we deliver for our clients, teammates, communities and shareholders every day.One of the keys to driving Responsible Growth is being a great place to work for our...

  • Senior Data Architect

    1 week ago

    North Chicago, Illinois, United States AbbVie Full time

    Job Description AbbVie’s Genomics Research Center (GRC) is a center of excellence for genetics and genomics that supports the R&D pipeline from Discovery through Development. The GRC goal is to develop world class genetics and genomics research focused on finding the right therapeutic targets, helping AbbVie scientists better understand human disease...

  • Architect, Technology

    4 days ago

    chicago, United States United Airlines Full time

    There’s never been a more exciting time to join United Airlines. We’re on a path towards becoming the best airline in the history of aviation. And we’re growing – in the years ahead, we’ll hire tens of thousands of people across every area of the airline. Our careers include a competitive benefits package aimed at keeping you happy, healthy and...

  • Principal, Data Architect

    6 days ago

    Chicago, United States Selby Jennings Full time

    Selby Jennings has partnered with a leading clearing house that is looking for a Data Architect to join their team at the Principal level. This role is offered on a hybrid capacity out of Chicago or Dallas.The Principal, Data Architecture will have the following responsibilities: Design the data architecture of organization to support data driven...

  • Principal, Data Architect

    7 days ago

    Chicago, United States Selby Jennings Full time

    Selby Jennings has partnered with a leading clearing house that is looking for a Data Architect to join their team at the Principal level. This role is offered on a hybrid capacity out of Chicago or Dallas.The Principal, Data Architecture will have the following responsibilities: Design the data architecture of organization to support data driven...

  • Principal, Data Architect

    1 week ago

    Chicago, United States Selby Jennings Full time

    Selby Jennings has partnered with a leading clearing house that is looking for a Data Architect to join their team at the Principal level. This role is offered on a hybrid capacity out of Chicago or Dallas.The Principal, Data Architecture will have the following responsibilities: Design the data architecture of organization to support data driven...

  • Principal, Data Architect

    5 days ago

    Chicago, United States Selby Jennings Full time

    Selby Jennings has partnered with a leading clearing house that is looking for a Data Architect to join their team at the Principal level. This role is offered on a hybrid capacity out of Chicago or Dallas.The Principal, Data Architecture will have the following responsibilities: Design the data architecture of organization to support data driven...