Senior Data Warehouse Reporting Analyst, Onsite

Full Time, onsite
V Group Inc
On Site, United States of America

Salary undisclosed

Apply on

Dice

Original

Simplified

Direct Client: CalOptima Healthcare
Job Title: Senior Data Warehouse Reporting Analyst
Duration: 06-12 Months
Start Date: ASAP
Location: 505 City Parkway West, CA Orange 92868 (Onsite)
Position Type: Contract
Interview Type: In Person/Web Interview
Ceipal ID: CAL_BI295_RP

Department: ITS - Enterprise Architecture

Description:

CalOptima Health is seeking a Data Warehouse Reporting Analyst Sr (3) to join our team.
The Data Warehouse Reporting Analyst Sr. collaborates with the Information Technology Services (ITS) and Data Warehouse (DW) teams to develop and support organization-wide reporting.
The Candidate participates in gathering and documenting report requirements and is responsible for designing, building and administering reporting solutions for requesting departments. Assistance will be provided to departmental Business/Data Analysts in developing reports using the available business intelligence (BI) tools.
The candidate will develop ad-hoc reports for business users as applicable and participate in the design and development of the reporting infrastructure using Structured Query Language (SQL) Server technologies and BI reporting tools.
The candidate is responsible for administering report security and deployment within CalOptima Health ITS and data security policies as well as future environment upgrades.

Duties & Responsibilities:

95% - Program Support Participates in a mission-driven culture of high-quality performance, with a member focus on customer service, consistency, dignity and accountability.
Assists the team in carrying out department responsibilities and collaborates with others to support short- and long-term goals/priorities for the department.
Leads the development of business and functional requirements for reports.
Designs, develops, tests and implements reports/dashboards and extraction, transformation and loading (ETL) to fulfill business requirements as needed.
Serves as a subject matter expert across the organization and assists users with reporting (including ad-hoc reporting) and analysis activities and tools.
Supports user training, testing, documentation and the roll-out of reports and end-user reporting tools.
Administers BI security, deployment, upgrades and maintenance.
Maintains effective working relationships with the DW team, other Information Services teams and the other business departments within CalOptima Health.
Maintains knowledge of business processes and application design and understand cross-functional business relationships and their use of information.
Participates in a mission-driven culture of high-quality performance, with a member focus on customer service, consistency, dignity and accountability.
Assists the team in carrying out department responsibilities and collaborates with others to support short- and long-term goals/priorities for the department.
Leads the development of business and functional requirements for reports.
Designs, develops, tests and implements reports/dashboards and extraction, transformation and loading (ETL) to fulfill business requirements as needed.
Serves as a subject matter expert across the organization and assists users with reporting (including ad-hoc reporting) and analysis activities and tools.
Supports user training, testing, documentation and the roll-out of reports and end-user reporting tools.
Administers BI security, deployment, upgrades and maintenance.
Maintains effective working relationships with the DW team, other Information Services teams and the other business departments within CalOptima Health.
Maintains knowledge of business processes and application design and understand cross-functional business relationships and their use of information.
5% - Completes other projects and duties as assigned.

Minimum Qualifications:

High School diploma or equivalent required.
5 years of experience with general relational databases and reporting development required.
5 years of experience with BI data warehousing reporting analysis, design, testing and administration required.
5 years of experience developing Microsoft SQL Server stored procedures and using reporting tools such as SQL Server Reporting Services (SSRS), Tableau, Power BI, MicroStrategy, Business Objects and/or Cognos for developing reports required.
An equivalent combination of education and experience sufficient to successfully perform the essential duties of the position such as those listed above may also be qualifying.

Preferred Qualifications:

Bachelor's degree in information technology or related field.
1 year of experience in developing reports in a health care related business, preferably a health plan.
Experience with SSRS, Tableau and/or Power BI strongly preferred.

____________________________________________________________________________________________________________________________________
V Group Inc. is an IT Services company that supplies IT staffing, project management, and delivery services in software, network, help desk, and all IT areas. Our primary focus is the public sector including state and federal contracts. We have multiple awards/ contracts with the following states: CA, FL, GA, MD, MI, NC, NY, OH, OR, PA, SC, VA, and WA, CT, TN. If you are considering applying for a position with V Group or partnering with us on a position, please feel free to contact me with any questions you may have regarding our services and the advantages we can offer you as a consultant.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Report this job

Similar Jobs

1d ago

Online Sales Officer - Auto Loan

Security Bank Corporation