Data Analytics & BI Engineer - IDL Technology

Barclays; Maharashtra; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Barclays in Pune is hiring a Data Analytics & BI Engineer – IDL Technology to design, develop and maintain dashboards and reports that empower data-driven decision making.

You will leverage Power BI/Tableau/Qlik, SQL and data modelling to deliver trusted datasets, automate reporting, ensure data quality and tell compelling data stories across business units.

Qualifications

• Strong BI engineering capability, including semantic model design, DAX measures, report design, performance tuning, row-level security and workspace / deployment pipeline management.
• Strong SQL and data modelling expertise to produce curated, explainable and trusted datasets.
• Strong SQL, data-modelling and data-quality skills, including preparation, validation and reconciliation of analytical datasets.
• Experience with Power BI, Tableau or Qlik and strong data storytelling skills. observability and auditability.

Responsibilities

• Design and development of comprehensive reports and dashboards utilisng best practices in data visualisation principles and design aesthetics to ensure clarity, accuracy, and accessibility.
• Design, development and implementation of automated report generation processes and visualisation methodologies for improved efficiency and timeliness.
• Identification and analysis of business requirements to define report content and format.
• Maintenance and updating of existing reports and dashboards to reflect changing business needs, including co-ordination of reporting template releases and related administrative tasks.
• Development of robust processes & controls for collating input data, performing exploratory data analysis & data cleansing and seeking signoffs as required.
• Engagement with stakeholders as needed to ensure up to date data is incorporated into reporting and visualisations.
• Lead a team performing complex tasks, coaching and guiding staff to deliver objectives and maintain governance.

Skills

BI engineering

Semantic models

DAX measures

Report design

Performance tuning

Row-level security

Deployment pipelines

Power BI dashboards

MI reporting

Data storytelling

Observability

Auditability

SQL

Data modelling

Data quality

Tableau

Qlik

Kafka

Spark

Tools

Power BI

Tableau

Qlik

Kafka

Spark

Job description

Join us as a “Data Analytics & BI Engineer - IDL Technology " at Barclays, where you'll spearhead the evolution of our digital landscape, driving innovation and excellence. You'll harness cutting-edge technology to revolutionise our digital offerings, ensuring unapparelled customer experiences.

You may be assessed on the key critical skills relevant for success in role, such as experience with, skills to meet business requirement as well as job‑specific skillsets.

To be successful as a “Data Analytics & BI Engineer - IDL Technology", you should have experience with:

Basic/ Essential Qualifications

• Strong BI engineering capability, including semantic model design, DAX measures, report design, performance tuning, row-level security and workspace / deployment pipeline management. Hands-on experience developing enterprise BI dashboards, operational MI and data visualisations using modern tools such as Power BI.
• Strong SQL and data modelling expertise to produce curated, explainable and trusted datasets.
• Strong SQL, data-modelling and data-quality skills, including preparation, validation and reconciliation of analytical datasets.
• Experience with Power BI, Tableau or Qlik and strong data storytelling skills. observability and auditability.

Desirable Skillsets/ Good To Have

• Experience with streaming / event-driven technologies such as Kafka, Spark or structured streaming.
• Experience working in regulated environments with secure-by-design controls, retention, access governance and evidencing requirements.
• Experience building and operating reliable production-grade data pipelines, including near-real-time or streaming patterns, with strong controls around quality, reconciliation.

This role will be based out of Pune.

Purpose of the role

To support the bank's decision-making processes by providing timely, accurate, and insightful information through designing, developing, and maintaining management reports, compelling visualisations and dashboards that effectively communicate key performance indicators (KPIs), data insights and trends across various business units.

Accountabilities

• Design and development of comprehensive reports and dashboards utilisng best practices in data visualisation principles and design aesthetics to ensure clarity, accuracy, and accessibility.
• Design, development and implementation of automated report generation processes and visualisation methodologies for improved efficiency and timeliness.
• Identification and analysis of business requirements to define report content and format.
• Maintenance and updating of existing reports and dashboards to reflect changing business needs, including co-ordination of reporting template releases and related administrative tasks.
• Development of robust processes & controls for collating input data, performing exploratory data analysis & data cleansing and seeking signoffs as required.
• Engagement with stakeholders as needed to ensure up to date data is incorporated into reporting and visualisations.

Assistant Vice President Expectations

• To advise and influence decision making, contribute to policy development and take responsibility for operational effectiveness. Collaborate closely with other functions/ business divisions.
• Lead a team performing complex tasks, using well developed professional knowledge and skills to deliver on work that impacts the whole business function. Set objectives and coach employees in pursuit of those objectives, appraisal of performance relative to objectives and determination of reward outcomes
• If the position has leadership responsibilities, People Leaders are expected to demonstrate a clear set of leadership behaviours to create an environment for colleagues to thrive and deliver to a consistently excellent standard. The four LEAD behaviours are: L – Listen and be authentic, E – Energise and inspire, A – Align across the enterprise, D – Develop others.
• OR for an individual contributor, they will lead collaborative assignments and guide team members through structured assignments, identify the need for the inclusion of other areas of specialisation to complete assignments. They will identify new directions for assignments and/ or projects, identifying a combination of cross functional methodologies or practices to meet required outcomes.
• Consult on complex issues; providing advice to People Leaders to support the resolution of escalated issues.
• Identify ways to mitigate risk and developing new policies/procedures in support of the control and governance agenda.
• Take ownership for managing risk and strengthening controls in relation to the work done.
• Perform work that is closely related to that of other areas, which requires understanding of how areas coordinate and contribute to the achievement of the objectives of the organisation sub-function.
• Collaborate with other areas of work, for business aligned support areas to keep up to speed with business activity and the business strategy.
• Engage in complex analysis of data from multiple sources of information, internal and external sources such as procedures and practises (in other areas, teams, companies, etc).to solve problems creatively and effectively.
• Communicate complex information. 'Complex' information could include sensitive information or information that is difficult to communicate because of its content or its audience.
• Influence or convince stakeholders to achieve outcomes.

All colleagues will be expected to demonstrate the Barclays Values of Respect, Integrity, Service, Excellence and Stewardship – our moral compass, helping us do what we believe is right. They will also be expected to demonstrate the Barclays Mindset - to Empower, Challenge and Drive - the operating manual for how we behave.