Senior SQL/ETL Developer, Tapcart

• 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
• 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

Desirable

• As a Senior SQL/ETL Developer 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
• Your role will be pivotal in advancing Tapcart's data capabilities, directly impacting our strategic decisions and growth in the e-commerce sector
• 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

• 401k: Our 401(k) plan is designed to help you secure a strong financial future
• Flexible Paid Time Off: Take time off whenever you need it with our flex PTO policy
• 11 paid holidays per year: We offer 11 paid holidays annually, allowing you to spend quality time with loved ones, celebrate special occasions, and recharge. These holidays help you stay refreshed and motivated
• Office setup budget: One-time home office stipend for outfitting your home office
• Equity: We share our success through a generous equity program, giving you a stake in our growth
• Shopping stipend to use on Tapcart Merchant Apps: Enjoy a shopping stipend to use on our Tapcart customer mobile shopping apps. This benefit lets you explore and purchase products from our valued customers, supporting their businesses and Tapcart!
• Health & wellness coverage: We offer medical, dental, and vision plans, plus HSA!
• Paid Parental Leave: For birthing and non-birthing parents, plus adoption and foster leave

Total funding: $69.2m

Online shopping has rapidly shifted to mobile in recent years, with the majority of Internet shopping transactions now taking place on mobile devices. For businesses that lack the resources or time to engage developers or hire an agency to build a mobile app, this means potentially losing out on a huge proportion of customers. Tapcart is a mobile commerce SaaS platform that integrates directly with Shopify, offering a solution to this problem.