VP, Business Analytics Developer

SMBC Group; Charlotte (NC); Ibrido; USD 153.000 - 196.000; Tempo pieno

Descrizione del lavoro

SMBC Group is seeking a Power BI / Analytics Developer in Charlotte, NC. The role focuses on designing and delivering end-to-end BI solutions using Power BI, data modeling, and integration across on-premises and cloud sources.

Responsibilities include collaborating with stakeholders, developing complex data models, profiling data quality, and ensuring security controls. Hybrid work arrangement with potential discretionary incentives; strong English communication required.

Competenze

• 3-5 years' experience as an analytics developer specializing in Power BI.
• Proficient in Power Query and DAX for data modeling.
• Degree in IT or related field, or equivalent industry experience.
• Strong understanding of relational and dimensional databases.

Mansioni

• 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.
• Profile data to identify quality issues and coordinate fixes with stakeholders.
• Create and maintain data connections and ETL processes to load data into Power BI.
• Optimize performance and usability of BI reports and dashboards.
• Ensure data security and access controls within Power BI.
• Integrate Power BI with on-premises and cloud systems.
• Stay updated with BI trends and apply improvements to the solution.
• Mentor junior Power BI developers and provide guidance.
• Provide production support for reports and schedules across EMEA and North America.
• Train end users to build analytics and reporting capabilities.

Conoscenze

Power BI experience

English communication

Formazione

Degree in IT or related field

Strumenti

Power Query

DAX

Azure

PowerApps

Power Automate

Denodo

APIs

Power BI on-prem gateways

Tableau

Descrizione del lavoro

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

• 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 [e-mail].