Data Analytics & Reporting Specialist - Associate - Software Engineering Job in Bangalore at Morgan Stanley

Morgan Stanley is hiring for Data Analytics & Reporting Specialist - Associate - Software Engineering

Responsibilities of Candidates:

• 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 modeling 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.

Requirements:

• Expert knowledge of Snowflake data warehousing principles, architecture, and optimization.
• Experience with data modeling, normalization, and denormalization in large-scale environments.
• 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.
• 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.
• 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.
• Strong problem-solving skills and analytical thinking.
• Excellent communication and interpersonal skills, with the ability to convey complex technical information to non-technical stakeholders.