Endeavor Health's NorthShore entity needs a Data Architect to design and implement a scalable and secure Enterprise Data Warehouse, translating business needs into technical design and ensuring data governance, security, and compliance standards.
Requirements
- 6+ years of experience as a Data Architect, Data Modeler with a data warehouse (PLSQLMSSQL 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)
- 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.).
Responsibilities
- 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.
Other
- 4 year college degree in computer science/data processing or equivalent work experience
- 6+ years supporting and developing software applications.
- Strong verbal and written communication, presentation and customer service skills
- Ability to solve highly complex technical and operational problems
- On Call (rotating)
