Business Solution Analyst - Data Warehouse

Business Solution Analyst

The work location will be in Elk Grove, California, or at another designated location within the greater Sacramento area. The Business Solutions Analyst, under the IT MSA, specializes in data warehouse analysis and documentation and must have expert level knowledge, skills, and ability to work with Mental Health and document requirements for reports and business rules, driving those document requirements following industry best practices and methodologies.

Responsibilities:

• Anticipate the needs and workflows of the developers and quality assurance team, enabling high productivity and accuracy throughout the development and release cycle.
• Analyze the structure of the business to determine how it operates and determine its objectives.
• Capture and document business rules via various forms, including interviews with subject matter experts.
• Create detailed business analysis, outlines problems, opportunities and solutions for Mental Health.
• Create test validations for the Mental Health Verification project using Structured Query Language (SQL) for database testing and SQL Server Reporting Services (SSRS) report testing.
• Document requirements and system workflows from gathered requirements such that they can be interpreted and executed by developers and quality assurance team members.
• Document Business rules including data sources, extraction logic, transformation logic and methodology used to calculate the data before it is displayed.
• Document the intended audience, report distribution, method of distribution as well as the data refresh frequency.
• Ensures compliance with policies and procedures with special emphasis on compliance with HIPAA requirements.
• Provide mock-ups to facilitate clear communication.
• Gain business signoff and hand over to the development team.
• Communicate complex technical information that all cross-functional teams can easily comprehend.
• Use Azure DevOps as a tool to relay requirements to the necessary parties.
• Track defects and report bugs using Azure DevOps (aka TFS).

Skill - No. of Years - Company / Project

Each proposed personnel for this classification must have a minimum of five (5) years of experience in Information Technology. At least last three (3) years of that experience must be in gathering and documenting requirements.

This classification requires the possession of a bachelor's degree. Additional qualifying experience may be substituted for the required education on a year-for-year basis.

Experience in gathering business and technical requirements for Data Warehouse Architectures, Data models, Stored Procedures, SSRS Reports and PowerBI Reports

Experience with traditional data warehousing / ETL tools and SQL Server Management Studio (SSMS)

Experience with data warehouse concepts and architecture

Experience producing requirements documents, systems architecture and interfaces, data model diagrams, configuration management documents, and procedural manuals.

Desired: Experience providing training and mentoring to people with various skill levels.

Desired: Experience with Electronic Health Care Record Systems Experience in supporting enterprise solutions within a health care and/or correctional environment

Desired: Experience with organizational change management

Desired: Experience in developing SQL stored procedures and implementing data extract using replication.

About Us: InterSources Inc. is a Small, Woman, and Minority-Owned Business Enterprise, ISO/IEC 27001, SOC 2 Type 2 certified company with massive 18+ years of diversified experience in providing IT Consulting Services, Artificial Intelligence, Data Analysis, Application Development, Cloud Services, Cybersecurity, Digital Marketing, ERP Management, Custom Software Development, Web Development, UI/ UX Design, System Integration, QA Support etc. We make reasonable accommodations for clients and employees, and we do not discriminate based on any protected attribute including race, religion, color, national origin, gender sexual orientation, gender identity, age, or marital status. We also are a Google Cloud and Oracle partner company.