Position Overview

Job Description

TITLE: BUSINESS INTELLIGENCE SOLUTIONS ARCHITECT AND PRODUCT OWNER

We are a global investment bank specializing in M&A and private capital advisory services. Clients worldwide rely on us to help unlock value in their business and turn ambitious goals into reality. We approach every engagement with boundless collaboration, pooling expertise and relationships across industries, service offerings, and geographies. For over 30 years, our clients have trusted us to think strategically, execute precisely, and deliver premium outcomes to help them grow.

We are ambitious in our goals and steadfast in the belief that clients deserve our very best. To achieve our highest aspiration, we invest in world-class, team-oriented individuals who are smart, driven, and principled – those who are eager to be part of something bigger than themselves. When you join Harris Williams, you are welcomed into a collegial environment where every individual has the opportunity to make an impact in a powerful and significant way. We invite you to learn more about careers at Harris Williams. 

Core Competencies:

Within Harris Williams IT, the Business Intelligence Solutions Architect and Product Owner role will help drive our competitive advantage in investment banking execution by differentiating with Business Intelligence. The Business Intelligence Solutions Architect and Product Owner will be a key member of the Data Engineering team, accountable for all internal HW reporting, and will have product ownership of the Microsoft Power BI platform.

As a critical platform for the firm, Power BI is used across all departments to create business insights and is used in daily engagements to provide execution excellence for the firm’s clients. This individual will manage the Business Intelligence product backlog and provide Power BI coaching to the firm. The Business Intelligence Solutions Architect and Product Owner will be a part of the Information Technology team, reporting to the Data Science Team Lead. They will work closely with all aspects of the Technology team as well as all our internal stakeholders to ensure our reporting is done in a robust, consistent, and sustainable fashion.

Core Responsibilities:

Strategic Business Intelligence Product Owner

• Collaborate closely with business users across different departments to understand their data needs
• Collaborate with stakeholders to gather and translate business requirements into technical specifications and actionable roadmaps
• Define and maintain the product vision, roadmap, and priorities for the BI platform, ensuring alignment with organizational goals
• Manage the BI product backlog, prioritizing features based on business value and stakeholder input
• Partner with Product Owners to integrate the technical priorities into an overall integrated roadmap for the platform

Business Intelligence Solutions Architect

• As a key member of the Data Engineering team, the Business Intelligence Solutions Architect and Product Owner will work under the direction of the Data Science Team Lead
• Engage with program/process owners, stakeholders, and business partners as necessary to communicate the objectives, strategy, tactics, and ongoing progress of the Business Intelligence Engineering team
• Design and implement scalable, efficient BI solutions using Power BI, ensuring alignment with enterprise data strategies
• Ensure current technical knowledge of the platform including existing products, new introductions and deprecations
• Collaborate with the Data Engineering and Software Engineering teams to ensure platform interoperability within the broader firm ecosystem
• Proven success designing sustainable Business Intelligence solutions, optimizing performance and driving successful project completion
• Provide architecture, configuration, administration, and functional support to expand capabilities in Power BI Service
• Design end-to-end solutions that improve collaboration, productivity, and knowledge sharing amongst the Power BI community

Data Visualization and Reporting

• Design and guide the development of intuitive dashboards, reports, and semantic models to deliver actionable insights
• Partner with UX experts to optimize report usability and accessibility, ensuring alignment with analytics goals
• Build re-usable artifacts within Power BI to support self-service reporting
• Maintain existing reports and manage the daily support of tools
• Identify high usage reports and overlapping requirements and requests
• Adapt, promote, and certify self-service reports for the enterprise

Competencies

• Communication Skills: Exceptional presentation and communication abilities, with ease in engaging both senior and junior colleagues
• Adaptability: Capacity to thrive in a fast-paced environment and adapt to changing business needs
• Product Ownership: Strong skills in backlog management, roadmap development, and stakeholder collaboration
• Technical Expertise: Proven ability to design and implement scalable BI architectures and solutions
• Analytical Thinking: Ability to synthesize complex data into actionable insights and recommendations

Job Specific Education and Experience:

