Data Analyst II

The Data Analyst II serves as a subject matter expert on assigned data domains and source systems, partners with stakeholders to define metrics and reporting needs, and develops scalable analytical solutions that improve accuracy, efficiency, and business understanding. This role is expected to support enterprise reporting, ad hoc analysis, data quality validation, process improvement, and documentation while helping business leaders interpret trends, risks, and opportunities.

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:

Full time

Compensation:

$120,000.00 - $163,000.00 Annually

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.

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