Previous Job
IT Data Analyst
Ref No.: 20-00282
Location: Troy, Michigan
Position Type:Full Time
Title: IT Data Analyst
Job ID: 20-00235
Location: HAP offices - 1414 E. Maple Road. Troy, MI 48083
Pay Rate: $40-$45/hour
Additional Benefits: Health, Dental, Vision, 401(k), company paid holidays and more!
Type of hire: Contract
Shift: 1st Shift Mon-Fri (9am-5pm)

Position 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 validation.
  • 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 the 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.
  • Ensure proper documentation and on-time delivery of all functional artifacts and deliverables.

Position Requirements:
  • Healthcare experience includes knowledge of EDI transactions; knowledge of Medicare, Medicaid, commercial products; understanding of ACA.
  • Experience with FACETS, IKA, PEGA and Windows and UNIX operating systems is preferred.
  • 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, Snowflake, Data Warehouse methodologies like Bill Inmon and Ralph Kimball
  • Experience with UNIX operating systems and Oracle database is preferred.
Education and Training Requirements:
  • Bachelor's degree required.
  • Five (5) years of applicable work experience required; 3 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.

GTA Questions:
  1. Are you a former HFHS direct employee or contractor? (If you are a previous HFHS employee please provide dates of employment, whether you were contract or direct and, the name of your supervisor)
  2. Last 4 of your SSN:
  3. Day and Month of your Birth (we do not need the year)
  4. What is the highest level of education you have completed? Which field of study is this degree in and from which university did you graduate?
  5. Are you currently working? If not, when was your last day of employment?
  6. What is your "acceptable and "ideal base compensation for this position? We would like to make sure we don't price you out of consideration, but you know what the numbers are that you need (Please Do Not put negotiable)
  7. When would you be available to interview and start this position, if selected?
Please note that if you are a current GTA employee or are currently employed by one of our clients, we are unable to assist you. However, if you know someone who is seeking employment and is qualified for one of our open positions, you could benefit from our Bonus Referral Program.

Bonus Referral Program
If you refer someone we hire, we can offer up to $250 for contractors after they are on the job for 90 days and up to $500 for direct hires after they are on the job for 90 to 180 days, depending on the customer's payment terms.