IT Data Warehousing Analyst in Troy, MI at Hire Road

Date Posted: 12/3/2019

Job Snapshot

  • Employee Type:
  • Location:
    Troy, MI
  • Job Type:
  • Experience:
    Not Specified
  • Date Posted:

Job Description

IT Data Warehousing Analyst

Troy, MI


Our client is a major health system looking to add an experienced IT Data Warehousing Analyst to their information delivery team. The IT Data Warehousing Analyst will collect, analyze and summarize data to support business decisions. They will work closely with customers, vendors, business analysts and application development project teams to resolve information flow and content issues.

The IT Data Warehousing Analyst must have a bachelor’s degree and at least five (5) years of experience in an IT/data analytics role.

IT Data Warehousing Analyst Requirements:

  • Bachelor’s degree
  • Five (5) years of applicable work experience
  • Experience with the System Development Life Cycle (SDLC)
  • Good understanding of HIPAA data Privacy and Security requirements
  • Healthcare experience includes knowledge of EDI transactions; knowledge of Medicare, Medicaid, commercial products; understanding of ACA
  • Good understanding of HIPAA data Privacy and Security requirements
  • Experience in data warehousing, Data Mart environments
  • Deep expertise with Oracle database including SQL/ PL SQL, indexing, partitioning, views, materialized views, performance tuning and optimization
  • Understands Star Schema, Snow flake, Data Warehouse methodologies like Bill Inmon and Ralph Kimball
  • 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
  • Must possess the following personal qualities:
    • Be self-directed
    • Be flexible and committed to the team concept
    • Demonstrate teamwork, initiative and willingness to learn
    • Be open to new learning experiences
    • Accepts and respects diversity without judgment
    • Demonstrates customer service values
  • Preferred experience:
    • Three (3) years of applicable experience in a Healthcare setting
    • Strong knowledge of state-of-the-art software engineering approaches in design, build, test, debugging problems; ongoing technical support
    • Ability to articulate examples of workflows and processes associated with that experience
    • Experience with UNIX operating systems and Oracle database
    • Experience with FACETS, IKA, PEGA and Windows and UNIX operating systems

IT Data Warehousing Analyst Description:

  • 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
  • Ensures 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 into 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
  • Ensures proper documentation and on-time delivery of all functional artifacts and deliverables


Choosing the Hire Road is about shared success, active and committed partnerships and relationships that last.  Hire Road is solely focused on connecting highly skilled professionals with leading organizations. We are a solutions-based, results-oriented staffing company specializing in a wide range of industry specific practices. To put it simply, we recruit, screen and hire talented people for temporary and full-time positions.

This classification description is intended to indicate the general kinds of tasks and levels of work difficulty that are required of positions given this title and should not be construed as declaring what the specific duties and responsibilities of any particular position shall be.  It is not intended to limit or in any way modify the right of any supervisor to assign, direct and control the work of the employees under her/his supervision.  The use of a particular expression or illustration describing duties shall not exclude other duties not mentioned that are of a similar kind or level of difficulty.

Equal Opportunity Employer