Demo

Data Warehouse Reporting Analyst Senior

Sunshine Enterprise Inc
Orange, CA Full Time
POSTED ON 1/16/2025
AVAILABLE BEFORE 4/13/2025

Job Description

At Sunshine Enterprise USA, we're not just a company; we're a community of dedicated professionals committed to excellence and innovation. As a leading force in the business landscape, we take pride in bringing together great people and great organizations by fostering a work environment that values creativity, diversity, and growth. If you're ready to embark on a rewarding career journey with a company that prioritizes its employees, explore our current job opportunities below.

Job Title : Data Warehouse Reporting Analyst Sr.

Department(s) : ITS - Enterprise Data and Systems Integrations

Reports to : Manager, Information Technology Services

Salary : $45.67 to $74.55 per hour

Duration : up to 6 months.

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 participate 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 includes 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"

    Salary : $46 - $75

    If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
    Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

    What is the career path for a Data Warehouse Reporting Analyst Senior?

    Sign up to receive alerts about other jobs on the Data Warehouse Reporting Analyst Senior career path by checking the boxes next to the positions that interest you.
    Income Estimation: 
    $114,981 - $143,201
    Income Estimation: 
    $129,640 - $165,363
    Income Estimation: 
    $115,838 - $142,817
    Income Estimation: 
    $129,640 - $165,363
    Income Estimation: 
    $68,745 - $88,154
    Income Estimation: 
    $87,428 - $116,878
    Income Estimation: 
    $91,609 - $116,575
    Income Estimation: 
    $129,640 - $165,363
    Income Estimation: 
    $151,182 - $194,086
    Income Estimation: 
    $87,428 - $116,878
    Income Estimation: 
    $115,838 - $142,817
    Income Estimation: 
    $114,981 - $143,201
    View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

    Job openings at Sunshine Enterprise Inc

    Sunshine Enterprise Inc
    Hired Organization Address Maitland, FL Full Time
    Job Description Company Overview : Sunshine Enterprise USA has an exciting opportunity for a Staffing Sales Manager with...
    Sunshine Enterprise Inc
    Hired Organization Address Maitland, FL Full Time
    Job Description On-site Recruitment Manager / Business Development Company Overview : Sunshine Enterprise Consulting is ...
    Sunshine Enterprise Inc
    Hired Organization Address Chicago, IL Part Time
    Organization Summary Sunshine Enterprises is a 501(c)(3) nonprofit based in Chicago, IL. Sunshine Enterprises fosters ec...
    Sunshine Enterprise Inc
    Hired Organization Address Tampa, FL Full Time
    Job Description Concrete Laborer The ideal candidate for the General Labor position will possess competency in the follo...

    Not the job you're looking for? Here are some other Data Warehouse Reporting Analyst Senior jobs in the Orange, CA area that may be a better fit.

    Data Warehouse Reporting Analyst Sr.

    Sunshine Enterprise Inc, Orange, CA

    Senior Billing Analyst

    CLOUD BIG DATA TECHNOLOGIES LLC, Newport, CA

    AI Assistant is available now!

    Feel free to start your new journey!