Tapcart turns your Shopify site into a beautiful mobile app. We work with the biggest brands like BÉIS, Princess Polly, True Classic and 3,000+ others.

With just a few clicks, you can build a custom app with different product grids with search functionality. Send push notifications to your customers with your own set of triggers and messages.

We’re looking for a Senior Data Analyst to join our growing Data Team.

As a Senior Data Analyst at Tapcart, your focus will be on defining and refining ETL processes and SQL transformations within complex data and systems. You’ll enable autonomous navigation through intricate data sets and turn them into actionable insights. You'll leverage visualization tools to craft reports and dashboards that drive decision-making for the business. You’ll also collaborate directly with business stakeholders to convert their data requirements into precise technical specifications so that we may use data strategically across the organization.

The ideal candidate has at least 5 years of experience in data warehousing, data transformation, cloud solutions, and SaaS integration tools and can use their experience to enhance data accessibility and integrity across the organization. Your ability to communicate complex data concepts to non-technical stakeholders and collaborate across teams will be critical in fostering a data-driven culture at Tapcart.

This position is ideal for someone with a strong analytical background, excited to apply their SQL and Python skills to drive business insights, and adept at navigating the challenges of rapidly evolving data environments. Your role will be pivotal in advancing Tapcart's data capabilities, directly impacting our strategic decisions and growth in the e-commerce sector.

HOW YOU WILL MAKE AN IMPACT:

• Design and execute data transformation and ETL processes using SQL, in a minimally documented environment. This task is a critical component of the role, with the majority of time devoted to it
• Create and maintain dynamic dashboards and reports using tools such as Looker Studio, Grow, or similar
• Profile data to gain in-depth understanding and familiarity
• Investigate data discrepancies to identify underlying system issues and root causes
• Analyze data to identify trends, patterns, and insights for informed decision-making
• Collaborate with business units to identify data needs and document existing data sources and usage patterns
• Translate business needs into technical requirements in close collaboration with data engineers and BI developers
• Develop comprehensive documentation on data architecture, user stories, and process flows
• Create and maintain documentation such as data dictionaries, source to target mapping

WHAT SKILLS YOU’LL NEED:

• At least 5 years of experience in all of the below
• Expert capabilities in performing ETL tasks and handling complex data transformations with minimal documentation
• Expert ability to perform complex data queries, reporting, and analysis with SQL
• Competence in using Python for data manipulation, automation, and backend processes
• Experience in creating dynamic dashboards and reports with tools like Looker Studio, Tableau, or similar
• Familiarity with leveraging SaaS data products (e.g., Fivetran, Stitch, dbt) for data integration and transformation
• Proven experience in data warehouse development, including data modeling and schema definition
• Practical knowledge of deploying data solutions on cloud platforms, especially Google Cloud Platform (GCP) and BigQuery
• Strong ability to collaborate with teams across functions, meeting data requirements with effective verbal and written communication and nurturing a team-oriented environment
• Ability to simplify complex technical ideas for diverse audiences
• Affinity for thoughtful, scalable designs with a commitment to best practices, plus favoring sustainable, well-structured data solutions over quick fixes
• Excellent self-management, time management, and virtual communication skills.
• Skilled in navigating and resolving challenges in fluid environments. Quick to learn, adapt, and proactively generate innovative solutions, even with limited information
• Bachelor's degree in a relevant field

BONUS IF YOU HAVE:

• Experience transforming and visualizing data from e-commerce, subscription, or GTM platforms
• Prior experience in a startup environment