Job Closed

This listing is no longer active.

Avetta

Avetta is an information technology (IT) consulting and services company that specializes in providing supply chain risk management and compliance solutions. As

Analytics Engineer

Location

United States

Posted

69 days ago

Salary

$74K - $143K / year

Seniority

Mid Level

Job Description

Analytics Engineer

Avetta

Role Description The Analytics Engineer (Finance) within Avetta’s Financial Planning & Analysis (FP&A) team will serve as a critical partner in driving insights that influence executive decisions and operational efficiency. This role will collaborate across Finance, Billing, Sales Operations, Business Intelligence, and Leadership teams to gather valuable insights and data, and optimize complex revenue analytics and planning processes to improve the accuracy and quality of the revenue forecast and reporting. - Raise the Company’s FP&A Cash Billings analytics & reporting function by optimizing: - Trace and join invoicing and customer-activity events end-to-end using clear, testable logic. - Design and build out an analytically-derived “Connection Subscription Ledger”: a detailed, time-aware log of monetized (billable) client–supplier connections, morphing into a handoff-ready dataset that Corporate BI productionizes in Snowflake. - Build analytics-ready warehouse models (SQL + modeling): - Write high-performance SQL to create curated tables/views that support: - Cohort creation and retention (by activation/event timing). - Expansion/contraction and product mix shifts. - Renewal behavior and customer lifecycle segmentation. - Price lift measurement and attribution. - Churn classification and event-driven “bridge” logic. - Establish foundational tables with carefully chosen and clearly defined data grain, durable surrogate/primary keys, and consistent dimensional attributes. - Bring data modeling rigor into Finance reporting: - Translate finance requirements into data logic: partner with the Business Analyst to define rules, acceptance criteria, and edge-case handling. - Run tight iteration loops: prototype → validation protocols → refine → document → finalize. - Provide “definition control” so recurring reporting stays consistent month-over-month. - Foster a wholistic understanding of the business (including underlying drivers and relationship/impact) within and across the entire FP&A team, leading to improved processes, collaboration, insight generation and optimal business outcomes. - Develop and monitor business performance indicators, highlighting trends, opportunities for improvement, causes of unexpected variance, and partner with finance and business partners to optimize downstream actions. Qualifications - Bachelor’s Degree in relevant field; additional education/certification is a plus. - 2–5 years of experience in data engineering / analytics engineering / advanced analytics roles in Snowflake or other modern cloud data warehouse. - Strong SQL (complex joins, window functions, incremental logic, recursive query development, performance tuning), with proven ability to model data for analytics (facts/dimensions, grain, keys, cohort logic). - 1 year of experience supporting dbt-style modular SQL, testing, and documentation. - Proficiency in AI-based tech stack solutions, agent design or company-specific LLM tooling. Requirements - Understanding of business, the why (not just the what), and numbers. - Accuracy of analysis and inputs that slide into strategic decisions. - Turnaround time, flexibility to adjust to changing environment / business needs, and leveraging of systems. - Consistent delivery with an ownership mentality. - Customer delight with supporting active engagement with cross-functional leaders. Benefits - Salary range: $74,000 - $143,000 USD per year, with a potential bonus. - Comprehensive benefits package, which includes health, dental and vision insurance, 401(k), and PTO. Company Description Avetta’s SaaS platform connects the world’s leading organizations with qualified suppliers, contractors, and vendors. We bring unmatched visibility to companies through cloud-based technology and human insights to improve supply chain risk and compliance. As a result, we foster sustainable growth for businesses and their supply chains globally. Our SaaS subscription-based software is used by 85k+ active customers in over 100 countries spanning across a wide range of industries.

Job Requirements

  • Bachelor’s Degree in relevant field; additional education/certification is a plus.
  • 2–5 years of experience in data engineering / analytics engineering / advanced analytics roles in Snowflake or other modern cloud data warehouse.
  • Strong SQL (complex joins, window functions, incremental logic, recursive query development, performance tuning), with proven ability to model data for analytics (facts/dimensions, grain, keys, cohort logic).
  • 1 year of experience supporting dbt-style modular SQL, testing, and documentation.
  • Proficiency in AI-based tech stack solutions, agent design or company-specific LLM tooling.
  • Understanding of business, the why (not just the what), and numbers.
  • Accuracy of analysis and inputs that slide into strategic decisions.
  • Turnaround time, flexibility to adjust to changing environment / business needs, and leveraging of systems.
  • Consistent delivery with an ownership mentality.
  • Customer delight with supporting active engagement with cross-functional leaders.

Benefits

  • Salary range: $74,000 - $143,000 USD per year, with a potential bonus.
  • Comprehensive benefits package, which includes health, dental and vision insurance, 401(k), and PTO.

Related Categories

Related Job Pages

More Analytics Engineer Jobs

AILO logo

Data and Analytics Engineer

AILO

Championing the international Life insurance sector by embracing its challenges for the benefit of all

Full TimeRemoteTeam 1-10Since 1987H1B No Sponsor

