Data Analyst - Balance Sheet Analytics & Modeling, Entry Level

Jobright.ai; Pittsburgh (Allegheny County); On-site; USD 45,000 - 95,100; Full time

Benefits offered by this job

Medical insurance

Vision insurance

401(k)

Job summary

A financial services company is seeking an entry-level Data Analyst to join their Balance Sheet Analytics team in Pittsburgh. You will build and maintain data pipelines, collaborate with different teams, and ensure data integrity. Ideal candidates will possess strong skills in Python and SQL, along with a relevant bachelor's degree. This role offers a salary range from $45,000 to $95,100.

Qualifications

• 2+ years of experience as a Data Analyst, ideally in a marketing or financial services context.
• Strong communication skills to explain complex technical concepts.
• Experience with data streaming technologies such as Kafka.

Responsibilities

• Build, test, and maintain robust data pipelines and ETL/ELT processes.
• Collaborate with cross-functional teams to design data models.
• Ensure data accuracy, consistency, and reliability.

Skills

Python

SQL

Spark

Data modeling

Analytical Thinking

ETL processes

Education

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

Tools

Snowflake

Amazon Redshift

Apache Airflow

Job description

Data Analyst - Balance Sheet Analytics & Modeling, Entry Level

Join to apply for the Data Analyst - Balance Sheet Analytics & Modeling, Entry Level role at Jobright.ai

Data Analyst - Balance Sheet Analytics & Modeling, Entry Level

1 day ago Be among the first 25 applicants

Join to apply for the Data Analyst - Balance Sheet Analytics & Modeling, Entry Level role at Jobright.ai

Get AI-powered advice on this job and more exclusive features.

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

• Analytical Thinking

• Data Warehousing

• Query and Database Access Tools

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.

Seniority level

• Seniority level

  Entry level

Employment type

• Employment type

  Full-time

Job function

• Industries

  Software Development

Referrals increase your chances of interviewing at Jobright.ai by 2x

Inferred from the description for this job

Medical insurance

Vision insurance

401(k)

Get notified about new Data Analyst jobs in Pittsburgh, PA.

Data Analyst - Balance Sheet Analytics & Modeling

Pittsburgh, PA $45,000.00-$95,100.00 2 days ago

Data Analyst - Balance Sheet Analytics & Modeling

Pittsburgh, PA $45,000.00-$95,100.00 2 days ago

Entry Level Data Analyst, application via RippleMatch

Data Analyst Intern, application via RippleMatch

Pittsburgh, PA $68,000.00-$74,000.00 4 weeks ago

Pittsburgh, PA $101,000.00-$162,000.00 6 days ago

Quantitative Analytics Undergraduate Intern

Data Analyst - Balance Sheet Analytics & Modeling, Entry Level

Data Analyst Senior - C&IB Data Management (SQL, STM-Source to Target Mapping)

Pittsburgh, PA $55,000.00-$148,460.00 1 week ago

Data Analytics Development Program Analyst/Associate

Engineer, Data Visualization and Business Intelligence

Power Platform Sr. Analyst - Greater Pittsburgh, PA ONLY!

Pittsburgh, PA $55,000.00-$131,300.00 3 weeks ago

Quantitative Analytics Development Program Analyst/Associate

Sports Data Entry Contractor – Get Paid to Attend NFL or MLB Games

Business Systems Analyst Consultant - Python/Jira/Data Visualization

Pittsburgh, PA $55,000.00-$105,000.00 2 weeks ago

Financial Data Analyst - Finance Division

Pittsburgh, PA $55,000.00-$157,300.00 4 days ago

Pittsburgh, PA $55,000.00-$132,500.00 3 weeks ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.