This site uses cookies. To find out more, see our Cookies Policy

BI Systems Analyst in Houston, TX at Search Services

Date Posted: 5/31/2018

Job Snapshot

Job Description

SUMMARY:  A Houston Healthcare organization is seeking an experienced BI/Data Warehouse Systems analyst to join their team for a 3 month project with the strong potential to be extended.

RESPOSNIBILITIES: 

-This contract role will support a major reporting initiative for the Children's Learning Institute to deliver interactive reporting available on a public facing website.

-This role would contracted for 3 months.

-The BI systems analyst role will create analytic cubes using Microsoft SSAS tools and create interactive reports using Microsoft SSRS reporting tools or Tableau software.

- The role will work with data from the Engage platform that houses child and teacher data collected from over 800 school districts throughout the state.

- The data is distributed across multiple databases containing over 75 tables with data exceeding 400 million records 

1. Provides technical support for analytical and business intelligence solutions and projects within the IT application areas. Troubleshoots data warehouse issues including data models, application software configuration and supporting Business Intelligence (BI) tools. 
2. Analyzes data requests from various customers to define/determine requirements for modifications and enhancements to existing data warehouse/business intelligence systems. 
3. Designs new data warehouse and business intelligence solutions to accurately address user requirements including development of functional specifications and technical specifications. 
4. Programs or configures data models and structures, business intelligence rules, and applications according to design specifications and departmental standards. 
5. Works with customers to assist in establishing test plans and data; validation of program/reporting functions; and preparation of necessary forms and documentation for implementation. 
6. Coordinates with IT management, systems analysts, users and other IS technical providers to ensure that client requirements are accomplished. 

REQUIREMENTS: 

CERTIFICATIONS/SKILLS: 
• Experience with computer hardware, software and programming 
• Excellent technical and general communication skills, both oral and written 
• Certifications in relevant areas such as SQL, and Microsoft are highly desirable. 
• ERP data warehouse implementation and support experience is highly desirable. 
• Preferable for candidate to have 2+ years’ experience in Microsoft business intelligence suite (SSIS, SSRS, SSAS), Microsoft Sharepoint, MS SQL Server, Excel, adhoc and operational reporting, financial and/or clinical business applications. 

MINIMUM EDUCATION: 
Bachelor’s degree in computer science, business, or related discipline or related experience in lieu of education. 

MINIMUM EXPERIENCE: 
Two years of relevant experience 
Familiar with governmental metric reporting and analysis skills 
Translates target population and metrics into SQL code and visualizations 
Strong SQL development and Tableau visualization skills 
Experience with creating Microsoft analytic cubes using SSAS tools