Data Analyst

Summary

Join Red Canary's Business Data Infrastructure (BDI) team as a Data Analyst and bridge the gap between raw data and actionable insights. You will collaborate with various teams to understand their challenges, translate business needs into data requirements, and curate datasets that empower decision-making. Leveraging SQL, Python, Sagemaker, and other BI tools, you will construct insight-centric data products, dashboards, and reports. This role requires strong analytical and communication skills, experience with data analysis and visualization tools, and the ability to work effectively in a fast-paced environment. Red Canary offers a competitive salary and benefits package, including stock options and a bonus program.

Requirements

• Bachelor's or Master's degree or equivalent work experience in a relevant field such as Data Science, Economics, Statistics, Computer Science, or a related engineering discipline
• 3+ years of proven experience as a Data Analyst, SQL Engineer, Jr. Data Scientist or similar – preferably in a startup or fast-paced environment
• Strong knowledge of relational databases, distributed storage and semi/un-structured data
• Strong experience working with dashboard tools such as Tableau, Quicksight or Graphnikov
• Excellent problem-solving and critical-thinking skills, with the ability to assess a complex problem set and distill insight into a focused, durable and understandable data product
• Strong communication skills, with the ability to effectively present complex findings and recommendations to non-technical stakeholders
• Self-motivated and proactive, with the ability to work independently and collaborate effectively within a team and across a distributed customer base

Responsibilities

• Collaborate with Business Teams to Define Analytical Needs – Work closely with stakeholders across Red Canary to understand key challenges, define analytical problems, and scope data-driven solutions that drive decision-making
• Source, Curate, and Prepare Data – Extract and integrate data from various systems (in close partnership with our Data Engineering team) using SQL and Python – to ensure clean, well-structured datasets that support deep analysis and reporting
• Develop Insight-Centric Data Products – Design and maintain reusable, well-documented datasets, metrics, and dashboards that empower teams to make data-informed decisions
• Create Dashboards and Reports – Leverage BI tools (such as Quicksight, Tableau, or Streamlit) to render insights in an accessible, visually compelling manner, enabling non-technical users to explore and act on data effectively
• Enable Decision Intelligence – Translate analytical findings into actionable guidance, helping teams optimize strategies and tactics based on data-driven information and insights
• Ensure Data Quality and Consistency – Collaborate with stakeholders and data engineering to validate data quality, diagnose source-system issues and govern/maintain feedback loops which ensure high-quality, reliable, and trustworthy data
• Partner with Data Engineers – Work alongside data engineers to improve data pipelines, enhance accessibility, and ensure analytics needs are met efficiently

Preferred Qualifications

• Some experience with custom graph development in matplotlib, Streamlit or altair
• Some experience working within cloud computing platforms, such as AWS, GCP or Azure
• Exposure to distributed computing, pySpark or production data pipeline is a plus
• Experience with some of our primary data sources is a plus (Intacct, Salesforce, Zendesk, Jira)

Benefits

• Targeted base salary range: $100,000 - $125,000
• This role is eligible for a grant of stock options, subject to the approval of the company's board of directors
• This role is also eligible for participation in the company's bonus program