Senior Analytics Engineer – ETL/ELT
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
Analytics Engineer designing and building data infrastructure for a prominent online design marketplace. Collaborating with vendors to implement marketing mix modeling and data ingestion processes.
Responsibilities:
- Participate in vendor scoping sessions to finalize full table and field requirements before the build phase begins.
- Model a dedicated datamart in the dbt transformations marts layer, sourcing data from core order, line item, and customer tables.
- Translate vendor schema specifications into specific internal field mappings, accurately accounting for DTC-adjusted logic such as ship-to addresses, order dates, and customer grain.
- Configure Snowflake data sharing and connections to facilitate seamless vendor ingestion.
- Write comprehensive dbt tests and documentation for all delivered models to ensure long-term data quality and transparency.
- Manage the full merge request workflow using GitLab, adhering to strict peer review processes before deployment.
Requirements:
- Proven ability to execute complex technical requirements independently with minimal guidance.
- Strong proficiency in SQL, with deep experience analyzing source tables across orders, customers, and attribution models.
- Expert-level experience with dbt Core and dbt Cloud, including building mart models and writing MetricFlow-compatible YAML configurations.
- Proficient with Snowflake, specifically regarding schema design, query testing, and data sharing setup.
- Demonstrated background in Analytics Engineering, with an emphasis on translating external vendor schemas to internal DTC data models.
- Experience with GitLab for branch management and merge request workflows.
- Prior experience with marketing mix modeling (MMM) or incrementality vendor integrations is a major plus.
- Familiarity with Airflow for pipeline orchestration context is preferred.
Benefits:
- 100% Remote Work: Enjoy the freedom to work from the location that helps you thrive. All it takes is a laptop and a reliable internet connection.
- Highly Competitive USD Pay: Earn an excellent, market-leading compensation in USD, that goes beyond typical market offerings.
- Paid Time Off: We value your well-being. Our paid time off policies ensure you have the chance to unwind and recharge when needed.
- Work with Autonomy: Enjoy the freedom to manage your time as long as the work gets done. Focus on results, not the clock.
- Work with Top American Companies: Grow your expertise working on innovative, high-impact projects with Industry-Leading U.S. Companies.
Similar Jobs
Senior Analytics Engineer – ETL/ELT Focused
Analytics Engineer designing and building critical data infrastructure for a prominent online design marketplace. Collaborating on marketing mix modeling and vendor integration projects.
Senior Analytics Engineer – ETL/ELT Focused, Design Marketplace
Analytics Engineer designing and building data infrastructure for marketing mix modeling at a leading design marketplace. Working remotely to support independent artists and global consumer market needs.
Senior Analytics Engineer – ETL/ELT focused
Independent contract Analytics Engineer designing critical data infrastructure for marketing mix modeling at a prominent online design marketplace in Colombia.
Senior Analytics Engineer – ETL/ELT Focused
Analytics Engineer for a design marketplace focusing on ETL/ELT processes to build data infrastructure. Looking for independent candidates to onboard a marketing mix modeling vendor.
Business Analytics Engineer
Business Analytics Engineer at Otis responsible for data analysis and dashboard development for sales and field operations. Engaging with AI tools and ensuring data accuracy across sources.
IT Advanced Analytics Developer
IT Advanced Analytics Developer creating reports and dashboards for healthcare stakeholders. Developing datasets and analyzing trends in healthcare programs and interventions with a focus on data stewardship practices.
Senior Analytics Engineer
Senior Analytics Engineer owning and evolving the analytics layer for Keedian's platform. Transforming operational and business data into valuable insights, collaborating with cross-functional teams.
Senior Analytics Engineer
Senior Analytics Engineer developing data-driven solutions for aerospace and defense industries. Collaborating with engineering teams to optimize services and performance across products.
Senior Software Engineer II, Ads Data Solutions Engineering
Senior Engineer II co-owning the technical roadmap for data solutions at Instacart. Building scalable data-intensive systems and mentoring engineers.
Senior Data Analytics Engineer – Hospitality Tech
Data Engineer designing scalable reporting data architecture for a hospitality tech client. Involves extensive experience with BigQuery, SQL, and data warehousing.
Senior Analytics Engineer
Senior Analytics Engineer developing user-facing data products at Bamboo Health. Collaborating with stakeholders and managing data reporting solutions to improve healthcare delivery.
Software Engineer, Analytics
Software & Analytics Engineer designing and developing analytical applications to enable advanced decision-making. Join MetroSys to work on scalable and secure software solutions transforming complex data into actionable intelligence.
Senior Analytics Engineer
Senior Analytics Engineer responsible for delivering trusted metrics and analytics solutions at CDW. Collaborating with teams to transform data into actionable insights.
Senior Analytics Engineer – ProdOps
Analytics Engineer transforming data into scalable products for Blip Global. Collaborating across teams to create actionable insights from diverse data sources and automate analytics processes.
Senior Data Analytics Engineer
Senior Data Analytics Engineer solving complex data problems across business functions at Dotmatics. Leveraging advanced analytics for decision-making in a collaborative remote environment.
BI Reporting and Analytics Developer/Analyst – Custody
Consultant providing end-to-end delivery of reporting and analytics solutions. Focus on Ambulatory, Inpatient, and related metrics in the Epic Cogito Clarity Custody Health space.
Senior Analytics Engineer
Analytics Engineer at Shippo, driving data strategy and insights for e-commerce logistics. Collaborating across teams to influence business metrics and develop scalable data solutions.
Software Engineer, Analytics
Software & Analytics Engineer developing Python-based applications for data analytics. Collaborating with stakeholders to create user-friendly, data-driven solutions for decision-making.
Senior Analytics Engineer, Product
Senior Analytics Engineer managing data movement for product squads and partners. Ensure self-service analytics at scale and enhance the user experience at Inato.
Corporate Analytics Developer
Corporate Analytics Developer creating interactive reports and dashboards with Power BI for data insights. Collaborating with engineering and analytics teams to optimize data reporting solutions.