IT Data Warehousing Analyst (W2 only)
The Judge Group Inc.

Job Info

---

Location: Detroit, MI
Salary: $42.00 USD Hourly - $45.00 USD Hourly
Description:
Job Title: IT Data Warehousing Analyst (W2 Only)

Location: Fully Remote

Duration: 1+ Year Contract

Interview Process: 2-Step Interview Process

Shift: 1st Shift (Monday - Friday, 9:00 AM - 5:00 PM EST)

Pay Rate: $42.00 - $45.00 per hour

Notes from the Hiring Manager:

• Self-starter with good communication skills
• Must have experience in:
  • Data warehousing
  • SQL
  • Healthcare domain
  • At least 3 years of relevant experience
• Open to candidates across the United States
• No overtime required

Job Summary:

• Collect, analyze, and summarize data to support business decisions.
• Identify opportunities for data reuse across the enterprise and validate data sources.
• Stay updated on new tools, technologies, and functionalities.
• Collaborate with customers, vendors, business analysts, and development teams to resolve information flow and content issues.
• Ensure data integrity and compliance through data profiling and validations.
• Facilitate client meetings to gather and document requirements and explore solutions.
• Gather data and reporting requirements, detect patterns, and produce simple reports.
• Analyze and document business requirements and processes, and communicate these through conceptual data and process models.
• Work with various teams to define needs and facilitate solutions.
• Provide input for system modifications and develop business specifications.
• Create test scenarios and plans to verify client requirements in system design.
• Assist in analyzing testing results and coordinating business analyst tasks on IT projects.
• Provide support and escalation response for production issues and perform root cause analysis.
• Offer on-call second-level escalation response for client issues.
• Assist in providing time estimates for project tasks.
• Ensure proper documentation and timely delivery of all functional artifacts and deliverables.

Skills/Experience:

• Minimum of 5 years of relevant work experience.
• Good understanding of HIPAA data privacy and security requirements.
• Ability to work flexibly and analytically in a problem-solving environment.
• Strong organizational, multi-tasking, and time-management skills.
• Excellent written and oral communication and interpersonal skills.
• Proven ability to work independently and as part of a team.
• Experience with the System Development Life Cycle (SDLC).
• Healthcare experience, including knowledge of EDI transactions, Medicare, Medicaid, commercial products, and ACA.
• Experience in data warehousing and Data Mart environments.
• Expertise with Oracle database, including SQL/PL SQL, indexing, partitioning, views, materialized views, performance tuning, and optimization.
• Understanding of Star Schema, Snowflake, and Data Warehouse methodologies like Bill Inmon and Ralph Kimball.

Preferred Skills & Experience:

• Experience with UNIX operating systems and Oracle database.
• Strong knowledge of modern software engineering approaches in design, build, test, debugging, and ongoing technical support.
• Experience with FACETS, IKA, PEGA, and Windows and UNIX operating systems.
• 3 years of applicable experience in a healthcare setting.

Education:

• Bachelor's degree required.

Application: Please send your resume to: kbarrymore@judge.com

Contact: kbarrymore@judge.com

This job and many more are available through The Judge Group. Find us on the web at www.judge.com

---