Analytics Engineer

Posted 15 Days Ago
Be an Early Applicant
Hyderabad, Telangana, IND
In-Office
Junior
Artificial Intelligence • Big Data • Machine Learning • Software
The Role
Build and maintain SQL-based transformation models, dimensional data models, analytical datasets, and data quality checks. Integrate data from transactional systems, APIs, and loyalty platforms; define standardized business metrics; troubleshoot discrepancies; optimize queries and pipelines; and support reporting and dashboards. Collaborate with Data Engineering, BI, Product, and Client teams while maintaining documentation, testing, dependencies, and version-control best practices.
Summary Generated by Built In

About LJI
Loyalty Juggernaut (LJI) is a leading B2B SaaS company redefining how enterprises drivecustomer engagement and loyalty. Our flagship platform, GRAVTY®, enables globalbrands to turn loyalty programs into measurable, revenue-generating growth engines.
Built as an AI-first, next-generation solution, GRAVTY® helps organizations deliverpersonalized, real-time experiences at scale, increasing customer lifetime value anddeepening brand relationships. Headquartered in Palo Alto, California, LJI partners withenterprises across 16 major industries, including airlines, retail, hospitality, financialservices and telecommunications.

Our Global Impact:

  • 400+ Million members connected through our platform.
  • 100+ Global Brands trust us to drive loyalty and brand devotion.
  • 3-Time Winner of “Best Technology Innovation in Loyalty”.
  • Global recognitions for Excellence in Loyalty Management under numerous categories.
  • Recognized as a ‘Strong performer’ in The Forrester Wave™ Loyalty Platforms, Q4 2025.

Explore more about us at www.lji.io.

About the Role

We are seeking a skilled and detail-oriented Analytics Engineer with 1–3 years of experience to join our growing Analytics team.

The ideal candidate will bridge the gap between data engineering and business intelligence by transforming raw data into clean, reliable, well-structured, and reusable analytical datasets. The candidate will be responsible for developing data transformation pipelines, building data models, implementing data quality checks, and optimizing datasets for reporting and analytics.

This role requires strong SQL skills, experience with data transformation frameworks, an understanding of data warehousing concepts, and the ability to collaborate with Data Engineering, Business Intelligence, Product, and Client teams to deliver trusted data solutions for enterprise loyalty programs.

What You'll Do

  • Build and maintain SQL-based data transformation models to convert raw data into clean, analytics-ready datasets.
  • Develop, test, and optimize data models using SQL, dbt, or similar transformation frameworks.
  • Design dimensional data models, including fact tables, dimension tables, and analytical data marts.
  • Integrate data from multiple sources, including transactional databases, loyalty platforms, APIs, and external systems.
  • Translate business requirements into reusable datasets, standardized metrics, and analytical models.
  • Define and maintain key business metrics related to loyalty performance, customer engagement, points accumulation, reward redemption, and retention.
  • Implement data quality checks, validation rules, and reconciliation processes to ensure data accuracy.
  • Troubleshoot data discrepancies, monitor pipeline execution, and optimize queries and transformation workflows.
  • Collaborate with BI, Data Engineering, Product, and other teams to support dashboards, reporting, and business analytics.
  • Maintain data documentation, model dependencies, and transformation logic while following coding, testing, and version control best practices.

What We're Looking For

  • Bachelor's degree in Computer Science, Engineering, IT, Statistics, Mathematics, or a related field.
  • 1–3 years of experience in Analytics Engineering, Data Engineering, BI Development, or a similar role.
  • Strong SQL skills, including complex joins, CTEs, window functions, aggregations, and query optimization.
  • Hands-on experience in data transformation, data modelling, and building analytics-ready datasets.
  • Understanding of data warehousing, dimensional modelling, star schemas, fact tables, and dimension tables.
  • Familiarity with dbt, SQL-based ETL/ELT frameworks, and data pipeline concepts.
  • Experience with relational databases, data validation, testing, and version control tools such as Git.
  • Strong analytical, problem-solving, and debugging skills.
  • Ability to translate business requirements into scalable data solutions and collaborate with cross-functional teams.

Good to Have

  • Experience with Snowflake, Google BigQuery, Amazon Redshift, or Databricks.
  • Hands-on experience with dbt models, tests, macros, and documentation.
  • Basic to intermediate Python skills for data processing and automation.
  • Familiarity with Apache Airflow, Dagster, or similar orchestration tools.
  • Exposure to cloud data warehouses, data lakehouse architectures, and CI/CD practices.
  • Experience working with large-scale customer, transactional, or event-driven datasets.
  • Familiarity with CRM, CDP, enterprise SaaS, or customer loyalty platforms.
  • Understanding of loyalty concepts such as reward points, customer tiers, redemption, and customer engagement.

