Position Detail

1154842

South Bay Consulting Services is seeking a

Data Warehouse Expert (577421)

Location:
Richmond, VA
VA
Contract duration:
10/22/2018 - 10/19/2019
Requirements:
Rate:
58.46-73.08
USD/hr (DOE)
We are only working on W2 and 1099 opportunities.
We consider working 1099 opportunities (direct to employee).
No C2C or C2H, no visa sponsorship.
Job Description:

The team is comprised of both State and contracted workers and includes project managers and State subject matter experts as well as Teradata and web developers, data modelers, DBAs, business analysts, report developers, and help desk analysts. You will support the development and management of the agency data warehouse, including, but not limited to, public and secured data applications, ETL tools, and relational databases. Additionally, you will be responsible for designing and developing SQL which will be used by analysts to interact with agency data in a Teradata environment.

Primary Responsibilities:
• Gather and analyze business requirements
• 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 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 experience with Medicaid, Medicare or other health systems
• 5+ years 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

Job Qualifications:

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

NAVIGATION
SERVICES
GOVERNMNENT

© 2018 South Bay Consulting Services