BI Reporting Engineer

BI - Reporting Engineer

Location: India, Remote

Experience: 8+ Years Algoworks www.algoworks.com

About the company Algoworks is an award-winning artificial intelligence, engineering services and experience transformation firm with offices across the United States, Europe, South America and India. We bring together a global team of engineers, architects, designers, researchers and operators united by rigor, accountability and a commitment to delivering measurable results. For over 20 years, Algoworks has partnered with Fortune 500 organizations across the Americas, Europe and Asia to define, build and run technology that drives meaningful business outcomes. Our work combines human-centered design, engineering excellence and AI-powered capabilities to solve complex challenges with clarity and precision. Innovation, particularly in the responsible application of AI, is embedded in how teams approach problem-solving and continuous improvement. At Algoworks, growth is continuous and closely tied to impact. Teams collaborate across geographies and disciplines, strengthening outcomes through shared insight and collective expertise. The culture values transparency, open dialogue and an environment where every voice is heard and contribution is recognized. Through collaboration, accountability and a focus on results, Algoworks operates at the intersection of technology and people, building not only advanced systems but strong global teams that elevate performance and create lasting impact. Follow the video below to know about us! Clipchamp

Role overview We are looking for a BI / Reporting Engineer to design and deliver embedded analytics for a supply chain transaction platform. This role will focus on building clear, reliable dashboards that provide visibility into transaction flows, errors and operational performance across EDI-driven systems. You will work closely with data engineers and business stakeholders to translate raw transaction data into actionable insights that support operations and decision-making.

Key responsibilities:

• Design and develop dashboards using Sigma or Metabase for supply chain analytics.
• Build reports focused on:
• Transaction success and failure rates
• Error categorization and trends
• Throughput by partner, document type and time
• Identification of delayed or failed transactions
• Develop and maintain a semantic layer to ensure consistent KPI definitions across reports.
• Work with data engineering teams to ensure data models support reporting needs.
• Embed dashboards into applications using iframe or similar integration approaches.
• Optimize queries and dashboards for performance and scalability.
• Validate reporting outputs against underlying data for accuracy.
• Use AI tools (Copilot, LLMs) to assist in writing complex SQL queries for dashboards.
• Leverage AI to accelerate KPI definition, metric calculations and reporting logic.
• Use AI to explore data patterns and assist in building meaningful visualizations.
• Validate AI-generated queries and metrics to ensure business accuracy and consistency.

Required Skills and qualifications:

• Bachelor's or Master's degree in Computer Science, Engineering, or a related technical field (or equivalent practical experience).
• 8+ years of experience in BI / reporting / analytics engineering.
• Hands-on experience with Sigma or Metabase (at least one required).
• Strong SQL skills with ability to work on large transactional datasets.
• Experience building dashboards on top of data warehouse platforms (Snowflake or similar).
• Understanding of data modeling concepts for analytics (fact/dimension, aggregations, KPIs).
• Experience working with operational or transaction-based data systems.

Must have skills:

• Experience in supply chain, logistics, retail, or B2B commerce environments.
• Familiarity with EDI transaction reporting (orders, shipments, invoices, acknowledgements).
• Experience building embedded analytics within SaaS applications.
• Exposure to data validation and reconciliation processes.

Good to have skills:

• Experience with Snowflake, dbt, or modern cloud data warehouses.
• Knowledge of Python for data analysis and automation.
• Exposure to AI-assisted analytics (Copilot, ChatGPT, LLM-based SQL generation).
• Experience with API-based data integrations and ETL pipelines.

Desired attributes:

• Strong analytical and problem-solving mindset.
• Ability to translate business requirements into actionable dashboards.
• Excellent stakeholder communication and collaboration skills.
• Detail-oriented with a focus on data accuracy, validation and KPI consistency.

Interview process 2 rounds of discussion