Analytics Engineer

Loyalty Juggernaut, Inc

Hyderabad

On-site

INR 900,000 - 1,300,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

LJI Loyalty Juggernaut (LJI) in Hyderabad is seeking a skilled Analytics Engineer with 1–3 years of experience. You will bridge data engineering and BI by transforming raw data into clean, reliable datasets and building data models for reporting and analytics.

You will work with Data Engineering, BI, Product, and Client teams to deliver trusted data solutions for enterprise loyalty programs, using SQL, dbt, and data warehousing concepts to support dashboards and strategic insights.

Qualifications

  • Bachelor's degree in CS, engineering, IT, statistics, or related field.
  • 1–3 years of analytics engineering or data engineering experience.
  • Strong SQL skills including joins, CTEs, window functions, and optimization.
  • Experience with data transformation, modeling, and analytics-ready datasets.
  • Knowledge of data warehousing, dimensional modeling, star schemas.

Responsibilities

  • Build and maintain SQL-based data transformation models.
  • Develop and optimize data models using SQL/dbt.
  • Design dimensional data models (fact and dimension tables).
  • Integrate data from multiple sources (databases, APIs, loyalty platforms).
  • Translate business requirements into reusable datasets and metrics.
  • Maintain data documentation and data lineage.
  • Collaborate with BI, Data Engineering, Product, and Client teams.
  • Ensure data quality and validation rules are in place.

Skills

SQL skills
Data transformation
Analytics engineering
Problem solving
Cross-functional collaboration

Education

Bachelor's degree in CS/Engineering/IT/Statistics

Tools

dbt
Git
Airflow
Databricks

Job description

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.

Exploremoreaboutusatwww.lji.io.

OurGlobalImpact:
  • 400+Millionmembersconnectedthroughourplatform.
  • 100+GlobalBrandstrustustodriveloyaltyandbranddevotion.
  • 3-TimeWinnerof“BestTechnologyInnovationinLoyalty”.
  • GlobalrecognitionsforExcellenceinLoyaltyManagementundernumerouscategories.
  • Recognizedasa‘Strongperformer’inTheForresterWave™LoyaltyPlatforms,Q42025.
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.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Marketing and Loyalty Analytics Specialist (Campus Hiring, Batch of 2027)
Marketing and Loyalty Analytics Specialist (Campus Hiring, Batch of 2027)

Loyalty Juggernaut, Inc • Hyderabad

On-site
INR 600,000 - 1,000,000
Business Intelligence Analyst
Business Intelligence Analyst

Loyalty Juggernaut • Hyderabad

On-site
INR 400,000 - 600,000
Data Scientist (ML & Statistics)
Data Scientist (ML & Statistics)

Loyalty Juggernaut, Inc • Hyderabad

On-site
INR 1,200,000 - 2,400,000
Business Intelligence Analyst
Business Intelligence Analyst

Loyalty Juggernaut, Inc • Hyderabad

On-site
INR 600,000 - 1,200,000
Associate Product Manager (Campus Hiring, Batch of 2027)
Associate Product Manager (Campus Hiring, Batch of 2027)

Loyalty Juggernaut, Inc • Hyderabad

On-site
INR 1,200,000 - 2,000,000
LPM Senior Strategist
LPM Senior Strategist

Loyalty Juggernaut, Inc • Hyderabad

On-site
INR 4,000,000 - 6,000,000
Loyalty program strategy experience
Experience in airline, hospitality, or
Product Specialist (Campus Hiring, Batch of 2027)
Product Specialist (Campus Hiring, Batch of 2027)

Loyalty Juggernaut, Inc • Hyderabad

On-site
INR 1,500,000 - 2,200,000
Product Engineer (AI)
Product Engineer (AI)

Loyalty Juggernaut, Inc • Hyderabad

On-site
INR 1,800,000 - 2,600,000
Product Specialist (Entry Level MBA Graduates)
Product Specialist (Entry Level MBA Graduates)

Loyalty Juggernaut, Inc • Hyderabad

On-site
INR 800,000 - 1,200,000
Senior Product Manager
Senior Product Manager

Loyalty Juggernaut, Inc • Hyderabad

On-site
INR 4,200,000 - 6,400,000