Data Analyst II

Catalight

1d•$120,000 - $163,000•Remote

About The Position

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.

Requirements

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
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.
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.
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.
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.
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.
Ability to obtain and maintain criminal record clearance through the Department of Justice (DOJ).
Ability to obtain and maintain clearance through the Office of Inspector General.
Must attend any required training.

Nice To Haves

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.
Bold: Navigates ambiguity with an excitement for problem solving.
Wellbeing driven: Willingness and commitment to self-reflection and re-thinking.

Responsibilities

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.
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.
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.
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.
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.
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.
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.