Data Analyst II

Metrics, Business Analysis & Decision Support

• Determine, implement, and evaluate business metrics to meet ongoing organizational, operational, financial, clinical, or customer information needs.
• Translate business questions into analytical approaches, including defining data requirements, selecting appropriate methods, and communicating results in a clear and actionable manner.
• Support forecasting, data mining, variance analysis, financial analysis, operational analysis, and other advanced analytics efforts as needed.
• Produce ad hoc reports and analyses by gathering, transforming, and interpreting data from multiple systems.
• Support mission-critical, strategic, and time-sensitive reporting projects, tasks, and initiatives.

Data Analysis, SQL & Python

• Analyze complex datasets using SQL, Python, and business intelligence tools to identify trends, patterns, risks, opportunities, and performance drivers.
• Gather, integrate, clean, and validate data from disparate sources, including enterprise data warehouses, operational systems, financial systems, and external data sources.
• Build repeatable analytical workflows and reporting processes using SQL, Python, automation tools, and documented procedures to reduce manual effort and improve consistency.
• Pursue opportunities to generate more business insights to advance data-driven decision making across the business.

Business Intelligence, Reporting & Visualization

• Develop and maintain dashboards, reports, and analytical tools using Tableau and other BI platforms, ensuring results are accurate, timely, intuitive, and aligned to business needs.
• Prepare executive-ready summaries, presentations, and visualizations that communicate analytical findings to technical and non-technical audiences.
• Using available tools, including next generation platforms and emerging technologies, perform Data Analytics development and testing to test suitability and advance analytics capabilities within the business.
• Assist the business in interpreting dashboards, reports, and data products to increase data literacy and assist in decision making.

Data Quality, Troubleshooting & Governance Support

• Troubleshoot questions and issues related to data, reporting, dashboards, source systems, definitions, and metric logic.
• Validate data quality, reconcile results across systems, and identify opportunities to improve data reliability and reporting accuracy.
• Create and maintain documentation, including metric definitions, business rules, data sources, transformation logic, report instructions, and standard operating procedures.

Stakeholder Partnership & Data Product Delivery

• Partner with stakeholders to gather requirements, define success measures, and deliver scalable data products that support decision-making.
• Cross-train team members on metrics, reporting processes, analytical methods, and dashboard usage. Provide hands-on guidance to junior team members as needed.
• Look for solutions to democratize data and enable self-service data analytics across the business.

Process Improvement, Automation & Self-Service Enablement

• Identify opportunities for process improvement, automation, self-service reporting, and more effective use of organizational data.
• Stay current on emerging AI/ML data engineering tools and best practices, proactively recommending improvements to existing workflows

Mentorship & Collaboration

• Provide technical guidance and mentorship to junior data engineers and analysts, fostering a culture of learning and continuous improvement
• Contribute to team-wide documentation, code reviews, and engineering standards
• Collaborate effectively in a fully remote environment, maintaining clear and proactive communication across teams

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Data Engineering, or a related field preferred; or 4+ years of experience in data analytics or a related discipline in lieu of a degree
• Experience creating reports, dashboards, and deliverables to enable data-driven decision-making
• Experience in SQL with experience in data modeling
• Hands-on experience with Tableau
• Experience enabling BI tools through the design and delivery of secure, reliable data pipelines, curated data models, and performant data access layers
• Experience enhancing data reliability by creating, updating, validating SQL tables, ensuring accuracy across reporting and operational systems. 
• Demonstrated ability to work collaboratively with both technical and non-technical stakeholders

Requests:

• Must be able to communicate effectively within the work environment, read and write using the primary language within the workplace.
• Visual and auditory ability to work with clients, staff and others in the workplace continuously.
• Frequent speaking and listening (25-75%) to clients, staff, and others in the workplace.

Knowledge, Skills & Abilities (organized by our company values): 

• Seeks to understand the underlying needs, desires, and values of colleagues. 
• Proactively builds spaces for others to engage in learning and community.
• Appreciates and demonstrates collaboration across teams. 
• Serves as a role model, bringing our core values to life in your work. 
• Work in an exciting, fast paced high energy environment while effectively multitasking and managing day-to-day responsibilities without supervision.
• Personable; able to work comfortably with individuals at all levels within the organization.
• Excellent verbal and writing communication skills; frequent proofreading and checking documents for accuracy.

Equity informed:

• Knowledge of multiple historically excluded groups with knowledge in I/DD (intellectual and developmental disability) communities.
• Interest in working with and elevating employee needs. 
• Approaches work with a growth mindset, welcome feedback, and understand that humans all have biases and are imperfect as a baseline. 
• Experience working and communicating with families.
• Sensitivity to working with an ethnically, linguistically, culturally, and economically diverse population.

Bold:

• Navigates ambiguity with an excitement for problem solving. 
• Effectively manages programs from visioning to implementation + impact measure.
• Commitment to meet agreed upon deadlines on time or ahead of schedule. 
• Transparent on action, pursuits, and outcomes.
• A commitment to the values of the organization while demonstrating good judgment, flexibility, patience and discretion when dealing with confidential and sensitive matters.

Wellbeing driven:

• Willingness and commitment to self-reflection and re-thinking.  
• Ability to understand your physical, mental, social, and financial wellbeing needs with a willingness to co-create boundaries that allow you to sustainably show up and honor your humanity.
• Capacity to contribute to and help cultivate effective + sustainable wellbeing driven spaces.
• Commitment to managing a remote schedule that aligns with PST business hours, ensuring your availability supports a healthy team rhythm and effective cross-functional partnership.

Conditions of Employment

• Ability to obtain and maintain criminal record clearance through the Department of Justice (DOJ). The People & Performance Department must analyze DOJ/FBI live scan reports in accordance with applicable Federal, State, and Local laws, as well as fitness for the position.
• Ability to obtain and maintain clearance through the Office of Inspector General.
• Must attend any required training.

Time Type:

Compensation:

The statements contained in this job description reflect general details as necessary to describe the principal functions of this job. It should not be considered an all-inclusive listing of work requirements. Individuals may perform other duties as assigned, including work in other functional areas as deemed fit for the organization.

Catalight is an equal opportunity employer.

4+ years analytics experience or Bachelor's in a related field preferred; strong SQL, Python, Tableau skills; experience building BI pipelines, data modeling, dashboards, and mentoring junior analysts; ability to obtain DOJ/FBI and OIG clearances.

Key Responsibilities

• analyzing data
• developing dashboards
• mentoring analysts

Skills & Tools

SQL, Python, Tableau

Job Details

• Category: Data and Analytics
• Seniority: Mid Level
• Commitment: Full Time
• Workplace: Remote — California or United States
• Salary: USD 120,000 – 163,000 / year
• Languages: English

About Catalight

A mission-driven organization focused on equity, research, and community-centered programs. — Industry: Non-Profit Organizations and NGOs