Data and Integration Engineer

Position Overview

Job Description

TITLE: Data and Integration Engineer

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:

At Harris Williams, we believe in the power of data and analytics to help drive our competitive advantage in investment banking. The Data Warehouse and Lakehouse are critical platforms for the firm and are used across all departments to create business insights and are used in daily engagements to provide execution excellence for the firm’s clients.

The Data and Integration Engineer will be a key member of the Data Engineering team, reporting to the Data Architect. They will work closely with all aspects of the Technology team as well as all our internal stakeholders to ensure our data platform is built in a robust, consistent, and sustainable fashion.The Data and Integration Engineer will also be responsible for Application Integration Engineering, ensuring seamless integration between diverse SAAS systems and applications. Additionally the Data and Integration Engineer will provide engineering support in designing, building, and maintaining scalable data solutions while enabling efficient communication between diverse software systems.

Core Responsibilities:

Data Engineering and Analysis:

• Work with Product Owners to identify, analyze, and gather requirements
• Utilize the Azure data stack to enhance the Data Warehouse and Lakehouse
• Collect and integrate data from various sources, including SAAS application databases, APIs, and files
• Perform data analysis and cleaning to remove errors, duplicates, and inconsistencies
• Develop test cases to ensure accuracy, quality, and consistency of data for analytical workloads
• Deploy and manage objects through existing change management processes
• Independently manage own backlog of work and priorities
• Excellent problem-solving and troubleshooting abilities

Application Integration Engineering:

• Engineer integration solutions to connect diverse SAAS applications and data systems
• Build monitoring solutions to provide alerts and real-time status for application integrations
• Provide regular updates and maintenance on integration tools and platforms
• Coordinate with vendors to troubleshoot and resolve integration issues
• Utilize an integration platform such as Workato or MuleSoft for efficient system connectivity
• Maintain comprehensive documentation for integration processes and configurations

Competencies:

• Ability to work in a fast-paced environment and adapt quickly to changing business needs
• Record of being resourceful, a problem solver, and a proven self-starter
• Exceptional work ethic, with the ability to meet deadlines and execute efficiently
• Strong presentation skills and ease in communicating with both senior and junior colleagues
• Strong analytical skills and close attention to accuracy and detail
• Ability to synthesize complex data into datasets for actionable insights and recommendations

Job Specific Education and Experience:

• Bachelor’s degree in Computer Science, Information Systems, or equivalent field
• 3+ years of experience in data engineering technologies such as Azure Data Factory, Python, Synapse Analytics, Databricks, Azure Data Lake Store, Spark SQL, Fabric
• 3+ years of experience in NoSQL and Azure SQL DB or similar cloud database
• 2+ years of experience in Application Integration roles utilizing an integration platform such as Workato or MuleSoft
• Experience in ingesting csv and other text and non-structured data sources
• Preferred: Experience in short release cycles and the full software lifecycle
• Preferred: Experience in statistical modeling or machine learning approaches and tools

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

Analytical Thinking, Competitive Advantages, Data Analytics, Data Mining, Data Science, Machine Learning

Competencies

Application Design, Architecture, Business Intelligence, Data Architecture, Data Mining, Emerging Technologies, Informatics/Information Sciences, Information Management, IT Environment, Modeling: Data, Process, Events, Objects, Requirements Analysis

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 AccommodationRequest@pnc.com. 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.