• Bachelor’s degree in Computer Science, Information Systems, or equivalent field
• 4+ years of experience in Power BI / Power BI Paginated or 5+ years combined experience in Power BI / Tableau
• 5+ years of experience in SQL Server or Azure SQL DB
• 3+ years of experience in Agile methodology
• Experience in querying or designing dimensional data warehouse models
• Experience in developing Power BI data sets
• Experience in data governance and master data processes
• Experience with tools like DAX studio/Tabular Editor/ALM toolkit/SSRS is beneficial
• Experience with Kimball (Dimensional) Models
• Experience with complex data modeling
• Preferred: Experience in statistical modeling or machine learning approaches and tools

In order to be considered, you must be able to work in the U.S. without sponsorship.

This description reflects the core activities of the role but is not intended to be all-inclusive and other duties within

the group/department may be required in addition to changes in the emphasis of duties as required from time to time.

Disclaimer: Harris Williams will not accept unsolicited resumes from contingency recruiters. Any such resumes received will not be considered as legitimate submissions, and Harris Williams will not pay for the placement of a candidate resulting from the receipt of an unsolicited resume. Furthermore, Harris Williams strictly forbids any contingency recruiter from representing the firm in the market without prior consent

Qualifications

Successful candidates must demonstrate appropriate knowledge, skills, and abilities for a role. Listed below are skills, competencies, work experience, education, and required certifications/licensures needed to be successful in this position.

Preferred Skills

Competitive Advantages, Customer Solutions, Design, Enterprise Architecture Framework, Machine Learning, Risk Assessments, Technical Knowledge

Competencies

Application Delivery Process, Consulting, Effectiveness Measurement, Industry Knowledge, IT Industry: Trends & Directions, IT Standards, Procedures & Policies, Planning: Tactical, Strategic, Problem Solving

Work Experience

Roles at this level typically require a university / college degree, with 3+ years of relevant / direct industry experience. Certifications are often desired. In lieu of a degree, a comparable combination of education, job specific certification(s), and experience (including military service) may be considered.

Education

Bachelors

Certifications

No Required Certification(s)

Licenses

No Required License(s)

Benefits

PNC offers a comprehensive range of benefits to help meet your needs now and in the future. Depending on your eligibility, options for full-time employees include: medical/prescription drug coverage (with a Health Savings Account feature), dental and vision options; employee and spouse/child life insurance; short and long-term disability protection; 401(k) with PNC match, pension and stock purchase plans; dependent care reimbursement account; back-up child/elder care; adoption, surrogacy, and doula reimbursement; educational assistance, including select programs fully paid; a robust wellness program with financial incentives.

In addition, PNC generally provides the following paid time off, depending on your eligibility: maternity and/or parental leave; up to 11 paid holidays each year; 8 occasional absence days each year, unless otherwise required by law; between 15 to 25 vacation days each year, depending on career level; and years of service.

To learn more about these and other programs, including benefits for full time and part-time employees, visit Your PNC Total Rewards.

Disability Accommodations Statement

If an accommodation is required to participate in the application process, please contact us via email at [email protected]. Please include “accommodation request” in the subject line title and be sure to include your name, the job ID, and your preferred method of contact in the body of the email. Emails not related to accommodation requests will not receive responses.  Applicants may also call 877-968-7762 and say "Workday" for accommodation assistance. All information provided will be kept confidential and will be used only to the extent required to provide needed reasonable accommodations.

At PNC we foster an inclusive and accessible workplace.  We provide reasonable accommodations to employment applicants and qualified individuals with a disability who need an accommodation to perform the essential functions of their positions.

Equal Employment Opportunity (EEO)

PNC provides equal employment opportunity to qualified persons regardless of race, color, sex, religion, national origin, age, sexual orientation, gender identity, disability, veteran status, or other categories protected by law.

This position is subject to the requirements of Section 19 of the Federal Deposit Insurance Act (FDIA) and, for any registered role, the Secure and Fair Enforcement for Mortgage Licensing Act of 2008 (SAFE Act) and/or the Financial Industry Regulatory Authority (FINRA), which prohibit the hiring of individuals with certain criminal history.

California Residents

Refer to the California Consumer Privacy Act Privacy Notice to gain understanding of how PNC may use or disclose your personal information in our hiring practices.