$100K — $150K *
Data Warehouse Architect - (76351)
NorthShore University HealthSystem (NorthShore) is a premier integrated healthcare delivery system consistently ranked as a Top 15 Teaching Hospital in the United States. Headquartered in Evanston, Ill., NorthShore is a non-for-profit organization comprised of – Evanston, Glenbrook, Highland Park, Swedish, Northwest Community and Skokie. The system includes a 950+ physician multispecialty group practice with 130 locations across Chicagoland. NorthShore has annual revenues of $2.1 billion and employs more than10,500 people. When you work for NorthShore, you will be part of an organization that encourages its employees to achieve career goals and maximize their professional potential.
We are currently seeking a Data Warehouse Architect within NorthShore’s HIT and App Services Department located at 4901 Searle Parkway in Skokie, IL. This is a full-time position and is benefits eligible. Hours will be scheduled on first shift Monday through Friday and will include on-call responsibilities.
The Data Warehouse Architect will:
Interact and lead discussions with stakeholders to understand and document the scope, business requirements and translate these into the technical design to support the NorthShore Enterprise Data Warehouse.
Lead the translation of business needs into feasible and acceptable data-centric semantic layer designs
Create conceptual, logical and physical data models Kimball, Inmon and other modern frameworks using 3NF and de-normalized dimensional design philosophies.
Drive and document the source to target mapping with the ETL developers.
Design highly performant and secure structures such as staging areas, integrated data, data marts, cubes and operational data stores.
Suggest, document and enforce data warehousing best practices including overall Data warehouse architecture relating to ODS, ETL
Estimate and communicate the work effort to EDW management, Stakeholders and own the deliverables from inception, review and signoff of the deliverables.
Review, improve and enhance existing models to ensure compliance with best practices around master data management and a 3 layer architecture across technology platforms
Act independently under general direction and may also provide technical consulting on complex projects throughout the organization.
Suggest improvements to data quality through data quality frameworks and processes preferred.
Knowledge of defining Master Data Management solutions architecture and setting technical direction and defining component architecture.
Our ideal candidate will have:
4 year college degree in computer science/data processing or equivalent work experience
6+ years supporting and developing software applications
4+ years of experience as a Data Architect, Data Modeler with a data warehouse (PLSQL\MSSQL database experience is key, DBA experience not required)
Strong dimensional modeling and star schema design skills
Ability to translate business needs into technical design
2+ years required experience with any Data Modeling tool (Erwin preferred)
Experience with Informatica PowerCenter is a plus
Experience with reporting tools such as Cognos/Tableau is a plus
Experience with Epic Clarity and Caboodle databases is a plus
Familiarity with Healthcare industry is a plus
Experience and detailed understanding of iterative system implementation, programming, integration, data conversion and testing techniques
Strong verbal and written communication, presentation and customer service skills
Ability to solve highly complex technical and operational problems
Programming skills and the ability to maintain and understand complex applications
Valid through: 6/29/2021