Software Engineering and Infrastructure Development - Team Lead

1685 SS CORP SVCS MUMBAI PVT LTD; Bengaluru; On-site; INR 1,500,000 - 2,100,000; Full time

Job summary

State Street Corp. in Bengaluru invites an experienced Data Analyst to design and implement automated data solutions with a strong focus on reporting automation using Power BI, Power Automate, and MS Fabric.

You will collaborate with stakeholders to build scalable dashboards, orchestrate data pipelines, and ensure governance across reporting platforms. The role requires 6–8 years of data automation and SQL expertise, advanced Power BI skills, and a solid grounding in data modeling and DAX.

Qualifications

• 6–8 years of experience in data automation and quality assurance.
• Strong proficiency in advanced automation skills, SQL understanding.
• Strong experience in Power BI Desktop, MS FABRIC, Medallion architecture, Power BI Service.
• Advanced knowledge of DAX, Power Query (M Language), and Data Modeling.

Responsibilities

• Design, develop, and maintain automated reporting solutions to support business, operational, and management reporting requirements.
• Develop interactive dashboards, scorecards, and visualizations using Power BI to enable data-driven decision-making.
• Leverage Power Automate and Microsoft Fabric to streamline reporting workflows, eliminate manual processes, and improve operational efficiency.
• Partner with business stakeholders to gather reporting requirements and translate them into scalable reporting and analytics solutions.
• Develop and optimize data models, reporting datasets, and automated data pipelines.
• Ensure data accuracy, integrity, governance, and consistency across reporting platforms and business reports.
• Perform data analysis to identify trends, risks, opportunities, and actionable business insights.
• Support reporting transformation initiatives, including report rationalization, standardization, and migration to modern reporting platforms.
• Collaborate with technology, data engineering, and operational teams to implement reporting enhancements and automation opportunities.
• Create and maintain reporting documentation, process maps, data dictionaries, and governance controls.
• Monitor reporting performance and proactively identify opportunities for continuous improvement and process optimization.

Skills

Data automation

SQL

Power BI

DAX

Power Query

Data Modeling

MS Fabric

Medallion Architecture

Tools

Power BI Desktop

MS Fabric

Power BI Service

Job description

About the Role

We are seeking a highly skilled Data Analyst to join our team. The ideal candidate will have 6 to 8 years of experience in designing and implementing robust data solutions with a strong focus on automation of Reporting framework using MS tools like Power BI/ Power Automate / MS FABRIC and Knowledge of SQL/Python / Snowflake is a plus

Key Responsibilities

• Design, develop, and maintain automated reporting solutions to support business, operational, and management reporting requirements.
• Develop interactive dashboards, scorecards, and visualizations using Power BI to enable data-driven decision-making.
• Leverage Power Automate and Microsoft Fabric to streamline reporting workflows, eliminate manual processes, and improve operational efficiency.
• Partner with business stakeholders to gather reporting requirements and translate them into scalable reporting and analytics solutions.
• Develop and optimize data models, reporting datasets, and automated data pipelines.
• Ensure data accuracy, integrity, governance, and consistency across reporting platforms and business reports.
• Perform data analysis to identify trends, risks, opportunities, and actionable business insights.
• Support reporting transformation initiatives, including report rationalization, standardization, and migration to modern reporting platforms.
• Collaborate with technology, data engineering, and operational teams to implement reporting enhancements and automation opportunities.
• Create and maintain reporting documentation, process maps, data dictionaries, and governance controls.
• Monitor reporting performance and proactively identify opportunities for continuous improvement and process optimization.

Required Skills

• 6–8 years of experience in data automation and Quality assurance.
• Strong proficiency in advanced automation skills, SQL understanding.
• Strong experience in Power BI Desktop, MS FABRIC, Medallion architecture, Power BI Service.
• Advanced knowledge of DAX, Power Query (M Language), and Data Modeling.

About State Street

Across the globe, institutional investors rely on us to help them manage risk, respond to challenges, and drive performance and profitability. We keep our clients at the heart of everything we do, and smart, engaged employees are essential to our continued success. We are committed to fostering an environment where every employee feels valued and empowered to reach their full potential.

You’ll benefit from inclusive development opportunities, flexible work-life support, paid volunteer days, and vibrant employee networks that keep you connected to what matters most. Join us in shaping the future.

As an Equal Opportunity Employer, we consider all qualified applicants for all positions without regard to race, creed, color, religion, national origin, ancestry, ethnicity, age, disability, genetic information, sex, sexual orientation, gender identity or expression, citizenship, marital status, domestic partnership or civil union status, familial status, military and veteran status, and other characteristics protected by applicable law.