Position Highlights:

• Position: Senior Data Architect
• Location: 4901 Searle Parkway, Skokie IL
• Full Time, Hybrid schedule
• Hours: Monday-Friday, 8am- 4:30pm
• On Call (rotating)

What you will do:

• Interact and lead discussions with stakeholders to understand and document the scope, business requirements and translate these into the technical design to support Endeavor Health's NorthShore entity 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.

What you will need:

• 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)
• 1+ years of architecture experience with Microsoft Azure, specifically with data analytics related services – SQL Server, Azure Data Factory, Fabric, Power Automate, Power BI etc.
• Subject matter expert in at least three (3) technical areas: Azure Synapse, Data Factory, Data/Delta Lake, Data Engineer, Microsoft Fabric, Data pipelines is a plus.
• 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