• Integrate our data stack with our mobile and web products • Support internal teams and external customers with data-driven insights and analysis • Build reports and dashboards • Elevate our customer experience by developing AI-powered reporting and insights • Shape a new foundational capability, driving the future of data-driven decision-making for Ailo and our customers.

Australia

SQL/ETL Developer

FULLTHROTTLE

We are an eVerify employer.

Role Description Join Fullthrottle.ai, a cutting-edge Marketing Technology SaaS company, where our global software team operates seamlessly across 5 time zones and 6 countries, working collaboratively in a location-independent environment. We are currently seeking a dynamic and self-directed, mid-level Data Engineer (ETL/SQL) with a minimum of 3 years of ETL development experience to contribute to our innovative projects. The ideal candidate should possess strong communication skills, a solution-oriented mindset, and the ability to excel in a fast-paced Continuous Development Agile Environment. Responsibilities - ETL Responsibilities (80% of role) - Manage ETL process, translate complex business requirements into scalable and efficient data solutions. - Investigate and troubleshoot data and user-related system errors to ensure data integrity. - Implement ETL processes to extract, transform, and load data from multiple sources into a data warehouse. - AI Data Preparation / Insights (20% of role) - AI Data Wrangling and Preparation - Cleaning, transform, and prepare large and complex datasets. - Handling missing values, outliers, inconsistencies, and data quality issues. - Data scaling, normalization, encoding, and feature engineering techniques. - AI Data Planning to achieve FT’s AI Strategy - Applying ML models to our prepared Data to gain insight. - Augmenting Models with our data to enable achievement of AI strategies. - Designing, training, evaluating, and deploying ML models, integrating AI solutions into applications, and working with large datasets. Qualifications - Strong proficiency in Python, familiarity with libraries like Pandas, NumPy, Scikit-learn, TensorFlow, Keras, PyTorch. - Excellent skills in writing and optimizing complex SQL queries for data extraction, manipulation, and analysis from relational databases. - Experience with R is a plus, though not a requirement. - Hands-on experience with various AWS Database & ETL services, particularly: S3, Python code, Lambda, Cloud Formation, and other AWS serverless resources. - Active participation in Agile teams, collaborating with team members to review user stories, estimate effort, and contribute to sprint reviews. - Solid understanding of various ML algorithms (supervised, unsupervised, reinforcement learning). - Experience in training, evaluating, and deploying ML models is a plus. - Knowledge of model selection, hyperparameter tuning, and cross-validation techniques. - Familiarity with ML frameworks and libraries mentioned above. - 2+ years of experience in a similar ETL role is essential. Exposure to AI ML models and AI data solutions delivery is a major plus. - Remote Team Experience: 1+ years of experience working in a distributed remote technology team is a plus. Personal Profile - Self-directed and self-motivated with a proven ability to deliver results. - Strong communicators, capable of summarizing key deliverables and meeting daily deadlines. - Experienced in a fast-paced Agile/Scrum development environment. - Comfortable working in a distributed development environment with remote colleagues. - Proven team players. Remote Minimum Requirements - Reliable high-speed internet connection. - Fluent written/spoken English. - Located within +/- 6 hours of US Eastern Standard Time.

UTC-5 to UTC-3
Top Doctors logo

Analytics Engineer

Top Doctors

Top Doctors: Leading the digital healthcare revolution

Full TimeRemoteTeam 201-500H1B No Sponsor

• Diseñar y mantener modelos de datos analíticos en DBT, asegurando la trazabilidad, eficiencia y calidad de los datasets. • Construir y optimizar consultas SQL avanzadas en BigQuery, incluyendo la creación de tablas, vistas, rutinas y queries programadas (scheduled queries). • Definir, estandarizar y documentar métricas y KPIs para garantizar su consistencia en toda la organización. • Colaborar con los equipos de negocio para entender necesidades analíticas y traducirlas en modelos de datos escalables y reutilizables. • Desarrollar y mantener dashboards y visualizaciones en Metabase y Tableau, asegurando su alineación con los modelos analíticos. • Implementar procesos de testing y validación de datos (data quality) dentro de DBT. • Contribuir a la mejora continua de la arquitectura de datos junto al Senior Data Engineer. • Participar en la definición de buenas prácticas de versionado, testing y documentación en Git.

Spain
i6 Group logo

Analytics Engineer

i6 Group

Industry-leading fuel management technology for smarter and greener operations.

Full TimeRemoteTeam 51-200H1B No Sponsor

• Own the Transformation Layer: Design, build, and maintain complex dbt models to power internal BI and external customer analytics • Pipeline Management: Manage and monitor data ingestion pipelines to ensure high availability and low latency • Performance Tuning: Optimise cloud data warehouse costs and query performance (clustering, partitioning) for sub-second response times • Data Quality & Testing: Build and maintain automated testing frameworks (dbt test, Great Expectations) to proactively catch data issues • DataOps: Maintain CI/CD pipelines (GitHub Actions) for data deployment, applying software engineering principles to data workflows • Collaboration: Partner with Data Analysts to provide clean models and work with the Data Engineering Lead on architectural infrastructure decisions • Technical Documentation: Document data models, macros, and transformation logic clearly to ensure team scalability

United States