Enterprise Data Warehouse Data Engineer

Tapcart is the ultimate mobile commerce platform fueling the fastest growing brands. We power mobile apps for over 50 million consumers worldwide, processing over $6 billion in mobile commerce revenue.
Almost all ecommerce traffic comes from a mobile device; we turn these users into high retention growth for some of the largest brands, including Charlotte Russe, Pier 1, True Classic, and many more. Tapcart is trusted by thousands of brands to power their mobile experience by building mobile apps in hours (not months).
We are in search of an experienced Enterprise Data Warehouse Data Engineer to join our growing Enterprise Data Warehouse team. The Enterprise Data Warehouse Data Engineer will bring us tremendous value in extracting and ingesting raw data from various platforms such as Salesforce, Shopify, and other go-to-market and eCommerce platforms, using REST APIs, GraphQL, and preparing and modeling it in a usable format for data architecture, strategy and analytics.  The Enterprise Data Warehouse Data Engineer will also construct ETL Pipelines within Google Cloud Platform tools and Google BigQuery.As we continue to grow, this role offers the unique opportunity to join a team that ensures that raw data is accurately and efficiently collected, related, transformed and visualized, serving as the foundation for our data-driven decision-making processes and revealing insights about our business and product.

HOW YOU WILL MAKE AN IMPACT

• Design and implement automated data extraction solutions from various platforms using REST APIs and GraphQL 
• Ensure efficient and reliable ingestion of raw data into our data warehouse environment according to specifications outlined by warehousing team, including relational data
• Work closely with data sources like Salesforce, Shopify, and other platforms to capture comprehensive data sets in a batch manner
• Collaborate with data architecture and data transformation teams to deliver unnested, normalized data in formats that are immediately useful and accessible for relational databases
• Create robust ETL data pipelines and monitor for performance and accuracy, making adjustments as needed for optimization
• Develop documentation and support continuous improvement in our data integration processes

WHAT SKILLS YOU’LL NEED

• Experience in Data Extraction and Ingestion: Proven efficiency in extracting raw data in batch and real-time from various platforms into a data warehouse using REST APIs, GraphQL, SQL and Python, Postman, and SaaS tools like Stitch data or FiveTran.
• JSON Data Handling Expertise: Proficient with JSON, including nested structures. Skilled in unnesting, flattening, and manipulating complex data.
• Knowledge of Data Warehouse Structures: Understands structuring raw data in data warehouses for BI and data architecture teams, with expertise in relational data modeling.
• Data Transformation Using SQL: Demonstrated skill in complex data transformations and SQL query optimization for ETL processes. Advanced in SQL for data analytics and decision-making.
• Relational Data Modeling Proficiency: Proficient in creating relational data models for scalable database systems. Deep knowledge of normalization, entity-relationship diagrams, and schema design. Experienced with RDBMS to optimize data architecture.
• Proficiency in Data-Related Programming: Strong in programming for data extraction and manipulation, and API integration, particularly Python.
• Proficiency in Cloud Data Services: Experienced with Google Cloud Platform and Google BigQuery and establishing efficient ETL data pipelines.
• Collaborative and Communication Skills: Effective in cross-functional teamwork with strong verbal and written communication skills, essential for technical articulation and collaboration.
• Commitment to Quality and Best Practices: Committed to thoughtful, scalable design with a focus on sustainable, well-structured data solutions.
• Proven Remote Work Capability: Demonstrated effectiveness in remote settings, with strong self-management, time management, and virtual communication skills.
• Problem-Solving and Adaptability: Excels in ambiguous, evolving scenarios with a capacity to learn quickly, develop solutions, and maintain focus on quality outcomes.
• Demonstrated Expertise: At least 3 years of experience in the above areas.

BONUS IF YOU HAVE:

• Experience in handling large volumes of data and understanding of performance optimization
• Experience extracting/ingesting data from e-commerce, subscription, revenue operations or GTM platforms
• Prior experience in a startup environment

Tapcart Perks & Benefits·      401(K) and stock options for all full-time employees·      Affordable, high quality medical insurance coverage·      Dental and vision insurance coverage paid 100% for employees·      Life and disability insurance coverage·      Flexible PTO and Sick Time·      11 paid company holidays·      One-time stipend for outfitting your home office, plus a recurring merchant shopping stipend
Who is Tapcart!?We are growing startup based in Santa Monica, CA 🏖. Our team and culture are very important to us – we aim to make coming to work fun, challenging and rewarding. We know that doing impactful work means showing up with creative solutions for our merchants and our business. We strive to make Tapcart a place where passionate, talented people can grow their skills and careers. 
Read about our Series B fundraise for $50M in June 2021.We raised our Series A for $10M in May 2020.Check out what our customers are saying. Learn more about who we are and what we offer on our Careers page.