Analytics Engineer

Experience- 5+ Years

Shift Timings- 2:00 PM - 11:00 PM IST

Key Responsibilities

• Design and develop analytics-ready datasets optimized for BI consumption

• Build and maintain BI-focused data models (facts, dimensions, star/snowflake schemas) to support BI semantic models

• Define, document, and govern business metrics and calculations

• Develop transformations and analytical models using dbt and Python

• Leverage existing SQL Server and AWS data warehouse data to create trusted analytical data sources

• Write, debug, and maintain Python-based data transformation and analytics logic independently

• Partner with BI and business teams to ensure accurate, consistent, and well-defined data structures

• Analyze and reverse-engineer existing datasets or reports to diagnose data or metric inconsistencies

• Ensure data quality, performance, scalability, and reliability of analytical models with minimal dependency on other engineers

Required Technical Skills

• Advanced SQL Server expertise with strong analytical SQL skills

• Strong, hands-on Python experience for data transformation, analytics engineering, and problem solving (conceptual knowledge is not sufficient)

• Strong experience with dbt for analytics engineering and data transformations

• Hands-on experience with BI data modeling (relationships, measures, performance optimization)
  (Dashboard/UI development is not required)

• Solid understanding of data warehousing and dimensional modeling concepts

• Working knowledge of AWS data engineering services (Redshift, S3, Glue, data pipelines)

• Databricks experience is a plus and can be learned quickly by candidates with strong Python skills

• Ability to work independently and deliver end-to-end analytical solutions without heavy reliance on others

ABOUT ISHIR

ISHIR is a digital innovation and enterprise AI services provider. We work with startups and enterprises to shape the future through accelerated innovation, deep technical expertise, access to global digital talent and a passion for complex problem-solving. With our help, our clients overcome their most difficult digital challenges leveraging AI.

We are not just consultants, we are partners in our clients’ success, assisting them with re(gaining) competitive edge by identifying opportunities for differentiation, industry disruption, scalable innovation, and go-to-market strategies that deliver successful outcomes.

At ISHIR, we help bold businesses accelerate innovation through Talent, Speed-to-Market, and AI. We help make an impact by solving real problems using innovation, improved customer experiences and the right technologies.

As an ISHIR employee, you will get the advanced training you need to be successful, and the opportunity to apply it. You must be passionate about technology, crave responsibility, and be eager to apply your knowledge to real business solutions for our startup and enterprise customers. These are the qualities of a person destined for success at ISHIR.

ISHIR attracts a special type of individual—someone who is proactive, thrives on challenges, feeds off success, and looks at moving targets not as obstacles but as opportunities. ISHIR is an exciting place to work. It is imbued with an entrepreneurial spirit and promotes self-reliance, open communication, and collaboration.