Data Architect Associate | Full Time
EDUCATION/EXPERIENCE REQUIRED:
- Bachelor’s degree in Computer Science, Business, Health Care or related field.
- Technical training in multi-dimensional modeling and data mining/warehousing techniques.
- Related and relevant experience may be considered in lieu of academic requirements. Related experience is defined as six (6) years of experience in
multidimensional modeling, or data warehouse architecture. - Minimum three (3) years of experience in multidimensional modeling.
- Knowledge and understanding of data warehouse architecture, application design, systems engineering, SDLC and integration.
- Experience with Epic Clarity and Epic Caboodle data models preferred.
- Expertise in Microsoft SQL Server, including T-SQL, SSIS, and performance tuning
- Experience with Microsoft Fabric, including data integration, real-time analytics, and cloud-based data management.
- Knowledge of Power BI or other reporting tools is a plus.
- Demonstrated experience leading teams that analyze complex data related issues and/or logical data models in support of corporate and customer information systems requirements.
- Good understanding of methodologies and technologies that depict the flow of data within and between technology systems and business functions/operations.
- Business analyst skills relevant to communication and analysis functions.
- ETL development experience relevant to knowledge about information design and compatibility, preferred.
- Database administration skills relevant to knowledge about conceptual/logical/physical design optimization, preferred.
Skills and Abilities
- Ability to understand business requirements, translate them into technical designs, deal with complexities of integration of disparate systems, investigate the quality of the data in those systems and put it all together so it can be accessed, manipulated and turned into business intelligence.
- Technical knowledge, analytical skill, reliability and initiative required to implement quality data warehousing systems and deliver timely and well-organized data intelligence.
- Ability to collect and prepare data for written and/or oral presentations communicating effectively with all levels of customer and management.
- Knowledge of Information Services policies, procedures and functions.
- Knowledge of Healthcare data and business practices and processes to provide appropriate and accurate levels of data intelligence to the business community.
- Good communication (written and oral) and interpersonal skills.
Additional Details
This posting represents the major duties, responsibilities, and authorities of this job, and is not intended to be a complete list of all tasks and functions. It should be understood, therefore, that incumbents may be asked to perform job-related duties beyond those explicitly described above.
Overview
Henry Ford Health partners with millions of people on their health journey, across Michigan and around the world. We offer a full continuum of services – from primary and preventative care to complex and specialty care, health insurance, a full suite of home health offerings, virtual care, pharmacy, eye care and other health care retail. With former Ascension southeast Michigan and Flint region locations now part of our team, Henry Ford’s care is available in 13 hospitals and hundreds of ambulatory care locations. Based in Detroit, Henry Ford is one of the nation’s most respected academic medical centers and is leading the Future of Health: Detroit, a $3 billion investment anchored by a reimagined Henry Ford academic healthcare campus. Learn more at henryford.com/careers.
Benefits
The health and overall well-being of our team members is our priority. That’s why we offer support in the various components of our team’s well-being: physical, emotional, social, financial and spiritual. Our Total Rewards program includes competitive health plan options, with three consumer-driven health plans (CDHPs), a PPO plan and an HMO plan. Our team members enjoy a number of additional benefits, ranging from dental and eye care coverage to tuition assistance, family forming benefits, discounts to dozens of businesses and more. Employees classified as contingent status are not eligible for benefits.
Equal Employment Opportunity/Affirmative Action Employer
Equal Employment Opportunity / Affirmative Action Employer Henry Ford Health is
committed to the hiring, advancement and fair treatment of all individuals without regard to
race, color, creed, religion, age, sex, national origin, disability, veteran status, size, height,
weight, marital status, family status, gender identity, sexual orientation, and genetic information,
or any other protected status in accordance with applicable federal and state laws.