Data Engineer
Data Engineer
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Position Overview
Job Description
TITLE: Data 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 areambitious in our goals andsteadfast in the belief that clientsdeserve our very best. To achieveour highestaspiration we invest inworldclass teamoriented individuals who are smart driven and principled those whoare eager to be part of something bigger than themselves. When you join Harris Williamsyou are welcomed intoa collegial environment where every individualhas the opportunity tomake an impact in a powerfulandsignificant 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 firms clients. The Data 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.
Core Responsibilities:
Data Engineering and Analysis for Firmwide Use
- 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
- Engineer integration solutions to connect diverse SAAS applications and data systems
- Deploy and manage objects through existing change management processes
- Independently manage own backlog of work and priorities
Competencies:
- Ability to work in a fastpaced environment and adapt quickly to changing business needs
- Record of being resourceful a problem solver and a proven selfstarter
- 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:
- Bachelors 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
- Experience in ingesting csv and other text and nonstructured 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 allinclusive 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 andHarris 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 LearningCompetencies
Analytical Thinking Core Application Systems Data Administration Database Structures Data Warehousing Effective Communications Information Assurance Logical Data Modeling Query and Database Access Tools Requirements AnalysisWork Experience
Roles at this level typically require a university / college degree with 2 years of relevant professional experience. In lieu of a degree a comparable combination of education job specific certification(s) and experience (including military service) may be considered.Education
BachelorsCertifications
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 fulltime employees include: medical/prescription drug coverage (with a Health Savings Account feature) dental and vision options; employee and spouse/child life insurance; short and longterm disability protection; 401(k) with PNC match pension and stock purchase plans; dependent care reimbursement account; backup 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 parttime employees visitYour PNC Total Rewards.
Disability Accommodations Statement
If an accommodation is required to participate in the application process please contact us via email at . 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 calland 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
Employment Type
Full-Time
