Senior Analytics Engineer (Ecommerce /Amazon)
Search Jobs
Search by job, company or skills
Search by job, company or skills
Role Description
We are hiring Senior Analytics Engineer (Data warehouse/BI) to own and scale our analytics infrastructure. This role is responsible for designing and maintaining our data warehouse, developing scalable reporting solutions, and transforming complex data into actionable business insights.
This is a highly technical, hands-on role for someone who enjoys building systems that scale. The ideal candidate is comfortable working directly with business stakeholders to understand their needs, translating business logic into technical solutions, and partnering closely with engineering to build reliable, long-term data infrastructure.
Key Responsibilities
DATA WAREHOUSING & ARCHITECTURE
• Design, build, and maintain a scalable enterprise data warehouse.
• Develop reusable data models and data marts that support recurring business needs.
• Continuously improve warehouse architecture as new business requirements emerge.
• Ensure data quality, consistency, and long-term maintainability across reporting environments.
SQL SERVER DEVELOPMENT
• Write, optimize, and maintain complex SQL queries to support reporting and analytics.
• Develop and maintain production stored procedures and views while ensuring downstream reports and applications remain stable.
• Translate complex business logic into scalable SQL solutions.
• Optimize query performance and identify opportunities to improve efficiency.
AMAZON DATA & ANALYTICS
• Integrate and analyze data from Amazon Seller Central, SP-API, and Amazon Ads API.
• Understand the strengths and limitations of Amazon reporting sources and recommend the appropriate data source for each business need.
• Develop reporting and insights around key ecommerce metrics, including:
◦ Customer Lifetime Value (LTV)
◦ Customer Acquisition Cost (CAC)
◦ Advertising performance
◦ Sales and profitability
◦ Inventory performance
◦ Operational KPIs
METRIC ACCURACY & VALIDATION
• Own the accuracy of business metrics across all reporting environments.
• Define and document metric logic so definitions stay consistent and transparent across teams.
• Reconcile results against Amazon Seller Central, SP-API, Amazon Ads API, and other source systems to confirm they agree.
• Identify and investigate discrepancies between sources, and resolve the root cause rather than the symptom.
• Verify that reported numbers represent business reality, not just technically correct query output.
INSIGHTS & RECOMMENDATIONS
• Explain what is driving the results, not just what the numbers say.
• Surface risks and opportunities in the data proactively, before being asked.
• Propose concrete, evidence-based actions tied to business outcomes.
• Translate findings into recommendations that both technical and non-technical stakeholders can act on.
BUSINESS PARTNERSHIP
• Partner directly with business stakeholders to understand goals, define requirements, and recommend scalable data solutions.
• Challenge requests when a different analytical approach will better solve the underlying business problem.
• Present findings and recommendations in a clear, actionable manner to both technical and non-technical audiences.
• Serve as a trusted partner across leadership, operations, marketing, and engineering.
REPORTING & AUTOMATION
• Build scalable dashboards, reporting solutions, and automated data workflows.
• Replace repetitive ad hoc reporting with reusable reporting frameworks.
• Identify opportunities to automate manual processes and improve data accessibility.
• Maintain clear documentation for reporting logic, warehouse architecture, and data definitions.
CROSS-FUNCTIONAL COLLABORATION
• Work closely with software engineers to support data pipelines and internal applications.
• Participate in technical discussions around architecture, integrations, and system improvements.
• Contribute to projects that improve the organization's overall data capabilities.
Qualifications
• 3+ years of hands-on SQL experience in a production environment.
• Advanced SQL skills, including: Stored Procedures, Views, Indexing, Query Optimization
• Demonstrated ability to translate business logic into SQL solutions rather than simply executing pre-written queries.
• Experience writing and maintaining production stored procedures and views without disrupting downstream consumers.
• Proven experience building a data warehouse from the ground up or significantly evolving an existing warehouse.
• Experience designing and delivering reusable data marts that support recurring business needs.
• Deep understanding of Amazon reporting, including Seller Central reporting, SP-API, Amazon Ads API, and the capabilities and limitations of each.
• Experience turning Amazon data into meaningful business insights, including Customer Lifetime Value (LTV), Customer Acquisition Cost (CAC), advertising performance, profitability, and operational reporting.
• Demonstrated ownership of metric accuracy: defining metric logic, documenting definitions, and reconciling results across multiple source systems to confirm they reflect business reality.
• Track record of turning analysis into action: explaining what drives results, flagging risks and opportunities, and recommending concrete next steps rather than only delivering data.
• Experience working directly with stakeholders to scope business requirements, ask thoughtful questions, and recommend scalable solutions rather than simply taking requests at face value.
• Strong analytical thinking, problem-solving, and communication skills.
What we offer
Interview Process: 2-3 online interviews (MS Teams)
Job ID: 152370313
