GENERAL SUMMARY: Under the general supervision of the Enterprise Data Architect, Data Architecture Manager, or EDW Program Manager: this role is responsible for production support, enhancement, and maintenance of the data warehouse. Performs data warehouse design and construction. Codes and documents scripts and stored procedures. Designs and implements data strategy methods. Develops appropriate ETL packages, data pipelines, and system documentation. Assists with metadata repository management. Prepares and implements data verification and testing methods for the data warehouse. Creates index and view scripts. Responsibilities will include troubleshooting application and data issues and providing production support (including on-call duties in a 24x7 environment) in addition to executing on new projects. EDUCATION/EXPERIENCE REQUIRED: + Bachelor's degree required. + Five (5) years of applicable work experience in a data warehousing environment required; three (3) years applicable experience in a Healthcare setting preferred. + Experience with Epic Clarity and Epic Cogito is 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. + Good understanding of HIPAA data Privacy and Security requirements. + Ability to be flexible and work analytically in a problem-solving environment. + Good organizational, multi-tasking, and time-management skills. + Good communication (written and oral) and interpersonal skills. + Proven ability to work independently and as a team member. + Experience/exposure to the System Development Life Cycle (SDLC). Additional Information + Organization: Corporate Services + Department: Helios Enter Data Wrhse IT Exp + Shift: Day Job + Union Code: Not Applicable 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.