Note: The job is a remote job and is open to candidates in USA. Catalight is seeking a Data Analyst II to serve as a subject matter expert across assigned data domains and source systems. The role partners with stakeholders to define metrics, develops scalable analytical solutions, supports enterprise reporting and data quality, and provides insights that improve business decision-making.
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
Skills
- * 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
- * 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
- * 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
- * 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
- * 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
Benefits
- Remote work arrangement
- Full-time employment
Company Overview