Business Data Analyst

Weekday AI (YC W21); Vadodara; On-site; INR 500,000 - 800,000; Full time

Job summary

Weekday AI (YC W21) seeks an experienced BI Engineer to build and scale analytics capabilities, transforming raw data into trusted datasets and business insights. You will lead semantic modeling, dashboards, and data products, collaborating with stakeholders and data teams.

The ideal candidate has deep expertise in Power BI, SQL, Snowflake, and dbt, with a strong grounding in data warehousing, governance, and scalable analytics practices.

Qualifications

• 3–7 years of experience in BI, Analytics Engineering, Data Engineering, or related field.
• Strong hands-on expertise in Power BI, including semantic models, datasets, dashboards, and enterprise reporting.
• Strong SQL development and data transformation skills.
• Hands-on experience with Snowflake or comparable cloud data warehouse.
• Experience developing and maintaining dbt models, transformations, testing and documentation.
• Understanding of dimensional modelling, star schemas, data warehousing, and semantic layers.
• Experience troubleshooting data-quality, reporting, data pipelines, and performance issues.
• Familiarity with Git, Azure DevOps, source control, and modern development workflows.
• Knowledge of CI/CD practices for analytics and data development is advantageous.

Responsibilities

• Develop and maintain Power BI semantic models, datasets, dashboards, and reports for enterprise reporting and analytics.
• Partner with business stakeholders and data teams to translate requirements into scalable data solutions.
• Build reusable data products and analytics solutions aligned with business objectives.
• Develop and maintain SQL queries, data transformations, and analytics-ready datasets.
• Support ELT workflows and data processing pipelines across enterprise data platforms.
• Develop and maintain dbt models, transformations, tests, and documentation.
• Design dimensional models, star schemas, semantic layers, and data warehouse structures.
• Work with Snowflake to develop, optimise, and maintain analytics-ready data models.
• Assist in onboarding and integration of new data sources into the data platform.
• Implement data validation, quality checks, reconciliation, monitoring, and troubleshooting processes.
• Investigate and resolve data discrepancies, reporting issues, and data-quality problems.
• Contribute to KPI standardisation, metadata management, data lineage, and reporting governance.
• Optimise Power BI and Snowflake solutions for performance and cost efficiency.
• Collaborate with Data Engineers, Analytics Engineers, Data Analysts, and external partners.
• Identify opportunities to automate manual reporting and data preparation activities.
• Contribute to source control, deployment, and CI/CD practices for analytics development.
• Maintain technical documentation and promote consistent enterprise reporting standards.
• Stay current with emerging capabilities across Power BI, Snowflake, dbt, and cloud platforms.

Skills

Power BI

SQL

Snowflake

dbt

Dimensional Modelling

Git/Azure DevOps

Python

Tools

Power BI

Snowflake

dbt

Git

Azure DevOps

Job description

Job Description:

This role is for one of the weekdays clients

Salary range: Rs 500000 - Rs 800000 (ie INR 5-8 LPA)

Experience: 3+ yrs

Location: Vadodara, Gujarat, India

Job Type: Full-time

We are looking for an experiencedBusiness Intelligence Engineerto help build and scale enterprise data and analytics capabilities. The role combinesbusiness intelligence, analytics engineering, data modelling, reporting, and data platform development, with a strong focus on transforming raw operational data into trusted, analytics-ready datasets and business insights.

The ideal candidate will have strong expertise inPower BI, SQL, Snowflake, and dbt, along with a solid understanding of modern data warehousing, semantic modelling, data quality, and governance.

Key Responsibilities

• Develop and maintainPower BI semantic models, datasets, dashboards, and reportsfor enterprise reporting and analytics.
• Partner with business stakeholders and data teams to understand reporting requirements and translate business questions into scalable data solutions.
• Build reusable data products and analytics solutions aligned with business objectives.
• Develop and maintainSQL queries, data transformations, and analytics-ready datasets.
• Support ELT workflows and data processing pipelines across enterprise data platforms.
• Develop and maintaindbt models, transformations, tests, and documentation.
• Design dimensional models, star schemas, semantic layers, and data warehouse structures.
• Work withSnowflaketo develop, optimise, and maintain analytics-ready data models.
• Support onboarding and integration of new data sources into the enterprise data platform.
• Implement data validation, quality checks, reconciliation, monitoring, and troubleshooting processes.
• Investigate and resolve data discrepancies, reporting issues, and data-quality problems.
• Contribute to KPI standardisation, metric definitions, metadata management, data lineage, and reporting governance.
• Optimise Power BI and Snowflake solutions for performance, scalability, usability, and cost efficiency.
• Collaborate with Data Engineers, Analytics Engineers, Data Analysts, and external technology partners.
• Identify opportunities to automate manual reporting and data preparation activities.
• Contribute to source control, deployment, and CI/CD practices for analytics development.
• Maintain technical documentation and promote consistent enterprise reporting standards.
• Stay current with emerging capabilities acrossPowerBI, Snowflake, dbt, cloud data platforms, and modern analytics engineering.

What Makes You a Great Fit

• 3–7 years of experiencein Business Intelligence, Analytics Engineering, Data Engineering, or a related discipline.
• Strong hands-on expertise inPower BI, including semantic models, datasets, dashboards, and enterprise reporting.
• StrongSQL developmentand data transformation skills.
• Hands-on experience withSnowflakeor a comparable cloud data warehouse.
• Practical experience developing and maintainingdbt models, transformations, testing, and documentation.
• Strong understanding ofdimensional modelling, star schemas, data warehousing, and semantic layers.
• Experience troubleshooting data-quality, reporting, data pipeline, and performance issues.
• Familiarity withGit, Azure DevOps, source control, and modern development workflows.
• Understanding of data governance, metadata, lineage, documentation, and enterprise reporting standards.
• Experience with Azure-based data platforms is an advantage.
• Familiarity withPythonfor data analysis, automation, or data engineering is preferred.
• Experience supporting enterprise reporting environments with large user populations is a plus.
• Knowledge of CI/CD practices for analytics and data development is advantageous.
• Experience with construction, real estate, manufacturing, or operational analytics will be beneficial.
• Strong analytical, problem-solving, and attention-to-detail skills.
• Excellent written and verbalEnglish communication skills.
• Ability to collaborate effectively with technical teams and business stakeholders.