Senior Business Intelligence Analyst in San Dimas, California | DiversityInc Careers

Senior Business Intelligence Analyst

ADP is hiring a Senior Business Intelligence Analyst in our San Dimas, CA location. In this position you will define and develop new business intelligence capabilities that provide business with new insights for their external clients and internal operations. In this role the Senior Business Intelligence Analyst will help to manage initiatives in data management, business intelligence and analytics, supporting existing and planned activities within its business unit as well as the broader ADP organization. You will assist in defining standardized methods to capture and report key metrics and KPI's related to business objectives and initiatives. You will engage with key stakeholders to define and adopt Data Analytics methodologies and standards. This position will report up to the Senior Director of Business Intelligence and will work closely with client services, business operations and product management, as well as key members of the technology organization.


  • Lead the design and development of business intelligence projects to drive strategic product and operational decisions through data driven actionable metrics and insights.
  • Analyze and groom the Business Intelligence scrum team backlog.
  • Perform detailed data analysis to derive insights and lead other technical resources to deliver operational mechanism such as dashboards or ad-hoc reports.
  • Provide subject matter expertise in data modeling and architecture design.
  • Assist in evaluating and selecting the best technologies and tools to support the BI mission.
  • Manage development and production issues impacting our clients and operations.
  • Monitor and improve data and BI processes to meet firm SLAs and increase efficiency.
  • Help define user stories as a part of the BI scrum team by analyzing business requirements, defining technical specifications and sizing the development effort.
  • Collaborate with the Product Management community to refine product strategies.
  • Leverage technology capabilities and standards while working with technology system owners to identify appropriate data sources and define required data transformation logic.


  • Minimum of 10 years of hands-on experience with SQL and RDBMS
  • Minimum of 5 years of hands-on experience with building semantic-layer business intelligence solutions including metrics, dashboards and data visualization
  • Bachelor's Degree or equivalent in Computer Science or Information Management
  • Minimum of 8 years of hands-on experience with data engineering including ETL and data warehousing

PREFERRED QUALIFICATIONS: Preference will be given to candidates who have the following:

  • Working experience with Oracle, Tableau and Alteryx
  • Working experience in the HCM software or financial industry
  • Working experience with large or medium size companies
  • Expert problem solving skills to rapidly create ad-hoc queries to answer complex business questions or debug data issues
  • Experience developing complex queries against normalized and dimensional data models
  • Ability to work co-operatively as part of a team, as well as independently
  • Excellent verbal and written communication skills

Software in the Cloud. Experts on the Ground:
ADP powers the working world with comprehensive solutions that drive business success. Consistently named one of the "Most Admired Companies" by FORTUNE® Magazine, and recognized by Forbes® as one of "The World's Most Innovative Companies," ADP has over a half-million clients around the globe and 65 years of experience as one of the largest providers of human capital management solutions world-wide.

At ADP, we believe that diversity fuels innovation. ADP is committed to equal employment opportunities regardless of race, color, genetic information, creed, religion, sex, sexual orientation, gender identity, lawful alien status, national origin, age, marital status, non-job related physical or mental disability, or protected veteran status. We support an inclusive workplace where associates excel based on personal merit, qualifications, experience, ability, and job performance.