Data Modeling & Analytics developer - 547136

NITYO; Pune District; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

NITYO seeks an experienced Data Modeling & Analytics Developer in Pune to design and optimize analytics data pipelines. The role focuses on building scalable ELT workflows using dbt, transforming data from raw to curated layers, and delivering enterprise reporting via Power BI with DAX calculations.

The candidate will work in an afternoon hybrid schedule, collaborating with Product Owners and Tech Leads to ensure high-quality data products that meet business goals.

Qualifications

• Proven experience in designing and optimizing data pipelines for analytics.
• Strong SQL skills and data modeling knowledge (star/snowflake).
• Hands-on with Power BI semantic models and DAX measures.
• Experience with dbt and ELT pipelines in cloud environments.

Responsibilities

• Design, build, and optimize scalable data engineering pipelines for analytics consumption.
• Develop and maintain robust ELT pipelines using dbt, ensuring data quality and reliability.
• Utilize AWS data services to manage and scale data workflows.
• Implement and optimize semantic models in Power BI Premium.
• Apply advanced SQL and DAX for querying and calculations.
• Monitor, troubleshoot, and optimize pipeline performance and reliability.
• Ensure data validation and maintain high data quality standards.
• Collaborate in Agile ceremonies with Product Owners and Tech Leads.
• Document, test, and deploy data/BI solutions end-to-end.

Skills

SQL

Data modeling

Power BI

DAX

dbt

AWS

Python

Azure

CI/CD

Agile

Education

BTech

Tools

dbt

Power BI

AWS

Azure

Python

Job description

Data Modeling & Analytics Developer - 547136

This role is for an experienced Data Modeling & Analytics Developer with 6?8 years of expertise in designing, developing, and optimizing robust data transformation pipelines. The ideal candidate will have advanced skills in SQL, data modeling, and analytics tools such as Power BI and DAX, with a strong focus on building scalable, automated, and high-performance data workflows. The position is based in Pune, Maharashtra, India, and offers a hybrid work arrangement with an afternoon shift. The final round of interviews will be conducted face-to-face.

Key Responsibilities

• Design, build, and optimize scalable data engineering pipelines for analytics consumption.
• Develop and maintain robust ELT pipelines using dbt, ensuring data quality, consistency, and reliability from raw to curated (gold) layers.
• Utilize AWS data services (Athena, S3, Lambda) to manage and scale data workflows.
• Implement and optimize semantic models in Power BI Premium, including datasets and enterprise reporting.
• Apply advanced SQL for querying and data transformations.
• Leverage DAX language for calculation logic, measures, and performance tuning.
• Monitor, troubleshoot, and optimize data pipeline performance and reliability.
• Ensure effective data validation practices and maintain high standards of data quality.
• Participate in Agile ceremonies, collaborate with Product Owners and Tech Leads, and deliver high-quality data products aligned with business objectives.
• Document, test, and deploy data/BI solutions across the end-to-end lifecycle.

Requirements

• BTech degree or equivalent in a relevant field.
• 6?8 years of experience as a Data Engineer or similar role.
• Advanced proficiency in SQL (querying and data transformations).
• Strong understanding of data modeling concepts, including dimensional modeling (Star/Snowflake).
• Hands-on experience with dbt for ELT pipeline development.
• Experience with AWS data services (Athena, S3, Lambda).
• Expertise in Power BI (semantic models, datasets, enterprise reporting).
• Proficiency in DAX language (calculation logic, measures, performance tuning).
• Familiarity with Azure data ecosystem (Azure SQL, T-SQL, ADF, etc.).
• Python scripting for automation and data ingestion.
• Knowledge of CI/CD practices for deploying data transformation workflows.
• Experience working in Agile delivery environments.
• Strong analytical, problem-solving, and communication skills for global stakeholder collaboration.
• Teamwork and conflict resolution abilities.

Work Arrangements

• Location: Pune, Maharashtra, India
• Type: Contract
• Work Mode: Hybrid
• Shift Timings: Afternoon Shift (11:30 AM ? 9:30 PM)
• Interview Process: Face-to-face final round