Simplify Logo

Full-Time

VP – Global Analytics and BI Lead

Posted on 10/23/2024

State Street

State Street

10,001+ employees

Asset management and custody banking services

Fintech
Financial Services

Senior, Expert

Company Provides H1B Sponsorship

Vancouver, BC, Canada

Category
Product Strategy
Product
Required Skills
PowerShell
Power BI
Python
R
SQL
Tableau
AWS
Databricks
Data Analysis
Requirements
  • Proficiency in creating and designing reports and dashboards in Power BI, including advanced visualizations, filters, slicers, and drill-through reports.
  • Strong skills in creating and managing data models in Power BI, including defining relationships, hierarchies, and measures.
  • Advanced knowledge of DAX for building calculated columns, measures, and aggregations to create complex analytical insights.
  • Expertise in Power Query for data preparation, data transformation, and loading (ETL processes) using the M language.
  • Experience in optimizing reports for performance, including reducing report load time and improving data refresh efficiency.
  • Knowledge of role-based security in Power BI, data security, row-level security (RLS), and managing permissions within Power BI service.
  • Hands-on experience migrating from other BI tools like Tableau, Qlik, or SAP BusinessObjects to Power BI.
  • Ability to train teams in Power BI best practices, both technical (e.g., DAX, data modeling) and design-focused (e.g., visualization best practices).
  • Intermediate to advanced SQL skills for querying data from databases, optimizing queries, and creating views for Power BI.
  • Experience with data warehouse architecture and working with large datasets from data warehouses.
  • Familiarity with Databricks Data Lake, and Databrick SQL Database for cloud-based Power BI solutions.
  • Proficiency with other BI platforms like Tableau, Qlik, SAP BusinessObjects, or MicroStrategy, particularly in comparison and migration to Power BI.
  • Experience in working with cloud platforms, particularly Databricks and AWS, for data storage, analytics, and connecting to Power BI.
  • Knowledge of Power BI Service and deployment pipelines for publishing reports and managing cloud-based Power BI solutions.
  • Python and R for advanced analytics, statistical modeling, and integration with Power BI for custom visualizations or machine learning models.
  • PowerShell for scripting and automating Power BI tasks, such as dataset refreshes and report updates.
  • Knowledge of BI best practices, governance, and the ability to align Power BI solutions with broader BI strategy.
  • Proficiency in integrating data from diverse sources (databases, APIs, Excel, cloud platforms) and maintaining data quality.
  • Strong verbal and written communication skills for collaboration with business stakeholders and technical teams globally.
  • Ability to lead Power BI initiatives, including project planning, stakeholder management, and ensuring timely delivery of BI projects.
Responsibilities
  • Manage and respond to data and analytics requests from the EU, United States and APAC ensuring alignment with global strategies and business objectives.
  • Mentor and guide the growing analytics and data teams in EU, North America and India, focusing on skills development and strategic capability enhancement.
  • Act as a key point of contact between eastern Canada and the analytics teams across EU, North America and India, fostering collaboration and sharing of best practices.
  • Define and lead strategic initiatives for data and analytics, driving technical solutions that support the organization's growth objectives.
  • Develop and implement standardized analytics and BI best practices across all global locations ensuring consistency and excellence in analytics applications.
  • Oversee the creation and optimization of analytics and BI applications with a focus on the GlobalLink product line and broader strategic needs.

State Street Corporation provides asset management and custody banking services to institutional investors, including mutual funds and pension funds. Its division, State Street Global Advisors, manages investment portfolios and offers advisory services tailored to clients' financial goals. The company distinguishes itself through its commitment to innovation and promoting diversity and inclusion within its workforce. State Street aims to deliver high-quality financial services while fostering a supportive and inclusive culture.

Company Stage

IPO

Total Funding

N/A

Headquarters

Boston, Massachusetts

Founded

N/A

Growth & Insights
Headcount

6 month growth

-8%

1 year growth

-8%

2 year growth

-8%
Simplify Jobs

Simplify's Take

What believers are saying

  • State Street's strategic acquisitions, such as stakes in BWP Trust and Australian Clinical Labs, indicate robust growth and expansion opportunities.
  • The company's exploration of blockchain-based payment solutions, including stablecoin and token launches, positions it at the forefront of financial technology innovation.
  • State Street's strong leadership team, with recent high-profile appointments, underscores its commitment to maintaining a competitive edge in the industry.

What critics are saying

  • The competitive nature of the financial services industry requires State Street to continuously innovate to maintain its market position.
  • Regulatory challenges and compliance issues, especially with new ventures like stablecoin and token launches, could pose significant risks.

What makes State Street unique

  • State Street's focus on institutional investors, including mutual funds and pension funds, sets it apart from competitors who may target a broader audience.
  • The company's commitment to innovation, such as exploring stablecoin and token launches, demonstrates its forward-thinking approach in the financial services industry.
  • State Street's emphasis on diversity and inclusion, highlighted by initiatives like WomenInFinance, distinguishes it as a leader in fostering a supportive and inclusive workplace.

Help us improve and share your feedback! Did you find this helpful?