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

• Leverage existing SQL Server and AWS data warehouse data to create trusted analytical data sources
• 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, and scalability of analytical models

Required Technical Skills

• Advanced SQL Server expertise with strong analytical SQL skills
• Hands-on experience with BI data modeling (relationships, measures, performance optimization)
  (Dashboard/UI development is not required)
• Strong experience with dbt for analytics engineering and data transformations
• knowledge of AWS data engineering services (e.g., Redshift, S3, Glue, Data pipe line )
• Solid understanding of data warehousing and dimensional modeling concepts

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.