Hybrid Data Analyst: SQL, Power BI & Data Pipelines

VetJobs; Cranberry Township (Butler County); Hybrid; USD 64,800 - 81,000; Full time

Benefits offered by this job

Comprehensive Medical benefits (health

Wellness Programs

401(k) with Company Match

Paid Vacations and Company Holidays

Flexible Work Arrangements

Educational Reimbursement

Global Recognition and Service

Employee Referral Program

Job summary

Westinghouse Electric Company is seeking a GSS Data Analyst to prepare data for BR&A reporting, with emphasis on data transformation, modeling, and automated ETL processes. You will interact with stakeholders, gather requirements, and implement analytical routines to support BI delivery.

The role reports to the Manager, SQL & Data Manager at the Cranberry Township, PA site and offers a hybrid work arrangement. Ideal candidates have 3+ years in a related field and strong SQL/Python/R skills.

Qualifications

• B.A., B.S. or equivalent business experience
• 3+ years experience in a similar role
• Knowledge of financial processes, controls, and associated improvement programs
• Familiarity with systems and data quality processes
• Knolwedge of relational databases
• Proficient in SQL, Python, R, Java, or any similar programming language
• Background knowledge of Databricks
• Proficiency in Power Platform (Power Automate, Power BI, Power Query)

Responsibilities

• Build robust data pipelines to support the gathering and transformation of data to be used by the BR&A and APX Project Management Office teams
• Support the APX Project Management Office by meeting with stakeholders and developing analytical processes to support Business Intelligence reporting
• Develop advanced queries to provide valuable data insight for the business
• Create and maintain data models in an efficient manner, maximizing the use of our data and our tools
• Develop automated programs for extracting, transforming, and loading data
• Assist in the administration of a central data lake to be used by the BR&A team
• Perform research and provide suggestions on technologies that could be used to boost the overall productivity of the BR&A team
• Protect the integrity of BR&A reporting data by continually monitoring for data cleanliness and quickly identifying and resolving issues

Skills

SQL

Python

R

Java

Relational databases

Data quality

Financial processes

Education

Bachelor's degree

Tools

Databricks

Power BI

Power Automate

Power Query

Job description

Westinghouse Electric Company is seeking a GSS Data Analyst to prepare data for BR&A reporting, with emphasis on data transformation, modeling, and automated ETL processes. You will interact with stakeholders, gather requirements, and implement analytical routines to support BI delivery.

The role reports to the Manager, SQL & Data Manager at the Cranberry Township, PA site and offers a hybrid work arrangement. Ideal candidates have 3+ years in a related field and strong SQL/Python/R skills.