Endeavor Health
Join to apply for the
Data Architect
role at
Endeavor Health 17 hours ago Be among the first 25 applicants Join to apply for the
Data Architect
role at
Endeavor Health Get AI-powered advice on this job and more exclusive features. Hourly Pay Range
$41.64 - $64.54 - The hourly pay rate offered is determined by a candidate's expertise and years of experience, among other factors. Hourly Pay Range
$41.64 - $64.54 - The hourly pay rate offered is determined by a candidate's expertise and years of experience, among other factors.
Position Highlights
Position: Data Architect Location: 4901 Searle Parkway, Skokie IL Full Time Hours: Monday-Friday, 8am- 4:30pm Hybrid schedule 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 Drive adoption of cloud data warehouse and lakehouse solutions such as Snowflake, Databricks, BigQuery, or Azure Fabric. Partner with engineering teams to design ETL/ELT pipelines, data marts, and semantic layers. Ensure data governance, security, lineage, and compliance standards are embedded in architecture. 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
Education: 4 year college degree in computer science/data processing or equivalent work experience Experience: 6+ years supporting and developing software applications. 6+ years of experience as a Data Architect, Data Modeler with a data warehouse (PLSQL\MSSQL database experience is key, DBA experience not required) Unique or Preferred Skills: 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) Familiarity with cloud-native architectures, APIs, microservices, and event-driven systems is a plus 1+ year of Proven hands-on experience with at least one major cloud data platform: Snowflake or Databricks or Google BigQuery or Azure Synapse/ Fabric Experience with SQL, ETL/ELT frameworks, and data integration tools (Informatica, dbt, Azure Data Factory, Talend, etc.). Understanding of data governance, metadata management, MDM, and data security practices. Experience with reporting tools such as Cognos/Power BI 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
Benefits (For Full Time Or Part Time Positions)
Incentive pay for select positions Opportunity for annual increases based on performance Career Pathways to Promote Professional Growth and Development Various Medical, Dental, Pet and Vision options Tuition Reimbursement Free Parking Wellness Program Savings Plan Health Savings Account Options Retirement Options with Company Match Paid Time Off and Holiday Pay Community Involvement Opportunities
Endeavor Health is a fully integrated healthcare delivery system committed to providing access to quality, vibrant, community-connected care, serving an area of more than 4.2 million residents across six northeast Illinois counties. Our more than 25,000 team members and more than 6,000 physicians aim to deliver transformative patient experiences and expert care close to home across more than 300 ambulatory locations and eight acute care hospitals – Edward (Naperville), Elmhurst, Evanston, Glenbrook (Glenview), Highland Park, Northwest Community (Arlington Heights) Skokie and Swedish (Chicago) – all recognized as Magnet hospitals for nursing excellence. For more information, visit www.endeavorhealth.org.
When you work for Endeavor Health, you will be part of an organization that encourages its employees to achieve career goals and maximize their professional potential.
Please explore our website (www.endeavorhealth.org) to better understand how Endeavor Health delivers on its mission to “help everyone in our communities be their best”.
Endeavor Health is committed to working with and providing reasonable accommodation to individuals with disabilities. Please refer to the main career page for more information.
Diversity, equity and inclusion is at the core of who we are; being there for our patients and each other with compassion, respect and empathy. We believe that our strength resides in our differences and in connecting our best to provide community-connected healthcare for all.
EOE: Race/Color/Sex/Sexual Orientation/ Gender Identity/Religion/National Origin/Disability/Vets, VEVRRA Federal Contractor. Seniority level
Seniority level Mid-Senior level Employment type
Employment type Full-time Job function
Job function Engineering and Information Technology Industries Hospitals and Health Care Referrals increase your chances of interviewing at Endeavor Health by 2x Sign in to set job alerts for “Data Architect” roles.
Rosemont, IL $169,000.00-$240,000.00 1 week ago Solutions Architect, Retail, Google Cloud
Chicago, IL $147,000.00-$216,000.00 1 week ago Chicago, IL $145,500.00-$280,000.00 2 weeks ago Oak Brook, IL $127,000.00-$174,500.00 9 hours ago Chicago, IL $150,000.00-$190,000.00 2 weeks ago Chicago, IL $155,000.00-$165,000.00 2 weeks ago Chicago, IL $125,825.00-$221,275.00 1 week ago Chicago, IL $150,000.00-$220,000.00 3 weeks ago Oak Brook, IL $130,000.00-$152,000.00 2 weeks ago Itasca, IL $100,000.00-$103,000.00 1 week ago Chicago, IL $150,000.00-$180,000.00 2 weeks ago Chicago, IL $137,400.00-$240,400.00 2 weeks ago Chicago, IL $137,275.00-$178,670.00 1 week ago Solutions Architect Digital Transformation
Data Solutions Architect | Splunk (Remote)
Chicago, IL $160,000.00-$190,000.00 2 weeks ago Chicago, IL $137,275.00-$178,670.00 1 day ago Greater Chicago Area $80.00-$85.00 3 weeks ago Greater Chicago Area $169,000.00-$206,000.00 1 day ago Solution Architect (Commercial Insurance)
Chicago, IL $165,000.00-$180,000.00 3 days ago Solution Architect (Commercial Insurance)
Chicago, IL $150,000.00-$180,000.00 2 weeks ago Chicago, IL $150,000.00-$160,000.00 2 days ago Chicago, IL $125,000.00-$185,000.00 2 weeks ago We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr
Data Architect
role at
Endeavor Health 17 hours ago Be among the first 25 applicants Join to apply for the
Data Architect
role at
Endeavor Health Get AI-powered advice on this job and more exclusive features. Hourly Pay Range
$41.64 - $64.54 - The hourly pay rate offered is determined by a candidate's expertise and years of experience, among other factors. Hourly Pay Range
$41.64 - $64.54 - The hourly pay rate offered is determined by a candidate's expertise and years of experience, among other factors.
Position Highlights
Position: Data Architect Location: 4901 Searle Parkway, Skokie IL Full Time Hours: Monday-Friday, 8am- 4:30pm Hybrid schedule 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 Drive adoption of cloud data warehouse and lakehouse solutions such as Snowflake, Databricks, BigQuery, or Azure Fabric. Partner with engineering teams to design ETL/ELT pipelines, data marts, and semantic layers. Ensure data governance, security, lineage, and compliance standards are embedded in architecture. 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
Education: 4 year college degree in computer science/data processing or equivalent work experience Experience: 6+ years supporting and developing software applications. 6+ years of experience as a Data Architect, Data Modeler with a data warehouse (PLSQL\MSSQL database experience is key, DBA experience not required) Unique or Preferred Skills: 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) Familiarity with cloud-native architectures, APIs, microservices, and event-driven systems is a plus 1+ year of Proven hands-on experience with at least one major cloud data platform: Snowflake or Databricks or Google BigQuery or Azure Synapse/ Fabric Experience with SQL, ETL/ELT frameworks, and data integration tools (Informatica, dbt, Azure Data Factory, Talend, etc.). Understanding of data governance, metadata management, MDM, and data security practices. Experience with reporting tools such as Cognos/Power BI 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
Benefits (For Full Time Or Part Time Positions)
Incentive pay for select positions Opportunity for annual increases based on performance Career Pathways to Promote Professional Growth and Development Various Medical, Dental, Pet and Vision options Tuition Reimbursement Free Parking Wellness Program Savings Plan Health Savings Account Options Retirement Options with Company Match Paid Time Off and Holiday Pay Community Involvement Opportunities
Endeavor Health is a fully integrated healthcare delivery system committed to providing access to quality, vibrant, community-connected care, serving an area of more than 4.2 million residents across six northeast Illinois counties. Our more than 25,000 team members and more than 6,000 physicians aim to deliver transformative patient experiences and expert care close to home across more than 300 ambulatory locations and eight acute care hospitals – Edward (Naperville), Elmhurst, Evanston, Glenbrook (Glenview), Highland Park, Northwest Community (Arlington Heights) Skokie and Swedish (Chicago) – all recognized as Magnet hospitals for nursing excellence. For more information, visit www.endeavorhealth.org.
When you work for Endeavor Health, you will be part of an organization that encourages its employees to achieve career goals and maximize their professional potential.
Please explore our website (www.endeavorhealth.org) to better understand how Endeavor Health delivers on its mission to “help everyone in our communities be their best”.
Endeavor Health is committed to working with and providing reasonable accommodation to individuals with disabilities. Please refer to the main career page for more information.
Diversity, equity and inclusion is at the core of who we are; being there for our patients and each other with compassion, respect and empathy. We believe that our strength resides in our differences and in connecting our best to provide community-connected healthcare for all.
EOE: Race/Color/Sex/Sexual Orientation/ Gender Identity/Religion/National Origin/Disability/Vets, VEVRRA Federal Contractor. Seniority level
Seniority level Mid-Senior level Employment type
Employment type Full-time Job function
Job function Engineering and Information Technology Industries Hospitals and Health Care Referrals increase your chances of interviewing at Endeavor Health by 2x Sign in to set job alerts for “Data Architect” roles.
Rosemont, IL $169,000.00-$240,000.00 1 week ago Solutions Architect, Retail, Google Cloud
Chicago, IL $147,000.00-$216,000.00 1 week ago Chicago, IL $145,500.00-$280,000.00 2 weeks ago Oak Brook, IL $127,000.00-$174,500.00 9 hours ago Chicago, IL $150,000.00-$190,000.00 2 weeks ago Chicago, IL $155,000.00-$165,000.00 2 weeks ago Chicago, IL $125,825.00-$221,275.00 1 week ago Chicago, IL $150,000.00-$220,000.00 3 weeks ago Oak Brook, IL $130,000.00-$152,000.00 2 weeks ago Itasca, IL $100,000.00-$103,000.00 1 week ago Chicago, IL $150,000.00-$180,000.00 2 weeks ago Chicago, IL $137,400.00-$240,400.00 2 weeks ago Chicago, IL $137,275.00-$178,670.00 1 week ago Solutions Architect Digital Transformation
Data Solutions Architect | Splunk (Remote)
Chicago, IL $160,000.00-$190,000.00 2 weeks ago Chicago, IL $137,275.00-$178,670.00 1 day ago Greater Chicago Area $80.00-$85.00 3 weeks ago Greater Chicago Area $169,000.00-$206,000.00 1 day ago Solution Architect (Commercial Insurance)
Chicago, IL $165,000.00-$180,000.00 3 days ago Solution Architect (Commercial Insurance)
Chicago, IL $150,000.00-$180,000.00 2 weeks ago Chicago, IL $150,000.00-$160,000.00 2 days ago Chicago, IL $125,000.00-$185,000.00 2 weeks ago We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr