Data Analyst

The Data Analyst is responsible for extracting actionable insights from complex datasets and transforming them into visually appealing and intuitive dashboards using Tableau as the primary tool. Supports data-informed decision-making processes across the agency.

DUTIES

SUMMARY

The Data Analyst is responsible for extracting actionable insights from complex datasets and transforming them into visually appealing and intuitive dashboards using Tableau as the primary tool. Supports data-informed decision-making processes across the agency.

ESSENTIAL DUTIES

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• Collaborates with various departments to understand their data needs, objectives, and challenges. Perform in-depth analysis of diverse datasets to identify trends, patterns, and correlations that can drive business insights.

• Utilizes Tableau's features and functionalities to create interactive, dynamic, and visually compelling dashboards and reports. Ensure that the visualizations effectively communicate complex data in a clear and intuitive manner.

• Integrates data from multiple sources and formats into Tableau, ensuring data accuracy, consistency, and reliability.

• Prepares and cleans datasets for analysis and visualization, resolving any data quality issues and handling missing or incomplete data.

• Optimizes Tableau dashboards for speed, efficiency, and responsiveness to deliver a seamless user experience.

• Translates analytical findings into meaningful and persuasive stories using data visualization techniques. Communicate insights effectively to stakeholders at all levels of the organization.

• Stays current with the latest data visualization best practices and industry trends. Apply this knowledge to improve the design and usability of Tableau dashboards.

• Conducts training sessions and provides support to team members and stakeholders in understanding Tableau visualizations, self-service reporting, and data interpretation.

• Ensures compliance with data governance policies and maintains data security standards while handling sensitive information.

SUPERVISORY RESPONSBILITIES

• This job has no supervisory responsibilities.

QUALIFICATIONS

EDUCATION & EXPERIENCE

• High school diploma or general education degree (GED) required.

• Bachelor's degree in Computer Science, Data Science, Statistics, Mathematics, or a related field required.

• Proven experience as a Data Analyst or Visualization Specialist, with a minimum of 3 years of hands-on experience using Tableau to build interactive dashboards and reports.

OTHER QUALIFICATIONS

• Advanced proficiency in Tableau, including calculated fields, parameters, table calculations, LODs, and data blending.

• Strong SQL skills for data extraction and manipulation.

• Familiarity with data visualization best practices and principles.

• Ability to approach complex business problems with a data-driven and analytical mindset. Comfortable with exploratory data analysis and hypothesis testing.

• Excellent verbal and written communication skills. Capable of translating technical findings into non-technical language for stakeholders.

• Collaborative and able to work effectively within cross-functional teams.

• Meticulous in ensuring data accuracy and visualization quality.

• Able to handle multiple projects simultaneously and adapt to changing priorities in a fast-paced environment.

• Ability to work with minimal supervision.

• Ability to handle confidential information. 

• Excellent verbal and written communication skills.

• Reliable transportation to and from the workplace as needed.

• Participates in, conducts, and sustains performance quality improvement activities according to designated role and responsibilities.

• Sensitivity to service population’s cultural and socioeconomic characteristics.

CERTIFICATES, LICENSES, REGISTRATIONS

• Tableau certifications a plus

COMPUTER SKILLS

• Knowledge of programs in a Windows environment, including Word, Excel, Teams, PowerPoint, and Outlook.

• Intermediate knowledge of database software

• Intermediate knowledge of Tableau

PHYSICAL DEMANDS

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Time Spent [None, -1/3, 1/3 - 2/3, 2/3+]

• Stand: -1/3

• Walk: -1/3

• Sit: 2/3 +

• Reach with hands and arms: 2/3+

• Use hands to finger, handle, or feel: 2/3+

• Climb or balance: -1/3

• Bend, kneel, crouch, or crawl: -1/3

• Talk or hear: 2/3+

• Taste or smell: None

• Carry, push or pull: -1/3

• Lifts Weights or Exerts Force

  • Up to 10 pounds: -1/3

  • Up to 25 pounds: -1/3

  • Up to 50 pounds: None

  • Up to 100 pounds: None

  • More than 100 pounds: None

VISION REQUIREMENTS

• No special vision requirements.

WORK ENVIRONMENT

The physical, mental & environmental conditions in which the work is performed. The work environment characteristics described are representative of those an employee encounters while performing the essential functions of this position.  Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.  Time Spent [None, -1/3, 1/3 - 2/3, 2/3+]

Environmental variables that may be indicated as applicable to the position:

• Working near mechanical parts: None

• Work in high, precarious places: None

• Fumes or airborne particles: None

• Toxic or caustic chemicals: None

• Outdoor weather conditions: None

• Extreme cold (non-weather): None

• Extreme heat (non-weather): None

• Risk of electrical shock: None

NOISE LEVEL

• Quiet conditions

REQUIRED TRAINING

• New Hire Orientation

• AB1825: Harassment Prevention training

• Timekeeping & Attendance

COMPENSATION:

$73,601.00 USD - $85,469.00 USD

In accordance with California law, the expected pay range for this position is included in this posting.  The actual compensation will be determined based on factors permitted by law. New hires will be offered a salary at the starting point of the range to maintain internal inequity and allow opportunity for future salary growth. CII salaries are determined based on comprehensive internal and external market analysis, as well as the skills, education, and experience relevant to each position.

BENEFITS: 

• Generous paid PTO, plus 10 paid holidays and CII is closed between Christmas and New Year 

• Excellent medical, dental, and vision insurance for eligible employees and qualified dependents

• 403b Retirement Plan with employer contribution for eligible employees

• Up to $4,500 in tuition reimbursement per calendar year

• Eligible for the Public Service Loan Forgiveness program 

• Flexible Spending Account (FSA) & Health Savings Account (HSA)

• Employer paid Life and AD&D Insurance 

• Voluntary Supplemental Insurance 

• Opportunity for growth & advancement 

• Professional development & continued training 

• Team building & bonding through company sponsored events & activities

CONTINGENCIES: 

• Influenza immunization or declination

• COVID-19, MMR and Tdap immunizations

• Education verification

• Reference check

• Background fingerprint clearance (FBI, DOJ, CACI) conducted by the California Department of Social Services 

• Drug and alcohol screening

• Tuberculosis screening