Senior Data Analyst

About the Role

As a Senior Data Analyst, you will design, build, and own the analytics that ShipStation Global’s business teams use to make decisions. This role sits between the data platform built by data engineering and the business, performing data discovery, defining and governing metrics, and conducting analysis to support client decisions. You will present results in a meaningful and intuitive format using various BI tools and techniques.

Responsibilities

• Partner directly with business stakeholders to turn ambiguous requests into well-defined analytics deliverables.
• Lead discovery conversations with Finance, Accounting, Sales, Marketing, and Product to uncover the underlying decision or business problem.
• Translate open-ended asks into documented requirements: metric definitions, grain, dimensionality, filters, refresh cadence, and clear acceptance criteria.
• Challenge assumptions and propose better framing when the requested output would not answer the question being asked.
• Design, build, and maintain analytics data models using dbt on BigQuery and Databricks.
• Write advanced SQL, including window functions, incremental logic, complex joins, and query tuning.
• Implement data quality controls such as dbt tests, source freshness checks, and anomaly monitoring.
• Own the semantic layer and BI delivery, developing LookML views, explores, and reusable measures.
• Build and maintain Looker dashboards, Looks, schedules, and alerts; develop Power BI semantic models and reports.
• Optimize dashboard performance and query cost; manage content organization and access controls.
• Enable self-service by documenting metric definitions, training stakeholders, and building durable assets.
• Perform exploratory and root-cause analysis to explain trends in sales, revenue, margin, customer retention, and operational performance.
• Reconcile analytics output against source systems and finance reporting, investigating discrepancies.
• Write up findings, caveats, and recommendations for a non-technical executive audience.
• Support platform modernization and post-merger integration efforts.
• Automate recurring manual reporting using Python and scheduled orchestration.
• Maintain documentation, standards, and data governance.

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Analytics, Engineering, Statistics, Economics, or a related quantitative field; equivalent hands-on experience considered.
• 5+ years of experience building business intelligence and analytics solutions on a cloud data platform.
• 3+ years of advanced SQL in a production analytics environment.
• 3+ years of hands-on dbt experience building and maintaining production models.
• 3+ years of dashboard and report development in a modern BI tool; Looker and LookML strongly preferred.
• Demonstrated experience gathering requirements directly from business stakeholders with limited direction.
• Working experience with Google Cloud Platform, particularly BigQuery.
• Proficiency with Python and Git-based development workflows.

Skills

• Advanced SQL, including complex analytical queries, window functions, and performance optimization.
• Hands-on analytics engineering with dbt: modular models, tests, macros, snapshots, and CI/CD deployment.
• Working depth in modern cloud data warehouses (BigQuery, Databricks) including partitioning, clustering, and cost management.
• Semantic layer development in LookML or equivalent metrics modeling layer.
• Dashboard and report development in Looker, Power BI, or Tableau with strong visualization principles.
• Python for automation, data manipulation, and API integration.
• Git-based version control and collaborative code review.
• Ability to operate effectively without fully specified requirements.
• Excellent written and verbal communication, especially for non-technical audiences.
• Business curiosity and willingness to learn about shipping, logistics, and subscription revenue.
• Strong ownership and ability to manage multiple stakeholders and shifting priorities.

What Will Make You Stand Out

• Experience with Databricks (Unity Catalog, Delta Lake, SQL Warehouses, PySpark).
• Power BI experience (semantic models, DAX, Power Query, workspaces, deployment pipelines).
• Experience supporting Finance and Accounting analytics (revenue, billing, margin reconciliation).
• Industry background in logistics, transportation, e-commerce, or SaaS.
• Experience with post-merger systems integration or BI platform migration.
• Experience with orchestration tools (Cloud Composer, Airflow, Dagster, dbt Cloud).
• Familiarity with Jira and Confluence for request intake and documentation.
• Practical experience applying AI and LLM tools to accelerate analytics development.

Benefits

• Hybrid work model (3 days per week in office in Austin or Dallas, Texas).
• Flex Time Off policy and 12 paid holidays for US employees.
• 401k employer matching program.
• Annual merit reviews.
• Company events and team-building activities.
• Attractive office space with free drinks, snacks, and weekly catered lunches.
• Health and wellness options, including medical, dental, and vision plans.
• On-site fitness center with Tonal Mirrors, Pelotons, and free weights.
• Employee Assistance Program with up to 8 free mental health sessions.
• Gym discounts and education reimbursement.
• Employee Referral Program.
• Inclusive, casual, and upbeat work environment.

This position requires sitting for prolonged periods, using wrist and hands extensively, walking short distances, standing for short periods, speaking, and lifting up to 25 lbs.