Business Solution Analyst - Data Warehouse - InterSources Inc.
El grove, CA
About the Job
Business Solution Analyst
Address: EL Grove, CA 95758
36+ Months Contract Position
The work location will be at located in Elk Grove, California, or at another designated location within the greater Sacramento area.
Job Description:
Business Solutions Analyst, under the IT MSA, specializing 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. The Business Solutions Analyst shall obtain and document the business requirements for the current Enterprise Data Warehouse and new and existing Mental Health reports. This analyst shall assist with analyzing and documenting all parts of the data warehouse reporting system, including Extract, Transform, and Load (ETL/ELT) pipelines, Stored Procedures, Data models, and Reporting for end users and assist with test validations.
Responsibilities:
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.
Address: EL Grove, CA 95758
36+ Months Contract Position
The work location will be at located in Elk Grove, California, or at another designated location within the greater Sacramento area.
Job Description:
Business Solutions Analyst, under the IT MSA, specializing 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. The Business Solutions Analyst shall obtain and document the business requirements for the current Enterprise Data Warehouse and new and existing Mental Health reports. This analyst shall assist with analyzing and documenting all parts of the data warehouse reporting system, including Extract, Transform, and Load (ETL/ELT) pipelines, Stored Procedures, Data models, and Reporting for end users and assist with test validations.
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
- 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.
Source : InterSources Inc.
