IT Senior Data Warehousing Analyst​/Solution Architect- Center Health Services

IT Senior Data Warehousing Analyst / Solution Architect
- Center for Health Services

• Under the general direction of the Project Manager, Manager, or the Director, develops and enhances a data warehouse environment which includes data design, database architecture, metadata and repository creation.
• Provides direction and guidance to less experienced team members.
• Reviews data loaded into the data warehouse for accuracy.
• Responsible for the development, maintenance, and support of an enterprise data warehouse system and corresponding data marts.
• Troubleshoots and tunes existing data warehouse applications.
• Conducts research into new data warehouse applications and determines viability for adoption.
• Assists in establishing development standards.
• Evaluates existing subject areas stored in the data warehouse. Incorporates existing subject areas into an enterprise model.
• Creates new or enhanced components of the data warehouse.
• The responsibilities also include troubleshooting application issues and/or data issues when they arise.
• The Senior Data Warehousing Analyst is a leader in an IT team that is accountable for production support (including on-call duties in a 24x7 environment) as well as new projects.
• The ideal candidate will have significant experience using analytical skills to seek out, research and evaluate a variety of options to provide clients with high quality solutions that promote efficiency and enterprise-wide standardization.
• Must demonstrate the ability to mediate and bridge the relationship between technical and business stakeholders without compromising the needs of the solution users and the strategic goals of the organization.

• Advanced degree preferred.
• Years of applicable work experience required; 5 years applicable experience in a Healthcare setting preferred.
• Preferred technical experience includes strong knowledge of state-of-the-art software engineering approaches in design, build, test, debugging problems, and ongoing technical support, and ability to articulate examples of workflows and processes associated with that experience.
• Experience with Epic Clarity and Epic Cogito is preferred.
• Deep expertise with Microsoft Windows Server, SQL Server, TFS, SharePoint, Net and SSIS technologies.
• Experience with Unix operating systems and Oracle database is preferred.
• Good understanding of HIPAA data Privacy and Security requirements.
• Previous supervisory experience preferred.
• Ability to be flexible and work analytically in a problem-solving environment.
• Good organizational, multi-tasking, and time-management skills.
• Excellent communication (written and oral) and interpersonal skills.
• Proven ability to work independently and as a team member.
• Experience with the System Development Life Cycle (SDLC).
• This position is hybrid - 3 days required in the office at One Ford Place, Detroit and 2 days work from home.
• 7 years of applicable work experience required; 5 years applicable experience in a Healthcare setting preferred.

• Organization:
  Corporate Services
• Shift: Day Job
• Union Code:
  Not Applicable

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.

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  .

The health and overall…