Analytics Engineer

Great people. Greater business impact.

About CAI

CAI Software builds digital work execution platforms and software solutions that help manufacturing businesses operate with greater clarity and control. Our people bring structure to complexity by replacing fragmented, paper-based processes with connected digital workflows that improve visibility, compliance, and decision-making in real industrial environments. With 45+ years of experience and a presence across 10+ countries, CAI combines deep industry understanding with practical technology. Our team consists of ~800 employees worldwide who work across 15 core industries and support 5,000+ customers, guided by sound judgment, long-term thinking, and outcomes that endure.

CAI Business Units and the Markets We Serve

CAI Software is organized into three business units - Graphic Communications, Process Manufacturing, and Discrete Manufacturing – aligned to the markets we serve. This structure allows our teams to stay close to customer needs while operating with the scale and support of a global software company.

This role is part of our Process Manufacturing business unit, which provides ERP and operational software to manufacturers that transform raw materials into finished goods through formulas, recipes, or batch-driven processes. We work with small to enterprise manufacturers across industries such as food and beverage, bottling, pharmaceuticals, nutraceuticals, chemicals, paint, paper, tile, and supply chain logistics—supporting end-to-end operations from sourcing through production and distribution.

CAI India

CAI India is a strategic investment in the company’s future. Our Bangalore Center of Excellence is a place of ownership, expertise, and accountability. Teams in India work on global products end to end, contribute to key decisions, and influence how CAI evolves as a business. This is not a support-led model, but rather a center designed to lead through knowledge, responsibility, and trust.

About the Role

Location: Remote / Hybrid

Department: Engineering

Reports To: Director of Data Engineering and Analytics

We are seeking an Analytics Engineer to own the transformation layer and customer-facing analytics for our SaaS platform serving seafood processors, distributors, and logistics operators. You will turn reliable raw data into well-modeled, well-documented, business-ready data products — building the dbt models, metrics definitions, and Power BI dashboards that give our customers real operational visibility.

This role sits at the intersection of data and product. You will work closely with product managers, customer success, and end users to understand operational needs and translate them into scalable, reusable data models..

What You’ll Do

• Design and maintain dbt models across staging, intermediate, and mart layers
• Build reusable models for core operational domains: inventory traceability, lot tracking, yield optimization, and route performance
• Develop and maintain Power BI dashboards and embedded analytics delivered to customers
• Define and document metrics, business logic, and data lineage Translate customer and product requirements into scalable data models
• Implement data testing and documentation within dbt to ensure model reliability
• Partner with the Data Engineer to align on data contracts at the ingestion layer
• Support advanced analytics and AI initiatives by providing clean, well-structured datasets

What We’re Looking For

Required:

• 4+ years of experience in an analytics engineering, BI engineering, or senior data analyst role
• Experience with a major cloud platform (AWS, Azure, or GCP); Azure preferred
• Strong dbt skills — modeling patterns, testing, documentation, and incremental strategies Experience with ELT/ETL frameworks and pipeline patterns
• Advanced SQL and Python skills, including complex joins, window functions, and query optimization in Snowflake
• Experience with Snowflake or equivalent cloud data warehouse (e.g., BigQuery, Redshift) Experience building and maintaining Power BI reports and dashboards
• Proficiency with Git for version control
• Demonstrated ability to translate business requirements into data models
• Strong communication skills — you will work directly with product and customer-facing teams

Nice to Have:

• Experience in food production, logistics, or supply chain domains Familiarity with inventory traceability, lot tracking, or yield concepts
• Exposure to semantic layers or metrics frameworks (e.g., dbt Semantic Layer, LookML)
• Experience delivering analytics as part of a customer-facing SaaS product

Success Metrics

• Customers achieve clear, accurate visibility into inventory, shipments, and operational performance
• dbt models are well-tested, documented, and reusable across product areas
• Dashboard adoption and engagement increase quarter over quarter
• Analytics directly inform measurable operational improvements for customers

Why Join Us

You’ll have the opportunity to drive some of the most critical transformation initiatives in our company’s history. This is a highly visible role working directly with senior leadership to shape the future operating model of CAI. You’ll bring clarity, discipline, and execution focus to complex cross-functional programs while gaining exposure across every function of the business.