What are the responsibilities and job description for the Sr Data Warehouse Architect position at U.S. Cellular?
Employer: U.S. Cellular Corporation
Job Title: Senior Data Warehouse Architect
Location: 8410 W. Bryn Mawr Avenue, Chicago, IL 60631
Job Duties:
O Design a high performing Enterprise Data Warehouse;
O Collaborate with the stakeholders and build solutions.
O Participate in process improvement initiatives and in setting best practice standards;
O Provide expertise in the creation and refinement of agile technical stories for data architecture and development;
O Provide expertise in the development of standards, architectural governance, design patterns, and practices;
O Architect data-driven solutions;
O Lead the translation of business needs into feasible and acceptable data-centric semantic layer designs;
O Document and present relationships between business entities;
O Participate in discussions to prioritize and balance technical and business needs of the conceptual and logical data warehouse;
O Design physical data models, Data Warehouse Design;
O Design and document 3NF integration layer (normalized) and create dimensional presentation layer (de-normalized) of the data warehouse;
O Enhance existing models and a 3-layer architecture across technology platforms;
O Design, develop, document and articulate architecture of the enterprise data warehouse and data lake;
O Evaluate reusability of current solutions;
O Lead discussions to document database standards and procedures;
O Define Master Data Management solutions architecture and set technical direction and define component architecture;
O Participate in Data Governance Council;
O Coach, mentor, onboard new and junior associates.
Telecommuting within normal commuting distance of the office is permitted.
#LI-DNIUSCCTP
Minimum RequirementsRequirements:
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.
#LI-DNIUSCCTP
Rate of Pay: $153,650/year to $163,387.18/year
BenefitsAssociates 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 FlyerU.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.
Salary : $153,650 - $163,387
