1

Power Query Jobs in Pennsylvania (NOW HIRING)

Power BI, Tableau, Power Query, Excel) (Required) * Knowledge of programming or data analysis languages (e.g. VBA, SQL, Python, SAS) (Required) Other Duties as Assigned by Manager This role may ...

Power BI, Tableau, Power Query, Excel) (Required) * Knowledge of programming or data analysis languages (e.g. VBA, SQL, Python, SAS) (Required) Other Duties as Assigned by Manager This role may ...

Power BI, Tableau, Power Query, Excel) (Required) * Knowledge of programming or data analysis languages (e.g. VBA, SQL, Python, SAS) (Required) Other Duties as Assigned by Manager This role may ...

Power BI, Tableau, Power Query, Excel) (Required) * Knowledge of programming or data analysis languages (e.g. VBA, SQL, Python, SAS) (Required) This role may perform other job duties as assigned by ...

Build and maintain Coatings-level reports and contribute to the Power BI dashboards and Power Query data pipelines used for management reporting, working hands-on with the underlying data rather than ...

FP&A Analyst

West Chester, PA · On-site

$40 - $45/hr

Leverage Excel, Power Query, and Power BI to improve reporting and analytics * Support month-end close, reconciliations, and financial reporting activities * Identify opportunities for process ...

Data Analyst

Bridgeport, PA · On-site

$70K - $85K/yr

