Utilize SQL, SAS, or other programming languages to extract and analyze data for monthly reporting, business cases, ad hoc analyses, and data research initiatives.
Modify existing code and develop new processes to support evolving data needs and improve efficiency.
Present data effectively through Tableau, Excel, and SQL, ensuring optimal performance with large and complex datasets.
Collaborate with data analysts, modelers, and cross-functional finance teams to enhance data capabilities, share best practices, and recommend data field improvements.
Develop dynamic financial models to support business cases and inform strategic decision-making.
Identify opportunities to streamline processes, improve scalability, and increase automation.
Implement and maintain strong data controls, validation processes, and quality checks to ensure data integrity.

Strong financial and analytical skills, including knowledge of accounting, Excel, financial modeling, and data analysis
Proficiency in SQL, SAS, or similar programming languages
Experience with data visualization tools such as Tableau and Excel
Strong problem-solving skills, with the ability to break down complex coding challenges and data gaps
Demonstrated ability to collaborate effectively in a team environment
Strong communication skills, with the ability to clearly explain concepts, methodologies, and findings
Highly detail-oriented, with a focus on accuracy and maintaining data integrity.
2+ years of relevant professional experience

health insurance, 401(k) with PNC match, pension
comprehensive range of benefits for full-time employees including 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
dependent care reimbursement account
back-up child/elder care
adoption, surrogacy, and doula reimbursement
educational assistance, including select programs fully paid
robust wellness program with financial incentives
paid time off including maternity and/or parental leave, up to 11 paid holidays each year, 9 occasional absence days each year, between 15 to 25 vacation days each year depending on career level and years of service

Business Analytics Consultant

Key skills