Henry Ford Health · 1 day ago
IT Data Warehousing Analyst (Hybrid/Troy, MI) - Health Alliance Plan
Troy, MI
Full-time
Hybrid
Mid Level
3+ years expHenry Ford Health is a respected academic medical center that partners with millions on their health journey. They are seeking an IT Data Warehousing Analyst to develop and enhance a data warehouse environment, ensuring data accuracy and supporting enterprise data warehouse systems.
BiotechnologyHealth CareHealth InsuranceMedical
Responsibilities
Collects, analyzes and summarizes data to support business decisions
Identifies opportunities for reuse of data across the enterprise. Validates data sources
Keeps abreast of new Tools & Technology and functionalities across the application(s)
Works closely with customers, vendors, business analysts and application development project teams to resolve information flow and content issues
Ensure data integrity and compliance by performing data profiling and data validations
Facilitates meetings with clients to gather and document requirements and explore potential solutions
Gathers data and reporting requirements. Detects and summarizes patterns in data and findings by producing simple reports and works with development teams for problem resolutions
Analyzes and documents client's business requirements and processes and communicates these requirements by constructing conceptual data and process models, including data dictionaries and volume estimates from organization
Collaborates with work teams, departments, system leadership, staff, other IT groups, and technology vendors to define needs and facilitate solutions
Provides input into developing and modifying systems to meet client needs and develops business specifications to support these modifications
Creates test scenarios and develops test plans to be used in testing the business applications in order to verify that client requirements are incorporated in to the system design
Assists in analyzing testing results throughout the project
Assists in coordinating business analyst tasks on information technology projects, problem tickets and provide support to other team members
Provides support, escalation response to production problem issues/errors. Performs root cause analysis and application resolution
Provides on call second-level escalation response for client issues and problem tickets
Assists in providing time estimates for project related tasks
Ensure proper documentation and on-time delivery of all functional artifacts and deliverables
Qualification
Required
Bachelor's degree required
Three (3) years of applicable work experience required; 3 years applicable experience in a Healthcare setting preferred
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
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)
Healthcare experience includes knowledge of Medicare & Medicare Advantage products, Commercial products including Affordable Care Act(ACA)
Experience in data warehousing, Data Mart environments
Deep expertise with Relational database like Oracle, SQL Server, Azure Synapse etc. including SQL/ PL SQL, indexing, partitioning, views, materialized views, performance tuning and optimization
Understand Star and Snowflake Schema, Data Warehouse methodologies like Bill Inmon and Ralph Kimball
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 FACETS, IKA, PEGA, GENESYS applications and Windows operating systems is preferred
Experience with Azure environment and Databricks is preferred
Benefits
Competitive health plan options, with three consumer-driven health plans (CDHPs), a PPO plan and an HMO plan
Dental and eye care coverage
Tuition assistance
Family forming benefits
Discounts to dozens of businesses
Company
Henry Ford Health
*Job seekers: please be aware of fraudulent job postings and phishing scams via LinkedIn.
10001+ employees
H1B Sponsorship
Henry Ford Health has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (212)
2024 (156)
2023 (134)
2022 (159)
2021 (140)
2020 (153)
Funding
Current Stage
Late StageTotal Funding
$40.27MKey Investors
Mort Harris
2020-06-04Grant· $0.27M
2018-04-09Grant· $20M
2016-12-05Grant· $20M
Leadership Team
Robert Riney
President and CEO
Recent News
2025-11-07
Company data provided by crunchbase