Experience with DAX and Power Query (M) * Strong analytical thinking, problem-solving skills, and attention to detail Preferred Qualifications * Experience with Microsoft Fabric (lakehouses ...

FP&A Analyst

West Chester, PA · On-site

$40 - $45/hr

Manage large datasets and leverage Excel, Power Query, and Power BI to improve reporting efficiency. * Support month-end close activities, reconciliations, and financial reporting processes.

Showing results 41-60

Power Query information

What are the typical responsibilities of a Power Query?

As a professional specializing in Power Query, you are primarily responsible for connecting to diverse data sources, cleaning and transforming raw data, and building repeatable data workflows for reporting or analysis. You will often collaborate with business analysts, data engineers, and decision-makers to define requirements and ensure data accuracy. Managing and troubleshooting queries, optimizing data models, and documenting transformation steps are also key parts of the daily routine. This role typically involves a mix of independent problem-solving and teamwork within data or analytics departments.

Is there a certification for Power Query?

Power Query itself does not have a dedicated certification, but proficiency in Power Query is often demonstrated through certifications in related tools like Microsoft Excel or Power BI. Microsoft offers certifications such as the Microsoft Certified: Data Analyst Associate that cover Power Query skills as part of broader data analysis competencies.

What is a Power Query?

A Power Query job typically involves using Microsoft's Power Query tool to extract, transform, and load (ETL) data from different sources into Excel or Power BI. Professionals in this role clean, reshape, and automate data processing to improve efficiency and decision-making. They may work with business analysts, data analysts, or finance teams to streamline reporting and analytics. Strong knowledge of M language, Power BI, and Excel is often required.

What are the key skills and qualifications needed to thrive in a Power Query role?

To excel in Power Query roles, you need strong skills in data transformation, advanced Excel or Microsoft Power BI knowledge, and experience with M language scripting. Familiarity with data integration tools, Power Query-specific functions, and potentially relevant certifications like Microsoft Certified: Data Analyst Associate are important. Analytical thinking, problem-solving, and clear communication with stakeholders are valuable soft skills for success in this field. These capabilities ensure efficient processing of complex data sets and effective collaboration to drive data-informed decisions.

Is Power Query a valuable skill?

Power Query is a valuable skill for data analysts and professionals working with data transformation and automation in Excel and Power BI. Proficiency in Power Query can improve efficiency and is often sought after in roles involving data management and reporting. Learning this tool can enhance job prospects in data-related fields.

What are the most commonly searched types of Power Query jobs in Pennsylvania?

The most popular types of Power Query jobs in Pennsylvania are:

Infographic showing various Power Query job openings in Pennsylvania as of August 2026, with employment types broken down into 82% Full Time, 14% Part Time, 2% Contract, and 2% Nights. Highlights an 91% Physical, 3% Hybrid, and 6% Remote job distribution.

Senior Finance AI & Automation Developer

EnerSys

Reading, PA • On-site, Remote

$95K - $119K/yr

Full-time

Medical, Dental, Vision, Life, Retirement, PTO

Re-posted 11 days ago


EnerSys rating

7.7

Company rating: 7.7 out of 10

Based on 55 frontline employees who took The Breakroom Quiz

200th of 538 rated manufacturers


Job description

EnerSys is a global leader in stored energy solutions for industrial applications. We have over thirty manufacturing and assembly plants worldwide servicing over 10,000 customers in more than 100 countries. Worldwide headquarters are located in Reading, PA, USA with regional headquarters in Europe and Asia. We complement our extensive line of Motive Power and Energy Systems with a full range of integrated services and systems. With sales and service locations throughout the world, and over 100 years of battery experience, EnerSys is the power/full solution for stored DC power products. 

What We're Offering

  • Paid time off plus paid holidays
  • Medical/dental/vision insurance plan
  • Life insurance, short/long term disability, tuition reimbursement, flex spending, and employee stock purchase plan
  • 401K plan
  • Culture: We value and strive for excellence in all that we do through innovative technology by creating long lasting relationships with our stakeholders, co-workers, and customers. We continually strive to foster teamwork, engagement and enhance our employee's skills and competence by providing appropriate training.

Compensation Range: $95,300.00 - $119,100.00 

Compensation may vary based on applicant's work experience, education level, skill set, and/or location.  

Work Arrangement: Hybrid (Reading, PA) or Remote

Hybrid Schedule for Local Candidates:

  • Monday & Friday: Remote

  • Tuesday-Thursday: Onsite at our Reading, PA location

Candidates outside the Reading, PA area may be considered for a fully remote arrangement.

Job Purpose

The Senior Finance AI & Automation Developer's primary responsibilities are to design, build, & deploy automation and AI-driven solutions across Finance processes. These projects will require project leadership and coordination with cross-functional departments. This role sits at the intersection of Finance, Technology, and Process Improvement and focuses on eliminating manual work, accelerating reporting cycles, and enabling scalable, intelligent workflows across the Finance organization. The role will partner with finance teams to map current processes, identify automation opportunities, and redesign workflows to reduce manual effort and cycle time. This position will deploy solutions into production environments, validate outputs with stakeholders and coordinate with IT for access, infrastructure, & governance. The position will also monitor performance of automations & AI solutions as well as identify additional use cases and scale successful pilots. Responsibilities may also include other adhoc tasks such as Value Stream analysis and Finance SharePoint Administration, etc. 

Essential Duties and Responsibilities
  • Design and Build Automation Solutions
  • Transformation Project Leadership
  • Power BI, Power Automate, & Power Query Projects
  • AI Agent & Chatbot Projects
  • AI Workflow Projects
  • Predictive Modeling Projects
  • Educate Finance Team about AI Applications & Tools
  • Project Documentation and Change Management
  • Finance SharePoint Site Administration
  • Ad Hoc Projects & Tasks
 
SUPERVISORY RESPONSIBILITIES: No direct reports but will lead projects
Qualifications
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
 
Education and/or Experience:
  • Bachelors' degree in Engineering, Technology field, and/or Finance or equivalent
  • Project Management experience required
  • Digital Process Automation experience required
  • AI workflow experience required
  • AI Agent creation experience required
  • App building experience required (personal and/or professional)
  • AI-generated coding experience required (i.e. Claude Code, Codex)
  • Azure experience required
  • Strong understanding of data structure and APIs required
  • Experience with Python and/or other code languages required
  • 6 Sigma Black Belt certification preferred  
  • Lean methodology experience preferred
  • Strong IT skills including proficiency with Microsoft Office applications; enterprise resource planning systems (i.e., SAP), etc. 
  • Power BI, Power Automate, & Power Query experience preferred
  • 3-5 Years of relevant experience or equivalent based on project volume and scope
 
Other Skills:
  • Creative in finding solutions and overcoming obstacles
  • Initiative: Aggressive while using good judgment
  • Skilled with data management & project completion
  • Ability to present findings and data to different audiences up to the Executive level
  • Team player while also excelling as an individual contributor.
  • Fast learner with strong analytical and problem-solving skills.
  • Able to successfully manage multiple projects and tasks with various deadlines.
  • Articulate, Positive & Outgoing communicator
  • Optimistic change agent that stays on the cutting edge of technology and technical requirements.
  • Curious: willing to ask questions and learn
  • Highly motivated
  • Adaptable to change
  • Exhibit a servant attitude toward colleagues and internal customers
General Job Requirements
  • This position will work in an office setting, expect minimal physical demands.

EnerSys provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.  

Know Your Rights

Know Your Rights (Spanish)

We use artificial intelligence to screen, assess and select applicants for open positions, including for the purposes of reviewing and ranking application materials and scoring answers to application questions. Accordingly, decisions about your application and eligibility for employment with EnerSys may be made based exclusively on the automated processing of the personal information that you submit in your application materials.


What EnerSys employees say

Pay

Benefits

Hours and flexibility

Workplace

Get the full story on Breakroom