Data Extraction/Integration Engineer

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