Senior Data & BI Developer / Architect

Story Behind the Need:

• Business group: Business Banking Credit Risk (BBCR) – Data & Analytics
• Project: Looking for a skilled Senior Data & Business Intelligence Developer/Architect to drive data initiatives in Business Banking Credit Risk (BBCR).
• This role focuses on modernizing data architecture, boosting analytics, and developing scalable, cloud-native BI solutions using Power BI, Microsoft Fabric, and Databricks.
• The ideal candidate has strong hands-on experience building end to end data pipelines, designing efficient data models, and developing analytical assets that meet enterprise standards for performance, governance, and reliability.
• Reason: New role for a funded project

Candidate Value Proposition:

• The successful candidate will have the opportunity to join a purpose-driven winning team, committed to results, in an inclusive and high-performing culture.

Key Accountabilities:

• Design, build, and optimize data pipelines using Power BI Premium, MS Fabric, and/or Databricks.
• Develop scalable semantic models, star schemas, and tabular models for enterprise analytics.
• Build high-quality Power BI datasets, dashboards, and reports aligned with business requirements and visual best practices.
• Implement data quality controls, lineage documentation, metadata standards, and observability metrics.
• Collaborate with business partners, data engineers, risk analysts, and architecture teams to define requirements and deliver analytical solutions.
• Support environment configuration, workspace governance, performance tuning, and capacity optimization in Power BI Premium / Fabric capacities.
• Contribute to the modernization of BBCR’s next-generation data architecture.

Must have skills:

• 7+ years in Data Engineering, BI Development, or Data/BI Architecture roles.
• Hands-on technical experience with
• 7 years of experience with Power BI (DAX, M language, data modeling, Premium capacities). – Expert level
• 7 years of experience with SQL (advanced querying, performance tuning, stored procedures). – Expert level
• 5 years of experience with Microsoft Fabric (Data Engineering, Data Factory, Lakehouse, Warehouse, KQL). – Expert level
• 3 years of experience with Databricks (PySpark, Delta Lake, notebooks, workflow orchestration).
• Expert level experience with Data Lake file formats: Parquet, Delta, ORC, DuckDB
• Strong understanding of:
o Dimensional modeling (Kimball), semantic modeling, and data governance.
o Lakehouse and modern data architecture patterns.
o CI/CD for analytics, version control (Git), and DevOps pipelines.
• Experience working in enterprise environments with structured SDLC processes.

Nice to have:

• Experience in Risk Analytics, Banking, or Credit Risk domains.
• Familiarity with PowerShell, Power Platform (Power Apps, Power Automate), Python.
• Architect and refine Lakehouse and Medallion-based data structures using Delta/Parquet/DuckDB formats.
• Knowledge of Security, Privacy, and Compliance standards in financial institutions.

Soft Skills Required:

• Strong communication with ability to translate technical details for business stakeholders.
• Proven ability to work independently in a fast-paced, multi-project environment.
• Problem solver mindset with focus on quality, accuracy, and analytical rigor.
• Collaborative team player who contributes to architectural discussions and recommendations.

Education:

• Bachelor’s Degree level or above education, ideally in Computer science, Engineering, business, financial or technology
• Certified with MS Fabrics, Data Bricks and Power BI is nice to have.

Best VS. Average Candidate:

• This will be a technical role. Need hands on technical development expertise.
• Looking for a Senior Data & BI Developer / Architect with previous experience with modernizing data architecture, boosting analytics, and developing scalable, cloud-native BI solutions using Power BI, Microsoft Fabric, and Databricks.
• The ideal candidate has strong hands-on experience building end to end data pipelines, designing efficient data models, and developing analytical assets that meet enterprise standards for performance, governance, and reliability.

Candidate Review & Selection:

• Interview format: 2 rounds of interviews
o 1 round with over MS team Video – 30 mins. With HM and Leadership.
o 2nd round – 30mins – In-Person Interview with HM and Senior Team member
o Technical and Behavioural questions based on previous experience.

Please note:

• AI is not used to screen, assess, or select candidates.
• This role reflects an existing vacancy at the time of posting.