Data Analyst focusing on delivering key risk, control, and performance metrics. Joining Morgan Stanley's Technology division for innovative solutions and analysis.
Responsibilities
Identifying and validating data sources that create and support various metrics.
Partnering with control owners, project managers and data providers to on-board new data feeds.
Cleansing and preparation of data for analysis.
Resolving issues such as missing or inconsistent data.
Aligning multiple large datasets with varying types and formats.
Creation and presentation of metric calculations.
Visualization and representation of metric graphs and charts.
Creation of key metrics documentation.
Requirements
At least 4 years of demonstrable data analysis experience.
Experience in delivery of technology related metrics and analytics.
Excellent Excel skills including string manipulation functions, VLOOKUP’s, macros and Pivot tables.
Excellent SQL skills including queries and working with relational databases.
Experience in data visualization including high impact dashboards in Power BI.
Basic understanding of technology risk and controls with a focus on data security a plus.
Strong communication and organization skills.
Naturally proactive and ability to thrive where there's ambiguity.
Comfortable working with a high level of independence.
An interest in emerging technologies such as Generative AI and developing real-life applications.
Nice to have - Use of tools like Power Automate to driven efficiency.
Nice to have - Expertise in data modelling such as star schema.
Nice to have - Experience in writing DAX expressions for calculated measures.
Benefits
Some of the most attractive and comprehensive employee benefits and perks in the industry.
Ample opportunity to move across the businesses for those who show passion and grit in their work.
Senior analyst establishing data governance and master data management for Sunrise Farms, a Canadian food processing company. Improving data quality and supporting ERP transformation.
Data Analyst automating reporting and analytics for NBCUniversal’s local digital media sales business. Maintaining Excel, Python, Tableau, and DOMO data workflows.
Business Data Analyst improving product decisions for LawDepot’s legal - document platform. Designing experiments, analyzing customer behaviour, and translating insights into roadmap recommendations.
Data Analyst mining client data and delivering insights for Sun Life’s health and financial security services. Supporting marketing campaigns, reporting, automation, and stakeholder recommendations using SQL, PySpark, AWS, and Tableau.
HR analytics analyst using workforce data, reporting, and AI to improve PCL Construction decisions. Identifying trends and prioritizing automation opportunities for HR operations.
Data Analyst transforming insurance data into business intelligence and performance insights at iA Financial Group. Designing analytics tools, KPIs, and data governance solutions.
Data Analyst using SQL, dbt, and Airbyte for saas.group’s SaaS portfolio analytics. Supporting production data quality, reporting, and acquisition due diligence.
Principal Data Analyst advancing Behaviour Interactive’s Dead by Daylight data strategy. Designing telemetry, analytics, and insights for player behaviour and business decisions.
Data Analyst supporting Ameresco’s AssetPlanner software for energy and facility management. Managing asset data, client support, configuration, reporting, testing, and training.