
Analytics Engineer, Commercial Systems
Posted 3 days ago

Posted 3 days ago
This is a fully remote position, open to applicants in United States.
• 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.
• 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.
• 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.
Nagarro
RTX
Product Hackers
StackAdapt
Get handpicked remote jobs straight to your inbox weekly.