Posted: 01/27/232022-04-142023-02-26Category:Cloud, Healthcare IT, Software/Application Development and ArchitectureJob Number: 15523
Position: Data Architect Location: Remote Job Type: Direct Hire or Contract to Hire
This organization is making significant investments in enterprise data and digital health, enabling innovation and transformation in the delivery of health care, research and discovery. By building out core digital and data capabilities, we are supporting the achievement of our mission to drive growth and innovation in inpatient, ambulatory, and digital care. We are at the start of this journey and we are looking for talented individuals from across the nation to join us in transforming healthcare and in achieving the expected outcomes of this strategy: improved patient care, quality of care, patient engagement, and efficiency in the delivery of healthcare with excellence.
In the achievement of these goals, the data and analytic teams are working together to build a system-wide data ecosystem. We are both leveraging current assets and building new, integrated solutions to provide a holistic set of industry-leading data and analytic capabilities, supporting Artificial Intelligence (AI), Machine Learning (ML), and real-time insights. Teams from Data and Analytics, Research Analytics, Clinical Data Science, and Information Systems are collaborating to build this new data and analytic ecosystem. To ensure success of this effort, the org is standing up a new Data and Analytics operating model with a goal of driving a level of standardization for data and analytic operations across the teams involved.
The value of investments in data and analytics were proven out during our response to COVID-19 as these investments were leveraged to stand up new reporting and analytic capabilities to support executive and clinical leadership on managing the pandemic. Our broad data and analytic community has come together across 14 healthcare sites with shared urgency, delivering analytic tools to our system that drove timely insights in both clinical and operational domains, resulting in effective delivery of critical care and in organizational efficiencies during a time of reduced resources.
a Data Architect, you are a critical member of the Data & Analytics Organization (DAO) Enterprise Data Warehouse Data Architecture team. The Data Architecture team works together with other DAO teams to design, develop, validate, maintain, and support the EDW platform and many different analytic data assets and products. The EDW team is in process of migrating to a Cloud Data platform and looking for a Cloud enthusiast as we move to Azure Cloud. The ideal candidate will have a strong data architecture pedigree, enjoys working with new data technologies and excellent communication and leadership skills. If you are seeking a new challenge and are motivated by transformations we encourage you to apply.
The Data Architect reporting to the Manager of Enterprise Data Architecture will specifically be responsible to:
Develop and revise conceptual, logical, and physical data models for an Enterprise (i.e. Enterprise Data Architecture)
Build and maintain a deep understanding of the data and analytic landscape including data sources, data and analytic assets and products, analytic tools and software, and master data
Determine database structural requirements by analyzing business operations, applications, and programming; reviewing objectives with business partners; evaluating current systems;
Create data models that conform to current standards and conventions
Apply expertise and best practices to the development and revision of data architecture standards and conventions
Develop and revise data dictionary definitions, governance practices, and standards;
Partner with security architects to ensure compliance with data security and privacy policies and procedures
Participate in Architectural strategies on the EDW migration to Cloud platform e.g. integration with Data Lake and other Azure services
Principal Duties & Responsibilities
Understands how data is used to support analytical and/or operational reporting
Interviews business users to obtain requirements for enhancements and/or new analytic assets
Maps source system data to data warehouse models
Assists in the Development of data asset training and documentation
Works with teams to integrate data across clinical, administrative, and financial source systems including the management of critical master data
Develops and tests extraction, transformation, and load (ETL) processes
Follows standards for technology and technical processes
Presents technical solutions to stakeholders and end users
Minimum of 5 years of relevant experience including continuing to innovate data architecture design and deployment, and data modelling especially dimensional data modeling (OLAP)
Must possess excellent oral and written communication skills
Must possess strong data modeling skills
Must possess experience using Erwin or similar tools for developing and maintaining data models
Must possess strong data analysis skills into source systems to profile source system data
Must have strong experience with SQL
Experience with SQL Server platform is preferred
Healthcare industry experience and Epic data experience is preferred
Experience with Health Catalyst a plus but not required
Experience with Tableau reporting tools a plus but not required
Experience in agile development data projects a plus but not required
Excellent consultative skills, understanding business needs and translating those needs to technical requirements and solutions.
Strong creative problem solving with ability to craft Partners-specific solutions to meet the wide range of business needs across the organization
Adept at establishing trusted relationships at all levels across the organization and collaborating across multi-functional teams
Relational and dimensional data modeling and database design skills
Knowledge of data warehousing architectural approaches
Understanding of SQL and relational and multidimensional designs
Ability to construct queries using a supported query tool
Understands BI tool architecture, functions, features
Flexibility, diplomacy, and problem-solving
Ability to communicate effectively with all levels of the organization including senior business and clinical leaders and executives
Experience with Cloud Data Warehouse platforms e.g. Snowflake, Azure Synapse
Experience with the Azure stack (Azure Data Factory, ADLS, Azure Databricks, Azure ML, Azure Synapse, and Azure SQL) to help build a modern platform for data that will be sourced from a variety of analytic and operational
Queen Consulting Group is an equal opportunity employer. Our goal is to promote an environment that helps our employees and clients appreciate the benefits that diversity provides.
Meet Your Recruiter
Kristin Murphy Senior Technical Recruiter
Contact Kristin today about this great opportunity with Queen Consulting Group!