Key Competencies

  • SQL & Query Optimization
  • Analytics Engineering & Data Transformation
  • Data Modelling & Warehousing
  • dbt & ELT Development
  • Data Quality & Automated Testing
  • Cloud Data Platforms
  • Data Integration & Pipeline Development
  • Documentation & Version Control
  • Analytical Problem Solving
  • Cross-Functional Collaboration

Key Performance Indicators (KPIs)

  • Accuracy and reliability of analytical datasets.
  • Quality and performance of data models and SQL queries.
  • Reduction in data discrepancies and reporting inconsistencies.
  • Timely availability of data for reporting and analytics.
  • Effectiveness of automated testing and data quality checks.
  • Reduction in manual data preparation efforts.
  • Adherence to documentation and coding standards.

Why Join Loyalty Juggernaut?

  • Work with enterprise-scale loyalty platforms and complex customer datasets.
  • Contribute to data solutions that help global brands improve customer engagement, retention, and loyalty performance.
  • Gain hands-on experience with modern analytics engineering practices and cloud technologies.
  • Collaborate with experienced professionals across Data Engineering, BI, Product, and Client teams.
  • Build expertise in scalable data modelling, transformation, and analytics infrastructure.

Skills Required

  • Bachelor's degree in Computer Science, Engineering, IT, Statistics, Mathematics, or a related field
  • 1-3 years of experience in Analytics Engineering, Data Engineering, BI Development, or a similar role
  • Strong SQL skills, including complex joins, CTEs, window functions, aggregations, and query optimization
  • Hands-on experience in data transformation, data modeling, and building analytics-ready datasets
  • Understanding of data warehousing, dimensional modeling, star schemas, fact tables, and dimension tables
  • Familiarity with dbt, SQL-based ETL/ELT frameworks, and data pipeline concepts
  • Experience with relational databases, data validation, testing, and version control tools such as Git
  • Strong analytical, problem-solving, and debugging skills
  • Ability to translate business requirements into scalable data solutions and collaborate with cross-functional teams
  • Experience with Snowflake, Google BigQuery, Amazon Redshift, or Databricks
  • Hands-on experience with dbt models, tests, macros, and documentation
  • Basic to intermediate Python skills for data processing and automation
  • Familiarity with Apache Airflow, Dagster, or similar orchestration tools
  • Exposure to cloud data warehouses, data lakehouse architectures, and CI/CD practices
  • Experience working with large-scale customer, transactional, or event-driven datasets
  • Familiarity with CRM, CDP, enterprise SaaS, or customer loyalty platforms
  • Understanding of loyalty concepts such as reward points, customer tiers, redemption, and customer engagement
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: San José
288 Employees
Year Founded: 2015

What We Do

Headquartered in Silicon Valley, Loyalty Juggernaut, Inc. (LJI) is the next-gen loyalty and customer engagement solutions enterprise, helping brands reimagine their customer loyalty initiatives in #theageofdigitalcustomer. GRAVTY®, LJI’s digital transformation platform is specifically designed for the ecosystem-centric loyalty programs. Built ground-up on break-through technologies including serverless computing, microservices architecture, AI/ML, and big data, GRAVTY® addresses the fundamental limitations of the traditional loyalty platforms and enables brands to deliver on the digital customer expectations comprehensively. GRAVTY® client base includes leading global brands, running industry-defining and award-winning, ecosystem-centric loyalty programs in airline, hospitality, retail, food & beverages, financial services, telco and multi-brand, diversified business groups.

Similar Jobs

Ciklum Logo Ciklum

Analytics Engineer

Information Technology • Consulting
Remote or Hybrid
India
2995 Employees

Capgemini Logo Capgemini

Analytics Engineer

Information Technology
In-Office
2 Locations
340000 Employees

Merck Logo Merck

Platform Engineer

Healthtech • Biotech • Pharmaceutical
Hybrid
Hitech City, Rangareddy, Telangana, IND
74000 Employees

AVEVA Logo AVEVA

Forward Deployed Solution Engineer - Advanced Analytics

Agency • Artificial Intelligence • Cloud • Internet of Things • Software • Automation
In-Office
Hyderabad, Telangana, IND
6970 Employees

Similar Companies Hiring

Revel Thumbnail
Aerospace • Hardware • Robotics • Software
Marina Del Rey, California
70 Employees
Blee Thumbnail
Artificial Intelligence • Marketing Tech • Software
New York, New York
33 Employees
Vega Thumbnail
Artificial Intelligence • Automotive • Insurance • Transportation
US
65 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account