Analytics Engineer

This is a fully remote position, open to applicants in United States.

📋 Description

• Create clean, efficient, and maintainable SQL to convert raw business data into reliable datasets suitable for analytics.

• Design and uphold staging, intermediate, dimensional, fact, and reporting-layer data models.

• Convert business requirements and established architecture into production-ready data models.

• Implement dimensional modeling principles, encompassing grain, relationships, and dependencies.

• Refactor and enhance SQL and data models as business needs change.

• Improve data models for self-service and AI-driven analytics by refining metadata, descriptions, and semantic context.

• Develop and maintain data-quality tests and comprehensive documentation.

• Utilize Git and GitHub to oversee analytics code through branches, commits, pull requests, code reviews, and deployment workflows.

• Create and test modifications prior to production deployment.

• Assess upstream and downstream dependencies before altering models.

• Investigate data quality issues and discrepancies between reporting and source systems.

• Trace data through source, transformation, and reporting layers to uncover root causes.

• Resolve failed transformations and scheduled analytics jobs.

• Validate changes and devise sustainable solutions.

• Support data and semantic models for business intelligence and self-service analytics.

• Collaborate with business stakeholders to grasp reporting needs and determine suitable data structures.

• Aid in maintaining consistent definitions and calculations for essential business metrics.

• Develop an understanding of business processes across E-Commerce, Wholesale, Merchandising, Marketing, Supply Chain, Operations, and Finance.

⛳️ Requirements

• Proficient SQL skills, including joins, CTEs, aggregations, window functions, conditional logic, and multi-step transformations.

• Around 2-4 years of pertinent experience in analytics engineering, data analytics, business intelligence, data engineering, or a related discipline.

• Strong grasp of relational data and data modeling concepts.

• Experience in converting operational data into structured datasets suitable for analytics and reporting.

• Hands-on experience using Git for version control and collaborative development.

• Familiarity with a SQL-based cloud data warehouse or relational database.

• Excellent analytical and troubleshooting abilities.

• High attention to detail and a commitment to data accuracy.

• A keen interest in how business processes generate and influence data.

• Capability to quickly learn new technologies and business domains.

• This position is remote, available to candidates located anywhere in the United States and authorized to work in the U.S.

• A Bachelor's degree in Analytics, Data Science, Computer Science, Information Systems, Mathematics, or a related quantitative field is preferred, or equivalent relevant professional experience.

• Helpful but not mandatory: knowledge of dbt or similar SQL-based data transformation frameworks; experience with Snowflake, BigQuery, Redshift, Databricks, or another modern cloud data platform; familiarity with Power BI, Sigma, Tableau, Looker, or another BI platform; understanding of Fivetran or another ELT/data integration platform; knowledge of Python, APIs, SFTP/file-based integrations, or semi-structured data; experience with retail, e-commerce, wholesale, inventory, supply chain, or financial data; familiarity with platforms like NetSuite, Shopify, Amazon, Klaviyo, or similar business systems.

🏝️ Benefits

• Excellent company contribution towards employee premiums for Medical, Dental, and Vision Insurance.

• Paid Time Off (PTO).

• 10 paid Company Holidays.

• Company-paid Life Insurance.

• Company laptop provided.

• Monthly product allowance at no cost.

• Employee discounts available.