Sr. Data Analyst

Job Summary

We are seeking an analytical, curious, and detail-oriented Data Analyst to join our Business Intelligence and Analytics team. In this role, you will be responsible for extracting data from various relational databases, performing data hygiene, identifying structural trends, and translating raw numbers into compelling visual dashboards. You will work cross-functionally with product, marketing, and operational teams to help our organization move from intuitive decisions to data-proven strategies.

Key Responsibilities

1. Data Retrieval & Structural Queries (SQL)

• Write and optimize complex queries to pull data across multiple large relational databases and cloud data warehouses (e.g., Snowflake, BigQuery, AWS Redshift).

• Perform table joins, aggregations, and subqueries to combine disconnected metrics into a single, cohesive dataset.

2. Data Preparation & Hygiene

• Identify, diagnose, and clean data anomalies, missing values, duplicates, or formatting inconsistencies before analysis.

• Document data cleaning pipelines to ensure that recurring data ingestion processes remain reproducible.

3. Dashboard Design & Reporting (BI)

• Design, deploy, and maintain interactive business intelligence dashboards utilizing enterprise visual tools (Power BI, Tableau, or Looker).

• Consistently track and monitor core company KPIs (Key Performance Indicators) such as customer acquisition costs, monthly active users, or operational conversion rates.

4. Diagnostic & Trend Analysis

• Apply basic statistical techniques (such as mean, median, correlation, and variance analysis) to uncover operational trends and identify seasonal performance shifts.

• Conduct deep-dive root cause analyses when a standard operational metric drops or shifts unexpectedly.

5. Stakeholder Communication & Storytelling

• Translate intricate data structures into plain language and short summary summaries for non-technical managers.

• Collaborate with data engineers to improve underlying pipeline infrastructure and define data schema requirements.

Core Technical Skills Required

• Database Management: Proficiency in SQL (Joins, CTEs, Window functions, Group By).

• Business Intelligence: Hands-on experience building multi-page dashboards in Power BI, Tableau, or equivalent.

• Data Manipulation: High competency in advanced Excel (Pivot tables, Power Query, advanced statistical formulas).

• Scripting (Nice-to-Have / Growing Trend): Foundational knowledge of Python or R (specifically packages like Pandas, NumPy, and Matplotlib) for automated reporting.

Core Competencies & Power Skills

• Critical Thinking: The ability to challenge a vague business query ("Why are sales slow?") and transform it into a series of highly specific data-driven hypotheses.

• Data Governance Focus: Extreme attention to detail to ensure data privacy frameworks (like keeping Personally Identifiable Information — PII hidden) are respected.

• Agility & Continuous Learning: Adaptability to rapidly picking up new SaaS reporting stacks, enterprise toolkits, and dynamic visualization tools.

Typical Data Analyst Day-to-Day Workflow

1. Morning: Triage inbound analytical request tickets or verify dashboard refresh health logs.

2. Midday: Extract datasets via SQL, perform diagnostic filtering, and build calculated measures.

3. Afternoon: Wireframe visual charts, meet with business leads to scope out requirements, and present recent performance findings.