Data Analyst - Balance Sheet Analytics & Modeling, Entry Level

Jobright is an AI-powered career platform that helps job seekers discover the top opportunities in the US. We are NOT a staffing agency. Jobright does not hire directly for these positions. We connect you with verified openings from employers you can trust.

Job Summary:

PNC is a company that values its people as its greatest differentiator and competitive advantage. They are seeking a skilled Data Analyst to join their Balance Sheet Analytics & Modeling organization, where the primary responsibility will be to build and maintain data pipelines that enable data-driven decisions for marketing and customer analytics.

Responsibilities:

• Build, test, and maintain robust data pipelines and ETL/ELT processes to ingest, transform, and load data from various sources into our data warehouse.

• Collaborate with marketing and analytics teams to design and implement efficient data models that support reporting, ad-hoc analysis, and machine learning initiatives.

• Help design, manage and optimize our data infrastructure, including data warehouses, data lakes, and data orchestration tools.

• Implement processes and tools to ensure data accuracy, consistency, and reliability. Monitor data pipelines for issues and proactively resolve them.

• Optimize queries and data structures to improve the performance and efficiency of data access for analysts and data scientists.

• Partner with cross-functional teams, including product, engineering, and compliance, to ensure data is handled securely and in accordance with banking regulations.

• Stay current with the latest data engineering technologies and methodologies and propose new solutions to improve our data platform.

Qualifications:

Required:

• 2 years of experience as a Data Analyst, with a strong preference for experience in a marketing or financial services context.

• Strong proficiency in Python, SQL and Spark is essential.

• Hands-on experience with modern cloud data warehouses like Snowflake, Big Query, or Amazon Redshift.

• Experience building and managing ETL/ELT pipelines using tools like Apache Airflow, or similar technologies.

• Experience with at least one major cloud provider (AWS, or Azure).

• Solid understanding of data modeling principles (e.g., star schema, snowflake schema).

• Excellent problem-solving skills and attention to detail.

• Strong communication and interpersonal skills, with the ability to explain complex technical concepts to non-technical stakeholders.

• A proactive and collaborative attitude, with a passion for building data solutions that deliver real business value.

• Bachelor's degree in Computer Science, Engineering, Mathematics, or a related field.

• Experience with real-time data streaming technologies (e.g., Kafka, Kinesis).

• Familiarity with marketing platforms and their APIs (e.g., Adobe Analytics, Salesforce Marketing Cloud, Google Ads).

• Knowledge of machine learning concepts and experience building data pipelines for ML models.

• Familiarity with financial industry regulations and data security best practices.

Preferred:

• Analytical Thinking

• Competitive Advantages

• Data Analytics

• Data Mining

• Data Science

• Machine Learning

• Analytical Thinking

• Core Application Systems

• Data Administration

• Database Structures

• Data Warehousing

• Effective Communications

• Information Assurance

• Logical Data Modeling

• Query and Database Access Tools

• Requirements Analysis

Company:

PNC is a financial service company providing bank deposits products and services to its community. Founded in 1845, headquartered in Pittsburgh, Pennsylvania, USA, team size 10001 employees, currently Public Company.