Position: Engineer II - Data Modeler

(4 to 6 years of experience)

Main responsibilities of the role:

• Learn and master the technologies used in existing IT applications and platforms.
• Work with developers and architects to design, develop and implement Semantic Models.
• Follow the Software Development Life Cycle of the project (Agile, Waterfall, etc.) to develop efficient IT applications.
• Produce clean and efficient code based on specifications/user stories.
• Develop, test, and deploy programs and systems.
• Troubleshoot, debug, and upgrade existing applications.
• Work with the project teams to deliver high quality solutions.
• Create technical documentation for reference and reporting.
• Upgrade your technology skills regularly and professional certifications.
• Collaborate with other team members to complete the assigned tasks as per the expectations.

Required Skills and Knowledge  

Microsoft Fabric -

• Power BI Expertise: Minimum 2-3 years of hands-on experience with Power BI Desktop, Power BI Service, and Power BI Report Server
• DAX Proficiency: Strong knowledge of Data Analysis Expressions (DAX) for creating calculated columns, measures, and complex calculations
• Power Query/M Language: Experience with data transformation and ETL processes using Power Query Editor
• Data Modeling: Proven ability to design and implement star schema, snowflake schema, and other dimensional models
• SQL: Proficient in writing complex SQL queries for data extraction and manipulation
• Database Knowledge: Experience with relational databases (SQL Server, Oracle, MySQL) and understanding of data warehouse concepts
• Data Sources: Ability to connect to and integrate data from multiple sources including Excel, CSV, APIs, SharePoint, and cloud platforms

DevOps & Automation Skills -

• Version Control: Strong experience with Git, GitHub, or Azure DevOps Repos for source control of Power BI files (.pbix, .pbit)
• CI/CD Pipelines: Experience building and maintaining CI/CD pipelines for automated BI deployments using Azure DevOps or GitHub Actions
• Azure DevOps: Hands-on experience with Azure DevOps boards, pipelines, and release management
• Deployment Pipelines: Experience with Power BI deployment pipelines feature for dev/test/prod workflows

Analytical & Visualization Skills -

• Strong understanding of data visualization best practices and principles
• Ability to translate business requirements into effective dashboard designs
• Experience creating interactive reports with drill-through, bookmarks, and custom visuals
• Knowledge of KPI development and metric tracking

Required Qualifications and Additional Skills:

• Knowledge of programming languages and scripting languages (PySpark/Python)
• Databricks knowledge would be a plus
• Degree in Computer Science (BE/B.Tech or similar)

Work location: Wipfli India, Bengaluru