Previous Job
Previous
Data Warehouse Expert
Ref No.: 18-29019
Location: Richmond, Virginia
Job Title: Data Warehouse Expert
Duration: Long Term Contract
Location: Richmond, VA


Primary Responsibilities:
• Gather and analyze business requirements
• The complete inventory of all Agency data sources and business processes from an IT perspective
• Review the data warehouse infrastructure design and offer solutions
• Review the MMIS infrastructure design and offer suggestions and insight to vendor
• Review the infrastructure designs of MES components and analyze the impact of each on the data warehouse solution
• Assist with the review of all technical specifications and design documents associated with the data warehouse solution
• Review and test the integration of data in the data warehouse/data marts and Business Intelligence solutions
• Communicate effectively, verbally and in writing, with programmers, analysts, immediate supervisor, management, system users, operations, other State agencies, and the private sector.
• Able to work independently
• Excellent communication, time/project management, problem-solving, organizational, and analytical skills required.

Required Qualifications:
• Bachelor’s degree or equivalent work experience
• 5+ years of experience with Medicaid, Medicare or other health systems
• 5+ years of technical business analyst experience in a data warehouse project environment
• 5+ years working with end users/customers to understand and develop requirements for technical solutions to meet business needs
• 5+ years analyzing project requirements and developing detailed technical specifications
• 5+ years working with technical developers to strategize solutions to align with business requirements
• 5+ years recent Teradata experience
• 5+ years administering SAS in a Unix/Linux environment
• 3+ years facilitating customer requirements gathering meetings/sessions/JAD Sessions
• 3+ years working knowledge of relational databases/database structures
• 3+ years experience with Requirements Traceability
• 3+ years experience with BI reporting tools
• 3+ years developing test data and test scenarios
• Experience with SAS In-Database processing with Teradata

Preferred Qualifications:
• Knowledge of MMIS architecture
• Ability to design applications taking into consideration data reconciliation, query/reporting performance, and analytical business value.
• Business Analyst experience in a state government environment
• Experience with Teradata SQL Assistant
• Experience using Teradata Utilities
• Experience with implementing SAS/Teradata interfaces
• Experience using Erwin for data modeling
• Open Text BI Query experience
 
Skill Required / Desired Amount of Experience
Bachelor’s degree or equivalent work experience Required  
experience with Medicaid, Medicare or other health systems Required 5 Years
years technical business analyst experience in a data warehouse project environment Required 5 Years
working with end users/customers to understand and develop requirements for technical solutions to meet business needs Required 5 Years
years analyzing project requirements and developing detailed technical specifications Required 5 Years
years working with technical developers to strategize solutions to align with business requirements Required 5 Years
recent Teradata experience Required 5 Years
administering SAS in a Unix/Linux environment Required 5 Years
facilitating customer requirements gathering meetings/sessions/JAD Sessions Required 5 Years
working knowledge of relational databases/database structures Required 5 Years
Requirements Traceability Required 5 Years
BI reporting tools Required 5 Years
developing test data and test scenarios Required 5 Years
SAS In-Database processing with Teradata Required 5 Years
Knowledge of MMIS architecture Highly desired  
Ability to design applications taking into consideration data reconciliation, query/reporting performance, and analytical business value. Highly desired  
Business Analyst experience in a state government environment Highly desired  
Experience with Teradata SQL Assistant Highly desired  
Experience using Teradata Utilities Highly desired  
Experience with implementing SAS/Teradata interfaces Highly desired  
Experience using ERWin for data modeling Highly desired  
Open Text BI Query experience Highly desired