Time since we first saw it
Day 20
Similar jobs usually come down between day 5 and day 43.
At Gallagher, jobs usually come down by about day 45.
From 16,008 similar postings that came down, and 139 of Gallagher’s. Coming down is not always a hire.
Bangalore, India
Live, first seen by us 20 days agoEmployment type in the employer’s posting: FULL_TIMEFrom the employer’s posting
Design and govern dimensional, relational and semantic data models
Write and review complex SQL and optimise source-to-report pipelines
Establish validation and reconciliation controls for data models and BI outputs
Mentor analysts and set standards for SQL, DAX, modelling and testing
Partner with senior business and CDO stakeholders to define KPIs
Design and govern dimensional, relational, and semantic data models
Write and review complex SQL
Establish validation and reconciliation controls for data models and BI outputs
Mentor analysts through design reviews, pair problem-solving, coaching, knowledge sharing, and feedback
Partner with senior business and CDO stakeholders to define KPIs
These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.
Day 20
Similar jobs usually come down between day 5 and day 43.
At Gallagher, jobs usually come down by about day 45.
From 16,008 similar postings that came down, and 139 of Gallagher’s. Coming down is not always a hire.
62 open jobs
Open jobs by the week we first saw them, last 12 weeks.
Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.
Knowledge, Skills and Ability Advanced SQL capability, including complex joins, subqueries, common table expressions, aggregations, window functions, performance tuning, data extraction, validation, and troubleshooting Demonstrated expertise in dimensional, relational, and semantic data modelling, including star schemas, fact and dimension design, grain, keys, slowly changing dimensions, hierarchies, relationships, reusable measures, and model governance Advanced Power BI capability covering semantic models, DAX, Power Query, row-level security, deployment practices, performance optimisation, refresh management, KPI design, and governed self-service BI Ability to define BI architecture and modelling standards, conduct design and code reviews, assess technical trade-offs, and guide scalable, maintainable solution design Experience leading dashboard, management-information, and analytical-product delivery from requirements and data discovery through testing, release, adoption, and support Strong understanding of data quality dimensions, profiling, reconciliation, control design, exception reporting, root cause analysis, issue management, and model assurance Working knowledge of data governance concepts including ownership, stewardship, metadata, business glossaries, lineage, Critical Data Elements, controls, access, and audit evidence Proven mentoring and coaching skills, with the ability to build analyst capability through feedback, knowledge sharing, pair problem-solving, and structured development support Ability to provide light-touch people management for a small team, including work allocation, prioritisation, regular check-ins, capacity planning, objective setting, and appropriate escalation Strong stakeholder-management and communication skills, including the ability to influence senior technical and non-technical audiences and translate business needs into clear BI outcomes Exposure to Microsoft Fabric, Azure Data Services, Snowflake, Databricks, Python, Power Automate, Collibra, Alation, Informatica, Tableau, or similar platforms is desirable Strong ownership, attention to detail, commercial awareness, curiosity, problem-solving ability, and commitment to reliable delivery in a global stakeholder environment Additional Information At Gallagher, we believe supporting our colleagues goes far beyond the role itself.
The role combines hands-on technical leadership in SQL, semantic and dimensional modelling, Power BI, data quality, and governance with mentoring of analysts and limited day-to-day people-management responsibilities for a small team.
SQL and Data Engineering Collaboration: Write and review complex SQL
set standards for SQL, DAX, modelling, visualisation, documentation, testing, and deployment.
About you Qualifications: Minimum Required Degree: Bachelor’s degree in a relevant discipline Preferred Degree: Bachelor’s or Master’s degree in Computer Science, Information Technology, Data Analytics, Statistics, Mathematics, Engineering, Business Analytics, or a related quantitative discipline Certificate(s)/Special Training: Preferred certification or training in Power BI, data modelling, Microsoft Fabric, Azure, SQL, data architecture, data quality, data governance, leadership, coaching, or equivalent platforms and practices Experience (Career Level Guide): Manager Level: 10 to 15 years of progressive experience in business intelligence, analytics, SQL, dimensional or semantic data modelling, dashboard delivery, data validation, or data governance, including demonstrated technical leadership and mentoring.
Complete your application on indiajobs-ajg.icims.com. The employer’s form will show what is required.
Already applied? Track this application
New Analyst postings at the employers we follow are up 26% over the last 6 weeks compared with the 6 before.
Each bar is one week of new postings. The darkest bars are the last 6 weeks.
Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.
We file this job under Analyst, by the work the posting describes.
Analysts answer business questions with data. They pull numbers with SQL, build reports and dashboards, and explain what changed and why to the people making decisions.
Most postings ask for SQL, spreadsheets, a dashboard tool such as Tableau or Power BI, and clear writing.
Unlike a data scientist, an analyst mostly explains what happened rather than building models that predict what will.
Selected passages from the saved posting. Check the full description for conditions and exceptions.
No pay amount identified in the saved description.
Bangalore, India
Working pattern and location restrictions need checking in the full posting.
No clear work-authorization passage found. Eligibility is unconfirmed.