Enterprise Data Warehouse Data Engineer
Remote in AL, AZ, CA, CO, FL, GA, IL, MA, MI, NV, NJ, NY, NC, OH, OR, TN, TX, UT, VA, WA
Tapcart
Tap into the platform connecting Shopify Plus with iOS and Android mobile apps. Leading DTC brands have seen $6.6B+ in m-commerce sales through Tapcart mobile apps.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
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.
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: APIs Architecture BigQuery Data Analytics Data pipelines Data warehouse E-commerce ETL FiveTran GCP Google Cloud GraphQL JSON Pipelines Python RDBMS Salesforce SQL
Perks/benefits: Equity Flex hours Flex vacation Health care Home office stipend Insurance Startup environment
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Data Science Manager jobs
- Open Lead Data Analyst jobs
- Open Marketing Data Analyst jobs
- Open Senior Business Intelligence Analyst jobs
- Open Data Engineer II jobs
- Open Principal Data Engineer jobs
- Open MLOps Engineer jobs
- Open Power BI Developer jobs
- Open Data Scientist II jobs
- Open Business Intelligence Developer jobs
- Open Data Analytics Engineer jobs
- Open Business Data Analyst jobs
- Open Sr Data Engineer jobs
- Open Junior Data Scientist jobs
- Open Data Analyst Intern jobs
- Open Product Data Analyst jobs
- Open Sr. Data Scientist jobs
- Open Senior Data Architect jobs
- Open Research Scientist jobs
- Open Big Data Engineer jobs
- Open Azure Data Engineer jobs
- Open Manager, Data Engineering jobs
- Open Principal Data Scientist jobs
- Open Data Quality Analyst jobs
- Open Data Product Manager jobs
- Open Data quality-related jobs
- Open GCP-related jobs
- Open Java-related jobs
- Open Business Intelligence-related jobs
- Open ML models-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open PhD-related jobs
- Open Deep Learning-related jobs
- Open Finance-related jobs
- Open Data visualization-related jobs
- Open PyTorch-related jobs
- Open TensorFlow-related jobs
- Open APIs-related jobs
- Open NLP-related jobs
- Open Consulting-related jobs
- Open LLMs-related jobs
- Open CI/CD-related jobs
- Open Snowflake-related jobs
- Open Generative AI-related jobs
- Open Kubernetes-related jobs
- Open Hadoop-related jobs
- Open Data governance-related jobs
- Open Airflow-related jobs
- Open Databricks-related jobs