This job is archived
(Archived) Data Warehouse Reporting Analyst, Sr.
Job Description
Data Warehouse Reporting Analyst, Sr.
Job Description
Department(s): Information Systems - Systems Development
Reports to: Supervisor, Systems Development
FLSA status: Non-Exempt
Salary Grade: N - $95,000 - $133,000
Job Summary
This position collaborates with the Information Services (IS) and Data Warehouse (DW) teams to develop and support organization-wide reporting. The incumbent participates in gathering and documenting report requirements. The incumbent is also 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 incumbent will develop ad-hoc reports for business users as applicable and participates in the design and development of the reporting infrastructure using Structured Query Language (SQL) Server technologies and BI reporting tools (SQL Server Reporting Services [SSRS]/Tableau). Responsible for administering report security and deployment within CalOptima IS and data security policies as well as future environment upgrades.
Position Responsibilities:
• 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 Business Intelligence (SSRS/Tableau) security, deployment, upgrades, and maintenance.
• Maintains effective working relationships with the DW Team, other Information Services teams, and the other business departments within CalOptima.
• Maintains knowledge of business processes and application design and understand cross-functional business relationships and their use of information.
• Other projects and duties as assigned.
Possesses the Ability To:
• Develop and maintain code using Microsoft SQL Server, Business Intelligence tools (SSRS/Tableau).
• Administer Business Intelligence Tool (SSRS/Tableau).
• Follow detailed procedures to apply security policies in a consistent manner.
• Understand business requirements and propose practical solutions.
• Build consensus and work effectively within cross-departmental teams.
• Listen to customers (e.g., staff, etc.) to understand and respond positively to their requests.
• Have exceptional initiative and follow-through on projects with minimal supervision and guidance.
• Initiate and maintain cooperative relationships with coworkers, managers, supervisors, customers/clients, and members of the public.
• Take direction, accept constructive criticism, and be diplomatic when reviewing the work of others.
• Solve problems and work on multiple projects in a fast-paced, deadline-driven environment.
• Communicate clearly and concisely, both verbally and in writing with all levels of staff and outside vendors.
• Utilize computer and appropriate software (e.g., Microsoft Office: Word, Outlook, Excel, PowerPoint, Access, Project) and job specific applications/systems to produce correspondence, charts, spreadsheets, and/or other information applicable to the position assignment.
Experience & Education:
• 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 SSRS, Tableau, MicroStrategy, Business Objects, and/or Cognos for developing reports required.
Preferred Qualifications:
• Bachelor's degree in Information Technology or related field highly preferred.
• 1 year of experience in developing reports in a HealthCare related business, preferably a health plan, strongly preferred.
• Experience with SSRS and/or Tableau strongly preferred.
Knowledge of:
• SQL Server development including database design and stored procedures.
• Microsoft OLAP tools and analysis constructs.
• Server software operation, maintenance, and extension (using various programming tools) and demonstrated ability to apply this knowledge to multiple server platforms.
• Software Development Life Cycle Methodology.
CalOptima is an equal employment opportunity employer and makes all employment decisions on the basis of merit. CalOptima wants to have qualified employees in every job position. CalOptima prohibits unlawful discrimination against any employee, or applicant for employment, based on race, religion/religious creed, color, national origin, ancestry, mental or physical disability, medical condition, genetic information, marital status, sex, sex stereotype, gender, gender identity, gender expression, transitioning status, age, sexual orientation, immigration status, military status as a disabled veteran, or veteran of the Vietnam era, or any other consideration made unlawful by federal, state, or local laws. CalOptima also prohibits unlawful discrimination based on the perception that anyone has any of those characteristics or is associated with a person who has, or is perceived as having, any of those characteristics.
If you are a qualified individual with a disability or a disabled veteran, you may request a reasonable accommodation if you are unable or limited in your ability to access job openings or apply for a job on this site as a result of your disability. You can request reasonable accommodations by contacting Human Resources Disability Management at [Register to View] .
Job Location: Orange, California
Position Type:
To apply, visit https://apptrkr.com/2400010
Copyright ©2021 [Register to View] Inc. All rights reserved.
[Register to View]
jeid-0c81be316d13e2408855dfe2d468662f