VP, Business Analytics Developer

Job Level: Vice President

Job Function: Technical Product Management

Location:

Charlotte, NC, US, 28202

Employment Type: Full Time

Requisition ID: 8543

SMBC Group is a top-tier global financial group. Headquartered in Tokyo and with a 400-year history, SMBC Group offers a diverse range of financial services, including banking, leasing, securities, credit cards, and consumer finance. The Group has more than 130 offices and 80,000 employees worldwide in nearly 40 countries. Sumitomo Mitsui Financial Group, Inc. (SMFG) is the holding company of SMBC Group, which is one of the three largest banking groups in Japan. SMFG’s shares trade on the Tokyo, Nagoya, and New York (NYSE: SMFG) stock exchanges.

In the Americas, SMBC Group has a presence in the US, Canada, Mexico, Brazil, Chile, Colombia, and Peru. Backed by the capital strength of SMBC Group and the value of its relationships in Asia, the Group offers a range of commercial and investment banking services to its corporate, institutional, and municipal clients. It connects a diverse client base to local markets and the organization’s extensive global network. The Group’s operating companies in the Americas include Sumitomo Mitsui Banking Corp. (SMBC), SMBC Nikko Securities America, Inc., SMBC Capital Markets, Inc., JRI America, Inc., SMBC Leasing and Finance, Inc., Banco Sumitomo Mitsui Brasileiro S.A., and Sumitomo Mitsui Finance and Leasing Co., Ltd.

The anticipated salary range for this role is between $153,000.00 and $196,000.00. The specific salary offered to an applicant will be based on their individual qualifications, experiences, and an analysis of the current compensation paid in their geography and the market for similar roles at the time of hire. The role may also be eligible for an annual discretionary incentive award. In addition to cash compensation, SMBC offers a competitive portfolio of benefits to its employees.

Role Description

Power BI / Analytics Developer

We are looking for a Senior Analytics Developer who will be responsible for designing, developing, and implementing comprehensive business intelligence solutions using Microsoft Power BI. You will work closely with business stakeholders to gather requirements, analyze data, and deliver actionable insights to drive informed decision-making.

Core Responsibilities

Design and develop end-to-end business intelligence solutions using Microsoft Power BI, including data modeling, data integration, and report/dashboard creation.
Collaborate with business stakeholders to understand their requirements, translate them into technical specifications, and design efficient and visually appealing Power BI reports and dashboards.
Develop complex Power BI data models to enable accurate and efficient data analysis and visualization.
Conduct data profiling and analysis to identify data quality issues, inconsistencies, and anomalies, and work with stakeholders to address them.
Create and maintain data connections and ETL processes to extract, transform, and load data from various sources into Power BI.
Optimize performance and usability of Power BI reports and dashboards by tuning queries, implementing efficient data models, and applying best practices.
Ensure data security and compliance standards are met by implementing appropriate security measures and access controls within Power BI.
Collaborate with stakeholders to integrate Power BI with other systems and data sources, including on-premises and cloud-based platforms.
Stay up to date with the latest trends and advancements in Power BI and related technologies, and proactively apply them to enhance the overall BI solution.
Mentor and provide technical guidance to junior Power BI developers, assisting them in solving complex problems and improving their skills.
Production Support of reports, dashboards, and schedules for EMEA and North American user base
Train and support end users, as well as self-service capabilities to help non-technical business users build their own analytics and reporting solutions

Qualifications and Skills

3 - 5 years’ experience as an analytics developer specializing in Power BI
Proficient in utilizing Power Query and DAX
Educated to degree level preferably in an IT-related discipline, or with significant industry experience
Knowledge of, and a willingness and ability to adapt to new analytics technologies
A very strong understanding of relational and dimensional databases and an ability to query databases to troubleshoot issues in reporting
A flair for clean User Interface / Dashboard design principles
Ability to absorb & present complex ideas quickly & accurately
Ability to provide solutions to a tight deadline
Good prioritization and time management
A positive approach to work and to fellow team members
Excellent written and verbal English communication skills
Attention to detail in all aspects of working life

Preferred Qualifications:

Experience using Denodo is a plus
Experience utilizing APIs
Experience with Cloud based platforms (Preferably Azure) is a plus
Nice to have exposure to PowerApps and Power Automate
Hands on experience with Power BI on-premises enterprise data gateways
Experience with other BI tools (Tableau, Cognos) is a plus

SMBC’s employees participate in a Hybrid workforce model that provides employees with an opportunity to work from home, as well as, from an SMBC office. SMBC requires that employees live within a reasonable commuting distance of their office location. Prospective candidates will learn more about their specific hybrid work schedule during their interview process. Hybrid work may not be permitted for certain roles, including, for example, certain FINRA-registered roles for which in-office attendance for the entire workweek is required.

SMBC provides reasonable accommodations during candidacy for applicants with disabilities consistent with applicable federal, state, and local law. If you need a reasonable accommodation during the application process, please let us know at accommodations@smbcgroup.com.