Data Engineer for API Pipelines

DATA ANALYTICS ENGINEER TwoTen · Data & Engineering ABOUT US TwoTen Strategy is a boutique consulting firm that helps retailers, restaurants, consumer brands, and real estate owners make smarter growth and location decisions through data. We combine first-party customer data, mobile location data, GIS, and advanced analytics to answer high-impact business questions for leading national brands. We work with highly confidential client and consumer datasets. Trust, discretion, and rigorous data stewardship are fundamental to every project. THE ROLE We're looking for an Analytics Engineer to own the technical infrastructure behind our client engagements. You'll connect client data sources, APIs, cloud platforms, and third-party datasets into reliable, automated data pipelines that power Tableau dashboards and client deliverables. This is a fully-remote, hands-on role for someone who enjoys building systems, solving problems, and creating scalable solutions. Your success will be measured by the reliability, accuracy, and efficiency of the data ecosystem you build. WHAT YOU'LL DO Own the end-to-end data pipeline supporting client analytics—from data ingestion through Tableau delivery. Build and maintain secure integrations with APIs, client databases, cloud storage, spreadsheets, and third-party platforms. Develop automated Python and SQL workflows to clean, validate, transform, and load data into BigQuery. Design and maintain scalable data models that support high-performing Tableau dashboards. Monitor, troubleshoot, and continuously improve production data pipelines and dashboard refreshes. Implement rigorous QA processes and data validation to ensure accurate, reliable client deliverables. Automate recurring reporting and eliminate manual processes wherever possible. Partner with consultants to translate complex business questions into clear, actionable analytical solutions. Communicate technical insights and data nuances to non-technical client stakeholders during project deliverables. Handle confidential client and consumer data with the highest standards of privacy, security, and governance. WHAT WE'RE LOOKING FOR 3–6 years of experience in analytics engineering, business intelligence, data analytics, consulting, or a related field. Strong SQL and Python skills (pandas, APIs, automation). Experience building and maintaining automated data pipelines. Experience working with cloud data warehouses (BigQuery preferred). Experience building and maintaining Tableau data sources and dashboards. Comfortable connecting and integrating data from APIs, cloud storage, spreadsheets, databases, and external client systems. Experience working in Google Workspace (Sheets, Drive, Docs) and collaborative notebook environments such as Google Colab or Jupyter. Strong understanding of data quality, validation, and troubleshooting. Experience handling confidential or sensitive data with sound data governance and security practices. Excellent organization, attention to detail, and ability to manage multiple client engagements simultaneously. Stable, high-speed internet - and a professional remote work setup. NICE TO HAVE Geospatial analytics (GeoPandas, Shapely, PostGIS, QGIS, ArcGIS, etc.) Retail, restaurant, consumer, or commercial real estate analytics Machine learning or predictive modeling experience Experience working with location intelligence or mobility datasets Git/GitHub and modern development workflows OUR TECHNOLOGY STACK Python · SQL & BigQuery · Tableau · REST APIs · Google Workspace · Google Colab & Jupyter · GIS & Spatial Data · Git/GitHub WHAT SUCCESS LOOKS LIKE Client data sources are integrated quickly and securely. Data pipelines run reliably with minimal manual intervention. Tableau dashboards refresh accurately and perform efficiently. Data quality issues are identified and resolved before they impact clients. Repetitive work is automated, allowing consultants to focus on insights and strategy. Clients trust the accuracy, consistency, and reliability of every deliverable. COMPENSATION $25-35 per hour, depending on experience Performance Based Bonus up to 20% WHY TWOTEN? You'll work on a wide variety of high-impact projects across retail, restaurants, real estate, and consumer brands, helping clients solve complex business problems using modern analytics. As a member of a small, entrepreneurial team, you'll have significant ownership, direct exposure to clients, and the opportunity to shape the technical foundation of a growing consulting firm.