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

Responsibilities

• 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 includes 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.

• Bachelors degree required;
• 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
• Department:
  Ctr for Health Srvcs Research
• Shift: Day Job
• Union Code:
  Not Applicable