Analytics Engineer, Commercial Systems

Posted 3 days ago

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

📋 Description

• Construct and uphold analytical data models that support commercial and revenue operations.

• Integrate information from CRM systems, merchant accounts, contracts, usage records, and billing platforms.

• Create dependable datasets for sales, customer success, pricing, and revenue reporting.

• Design reusable data models that promote consistent commercial metrics.

• Convert raw business data into structured analytical datasets.

• Develop and sustain SQL-based data transformations.

• Collaborate with Data Engineering and Engineering teams to enhance commercial data pipelines.

• Establish consistent identifiers for merchants and accounts across business systems.

• Create data models that link commercial agreements with usage and billing records.

• Facilitate accurate reporting of merchant activity, revenue, and pricing performance.

• Develop data quality checks and automated validation processes.

• Investigate discrepancies between commercial and financial datasets.

• Enhance the reliability of reporting for Finance and Revenue Operations.

• Translate reporting needs into reusable datasets.

• Develop standardized definitions for commercial and revenue metrics.

• Maintain documentation for data models, transformation logic, and metric calculations.

• Support dashboards with precise, well-structured data.

• Enhance analytical query performance and maintainability.

• Reduce reliance on manual spreadsheet-based reporting through automation.

• Establish recurring data preparation and reconciliation processes.

• Collaborate with Billing Operations on contract-to-invoice validation.

• Aid in the analysis of merchant consumption, transaction activity, and pricing arrangements.

• Construct datasets to identify revenue leakage or billing inconsistencies.

• Support merchant retention and expansion reporting with Customer Success.

• Improve pipeline and account performance data with Sales Operations.

• Assist Finance in revenue analysis and forecasting.

• Establish testing and monitoring practices for commercial data transformations.

• Investigate unexpected reporting changes and trace issues back to the underlying data.

• Integrate new commercial data sources as the company expands.

• Enhance the structure, organization, accuracy, usability, and maintainability of analytical datasets.

• Validate analytical outputs against business definitions.

• Support access controls and the appropriate handling of sensitive commercial information.

• Participate in data architecture and analytical tooling reviews.

• Establish reliable dependencies between commercial systems and reporting tools.

• Support a scalable reporting infrastructure for increasing merchant activity.


⛳️ Requirements

• 3+ years of experience in Analytics Engineering, Data Engineering, Business Intelligence Engineering, or a related technical analytics position.

• Proficient SQL skills, including complex joins, aggregations, transformations, and query optimization.

• Experience in developing and maintaining reusable analytical data models.

• Familiarity with cloud data warehouses or similar analytical databases.

• Strong grasp of data modeling principles and relational data structures.

• Experience in building and maintaining ELT or ETL workflows.

• Ability to connect and transform data from various business systems.

• Proven experience in developing automated data quality checks and validation processes.

• Familiarity with version control and collaborative development workflows.

• Experience documenting data models, transformation logic, and business metric definitions.

• Strong understanding of data reliability, consistency, and maintainability.

• Experience in investigating discrepancies across datasets and identifying root causes.

• Ability to translate business reporting requirements into technical data solutions.

• Experience supporting dashboards, reporting platforms, or business intelligence tools.

• Strong analytical and technical problem-solving abilities.

• Capability to work with large datasets and enhance query performance.

• Experience collaborating with analysts, engineers, and business stakeholders.

• Strong attention to detail when handling financial or commercial data.

• Ability to clearly explain technical data concepts to non-technical teams.

• Excellent written and verbal communication skills.

• Comfortable working independently and taking ownership of data modeling projects.

• Ability to manage multiple technical priorities and deliver maintainable solutions.

• Availability to collaborate during U.S. Eastern Time business hours.

• Nice to have: Experience in building analytics infrastructure for SaaS or B2B technology companies.

• Nice to have: Experience using dbt for data transformations, testing, and documentation.

• Nice to have: Familiarity with Snowflake, BigQuery, Redshift, or comparable data warehouses.

• Nice to have: Experience with Python for data processing or automation.

• Nice to have: Experience working with Salesforce, HubSpot, or similar CRM data.

• Nice to have: Familiarity with Stripe or other billing and payment platforms.

• Nice to have: Experience modeling usage-based, subscription, or transaction-based revenue.

• Nice to have: Experience connecting contract terms, merchant usage, and invoice data.

• Nice to have: Familiarity with merchant or e-commerce platform business models.

• Nice to have: Experience with Looker, Tableau, Power BI, or similar business intelligence platforms.

• Nice to have: Experience developing automated revenue reconciliation datasets.

• Nice to have: Familiarity with data orchestration tools and scheduled transformation workflows.

• Nice to have: Experience implementing data tests, monitoring, and alerting.

• Nice to have: Experience with Git-based code review and CI/CD processes.

• Nice to have: Familiarity with data governance and access management.

• Nice to have: Experience supporting Finance, Revenue Operations, or GTM analytics teams.

• Nice to have: Familiarity with telehealth or healthcare technology.

• Nice to have: Experience enhancing analytics infrastructure in a growing technology company.


🏝️ Benefits

• Competitive salary and performance-based bonuses.

• Comprehensive health, dental, and vision insurance.

• Flexible work hours and remote work options.

• Professional development opportunities and training.

• A collaborative and inclusive work environment.

People also viewed

Nagarro2 days ago

Senior Engineer – Data Analyst

MX flagMexico OnlyFull-timeAnalytics Engineer
ApplyView job
RTX2 days ago

Senior Principal, Integrated Product Analytics Engineer

US flagUnited States OnlyFull-timeAnalytics Engineer$132.4k – $251.6k/year
ApplyView job
Product Hackers2 days ago

Growth Analytics Engineer

ES flagSpain OnlyFull-timeAnalytics Engineer€28k – €36k/year
ApplyView job
StackAdapt2 days ago

Senior Software Engineer, Data Solutions

CA flagCanada, +1 more countryFull-timeAnalytics EngineerC$170.4k – C$234.3k/year
ApplyView job
Mercury Insurance3 days ago

Lead Data Analytics Engineer

US flagCalifornia OnlyFull-timeAnalytics Engineer$139.7k – $218.3k/year
ApplyView job
LawnStarter3 days ago

Analytics Engineering Manager, Data Platform – Governance

BR flagBrazil OnlyFull-timeAnalytics Engineer$75k – $120k/year
ApplyView job

Never miss a great job!

Get handpicked remote jobs straight to your inbox weekly.

Trusted by 7,400+ designers