Data Analytics & Reporting Specialist - Associate - Software Engineering

Data Analytics & Reporting Specialist - Associate - Software Engineering

Profile Description

We’re seeking a highly skilled and experienced Analytics and Reporting Specialist with a strong background in data modelling, analytics, and visualization using Snowflake and Power BI.

CDRR_Technology

The Cybersecurity organization's mission is to create an agile, adaptable organization with the skills and expertise needed to defend against increasingly sophisticated adversaries. This will be achieved by maintaining sound capabilities to identify and protect our assets, proactively assessing threats and vulnerabilities and detecting events, ensuring resiliency through our ability to respond to and recover from incidents and building awareness and increase vigilance while continually developing our cyber workforce.

Cyber

The Cybersecurity organization's mission is to create an agile, adaptable organization with the skills and expertise needed to defend against increasingly sophisticated adversaries. This will be achieved by maintaining sound capabilities to identify and protect our assets, proactively assessing threats and vulnerabilities and detecting events, ensuring resiliency through our ability to respond to and recover from incidents and building awareness and increase vigilance while continually developing our cyber workforce.

Software Engineering

This is Associate position that develops and maintains software solutions that support business needs.

Morgan Stanley is an industry leader in financial services, known for mobilizing capital to help governments, corporations, institutions, and individuals around the world achieve their financial goals.

At Morgan Stanley India, we support the Firm’s global businesses, with critical presence across Institutional Securities, Wealth Management, and Investment management, as well as in the Firm’s infrastructure functions of Technology, Operations, Finance, Risk Management, Legal and Corporate & Enterprise Services. Morgan Stanley has been rooted in India since 1993, with campuses in both Mumbai and Bengaluru. We empower our multi-faceted and talented teams to advance their careers and make a global impact on the business. For those who show passion and grit in their work, there’s ample opportunity to move across the businesses for those who show passion and grit in their work.

Interested in joining a team that’s eager to create, innovate and make an impact on the world? Read on…

What you’ll do in the role:

Job Overview:

We are seeking a highly skilled and experienced Analytics and Reporting Specialist with a strong background in data modelling, analytics, and visualization using Snowflake and Power BI. The ideal candidate should be proficient in designing and implementing enterprise-level reporting solutions, working with large datasets, and collaborating with cross-functional teams to support data-driven decision-making processes.

Key Responsibilities:

Data Architecture & Management:

·         Design, develop, and optimize complex data models in Snowflake to support reporting and analytics requirements.

·         Ensure data integrity, quality, and accuracy across the organization's Snowflake data warehouse.

·         Work with DBAs, data engineers, and ETL developers to manage and enhance data pipelines.

Analytics & Reporting:

·         Develop interactive and intuitive reports, dashboards, and visualizations using Power BI to support business objectives.

·         Conduct advanced data analysis, including statistical modelling and predictive analytics, to uncover trends and insights.

·         Translate complex data into actionable insights for stakeholders at various levels of the organization.

Collaboration & Consultation:

·         Work closely with business stakeholders, understanding their reporting and analytics needs and ensuring those needs are met with custom solutions.

·         Collaborate with IT and data teams to integrate new data sources into Snowflake and develop data marts for analytics.

·         Provide recommendations to improve processes, reporting frameworks, and dashboards based on best practices.

Performance Monitoring:

·         Monitor the performance of Snowflake queries and Power BI dashboards, optimizing for efficiency and scalability.

·         Troubleshoot and resolve data and reporting issues in a timely manner.

Documentation & Training:

·         Maintain documentation for reporting processes, data sources, and dashboards.

·         Provide training and support to junior analysts and business users on Power BI reporting tools and Snowflake data usage.

What you’ll bring to the role:

Required Skills:

Data Warehousing:

·         Expert knowledge of Snowflake data warehousing principles, architecture, and optimization.

·         Experience with data modeling, normalization, and denormalization in large-scale environments.

Data Analysis & Reporting:

·         Proficient in Power BI for building complex reports, data visualizations, and dashboards.

·         Strong knowledge of DAX (Data Analysis Expressions) and Power Query for data transformation in Power BI.

·         Ability to perform complex SQL queries for data extraction, transformation, and analysis.

Programming & Scripting:

·         Proficiency in scripting languages such as Python or R for data manipulation and analysis.

·         Business Acumen: Ability to interpret business requirements into technical specifications and provide solutions.

Relevant Experience:

·         At least 5 years of experience in data analytics and reporting.

·         3+ years of hands-on experience with Snowflake.

·         2+ years of experience in building reports and dashboards using Power BI.

Certifications (Preferred):

·         Snowflake certifications (e.g., SnowPro Core Certification) and Power BI certifications (e.g., Microsoft Certified: Data Analyst Associate) are highly desirable.

Soft Skills:

·         Strong problem-solving skills and analytical thinking.

·         Excellent communication and interpersonal skills, with the ability to convey complex technical information to non-technical stakeholders.

·         Attention to detail and a proactive approach to managing tasks and issues.

·         Ability to work independently and in a collaborative team environment.

What you can expect from Morgan Stanley

We are committed to maintaining the first-class service and high standard of excellence that have defined Morgan Stanley for over 85 years. At our foundation are five core values — putting clients first, doing the right thing, leading with exceptional ideas, committing to diversity and inclusion, and giving back — that guide our more than 80,000 employees in 1,200 offices across 42 countries. At Morgan Stanley, you’ll find trusted colleagues, committed mentors and a culture that values diverse perspectives, individual intellect, and cross-collaboration. Our Firm is differentiated by the Caliber of our diverse team, while our company culture and commitment to inclusion define our legacy and shape our future, helping to strengthen our business and bring value to clients around the world. Learn more about how we put this commitment to action: morganstanley.com/diversity. We are proud to support our employees and their families at every point along their work-life journey, offering some of the most attractive and comprehensive employee benefits and perks in the industry.

Morgan Stanley is an equal opportunities employer. We work to provide a supportive and inclusive environment where all individuals can maximise their full potential. Our skilled and creative workforce is comprised of individuals drawn from a broad cross section of the global communities in which we operate and who reflect a variety of backgrounds, talents, perspectives, and experiences. Our strong commitment to a culture of inclusion is evident through our constant focus on recruiting, developing, and advancing individuals based on their skills and talents.