VP, Business Analytics Developer

SMBC; Charlotte (NC); Hybrid; USD 153,000 - 196,000; Full time

Job summary

SMBC in Charlotte, NC seeks a Senior Analytics Developer to design, develop, and implement comprehensive BI solutions using Power BI. You will work with stakeholders to gather requirements, analyze data, and deliver insights that drive informed decisions.

You will design end-to-end BI solutions, build data models, and optimize reports. You will mentor junior developers, provide production support, and stay current with BI trends to continually improve the analytics platform.

Qualifications

• 3-5 years’ experience as an analytics developer specializing in Power BI.
• Proficient in Power Query and DAX.
• Degree in IT or equivalent industry experience.
• Knowledge of analytics technologies and data modeling.
• Strong UI/Dashboard design sense.
• English communication skills.

Responsibilities

• Design and develop end-to-end BI solutions using Power BI, including data modeling and dashboards.
• Collaborate with stakeholders to translate requirements into technical specs for reports.
• Develop complex Power BI data models for accurate analysis and visualization.
• Perform data profiling to identify quality issues and address them with stakeholders.
• Create and maintain ETL processes to load data into Power BI from multiple sources.
• Optimize performance and usability of Power BI reports and dashboards.
• Ensure data security and access controls within Power BI.
• Collaborate to integrate Power BI with on-premises and cloud data sources.
• Stay updated with Power BI trends and apply them to enhance the solution.
• Mentor junior Power BI developers and provide production support for reports.

Skills

Power BI

Power Query

DAX

Data modeling

ETL

SQL / relational DB

English communication

Education

BSc / IT degree

Tools

Denodo

Azure

PowerApps

Power Automate

Data gateways

Tableau

Cognos

Job description

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.00and $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 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 [e-mail].