Data Warehouse Reporting Analyst Sr
$45.67-74.5
- 2023-10-11
- temporal
-
CA - Orange
Job Description:
Data Warehouse Reporting Analyst Sr
Job
Summary
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 incumbent 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 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. The incumbent is responsible for administering report security and deployment within ITS 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
security, deployment, upgrades and maintenance.
- Maintains effective working
relationships with the DW Team, other Information Services teams and the
other business departments.
- Maintains knowledge of business processes and application design and understand cross-functional business relationships and their use of information.
Possesses
the Ability To:
- Develop and maintain code using
Microsoft SQL Server, Business Intelligence tools.
- Administer Business Intelligence
tools.
- 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 orally and in writing.
- 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
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 is also 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.
Knowledge
of:
- SQL Server development including
database design and stored procedures.
- Microsoft online analytical
processing (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.
At
Sunshine Enterprise USA LLC, we firmly believe that our employees are the
heartbeat of our organization and we are happy to offer the following benefits:
•
Competitive pay & weekly paychecks
•
Health, dental, vision, and life insurance
•
401(k) savings plan
•
Awards and recognition programs
•
Benefit eligibility is dependent on employment status.
Sunshine Enterprise USA is an “Equal
Opportunity Employer—Minorities, Females, Veterans and Disabled Persons”
Apply Here