Data Warehouse Analyst

Job Overview
Job Order:JO00018841
Date Posted:Jun 15
Category:3 - Information Technology (I/T)
Metro Area:

Our Client is looking for a DATA WAREHOUSE ANALYST.


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


  • 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.
  • TITLE: IT Data Warehousing Analyst HH1374 Page: 3 of 3
  • 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
  • Experience with UNIX operating systems and Oracle database is preferred.

If you are a high performer and would like to work for an equally high performing company and you think the above opportunity is appropriate for you, we invite you to apply to this job and email your resume in Word format to

We treat all resumes with strict confidentiality. We will always contact you first before submitting your resume to our client(s) for review. If you do not receive correspondence, you are not a fit for this position.

At Venteon our talent acquisition team is proud to provide our clients with the most qualified Accounting & Finance, Engineering, IT and Administrative talent in the industry today.