Power Query

Power Query Data Jobs

4 jobs found

1d ago

Data Analyst

Avantor Rensselaer, NY

Rensselaer, NY

1d ago

$63k - $101k/yr Full time Analyst Analytics Business Analytics

Apply Now

Job Description

A Data Analyst role within Avantor's Advanced Laboratory Services in Rensselaer, NY, offers a hybrid work arrangement and centers on analyzing inventory and operational data, building dashboards, and delivering data-driven insights to enhance procurement and supply chain performance.

Responsibilities

Examine and interpret complex data sets related to inventory, procurement, and operations to inform decisions and boost performance.
Create and maintain Power BI dashboards, automated reports, data models, and KPI tracking tools.
Monitor inventory health, supplier performance, service levels, stock availability, and operational metrics, while identifying trends, risks, and opportunities for improvement.
Refine inventory strategies through demand planning, PAR level analysis, replenishment modeling, and reduction of excess or obsolete inventory.
Uphold data integrity through governance, auditing, validation, and exception-based reporting processes.
Assess workload and capacity to optimize staffing, resource planning, and organizational growth.
Lead process-improvement efforts by automating reporting, enhancing data quality, and deploying scalable operational solutions.
Collaborate cross-functionally with operations, procurement, quality, finance, IT, and customer stakeholders to translate business needs into actionable insights and decision-support tools.
Present findings, recommendations, and business cases to leadership while supporting audits, compliance requirements, and continuous improvement initiatives.

Requirements

Three or more years of experience in data analytics, business intelligence, inventory management, supply chain, procurement, or related operational environments.
Proven ability to analyze inventory, purchasing, order management, and operational performance data to drive business decisions.
Advanced proficiency in Microsoft Excel, including PivotTables, Power Query, complex formulas, and large dataset analysis.
Experience developing Power BI dashboards, data models, KPI reporting, and automated operational reports.
Working knowledge of SQL; experience with Snowflake, SAP, ERP, inventory management, or similar business systems is preferred.
Skilled in integrating and validating data from multiple sources while ensuring data accuracy and integrity.
Experience creating KPIs, forecasting models, exception reporting, and actionable business recommendations.
Strong understanding of data governance, master data management, reporting controls, and data quality standards.
Excellent analytical, problem-solving, communication, and stakeholder management skills.
Ability to present complex data insights to both technical and non-technical audiences.
Demonstrated ability to prioritize multiple projects, meet deadlines, and work independently in a regulated, customer-focused environment.
Detail-oriented with a strong commitment to accuracy, compliance, and continuous improvement.
Experience supporting audits, process improvement initiatives, and operational reporting is preferred.
Self-driven, adaptable, and proactive in identifying opportunities to improve processes and business outcomes.
Education: High school diploma or GED.

Technologies

Microsoft Excel
Power BI
Power Query
SQL
Snowflake
SAP
ERP

Benefits

Comprehensive medical, dental, and vision coverage
Wellness programs
Eligible for medical coverage starting Day 1
Paid Time Off (PTO)
Company-paid holidays
Choice holidays
Flexible Spending Account (FSA) and Health Savings Account (HSA)
Commuter benefits
401(k) retirement plan
Tuition assistance
Employee Stock Purchase Plan discount

Pay Transparency

The expected pre-tax pay for this position is $62,500.00 - $100,625.00
Actual pay may differ depending on relevant factors such as prior experience and geographic location.

View full job page →

18d ago

Financial Data Analyst (Manufacturing Exp. Req'd)

Biter & Associates, LLC Lawrenceville, GA

Lawrenceville, GA

18d ago

$98k - $102k/yr Full time Analyst Analytical Skills Analytics

Apply Now

Job Description

On-site, full-time Financial Data Analyst supporting forecasting, budgeting, and strategic decision-making by collecting, validating, and analyzing financial and operational data for a manufacturing and oil and gas focused client in Lawrenceville, GA.

Responsibilities

Collect, validate, and analyze financial and operational data to support forecasting, budgeting, and strategic decision-making.
Prepare recurring and ad hoc reports, build dashboards, and develop data models to identify trends, variances, and performance drivers.
Collaborate with finance and business stakeholders to define data requirements.
Perform data reconciliation and quality checks.
Present findings in clear, actionable formats.
Assist in improving reporting processes, document methodologies, and support special projects such as cost analysis, profitability studies, and scenario modeling.

Requirements

This is an in-office position.
Bachelor’s degree required.
Minimum 3 years of relevant experience.
Decipher corporate data and tool standards into practical guidance for local business areas to ensure consistent and accurate data usage.
Strong analytical skills with the ability to interpret complex datasets and translate findings into practical business insights.
Design and maintain standardized processes for analytics, reporting, and data quality management.
Supervise master data quality and collaborate with business owners to align with corporate standards and local requirements.
Confirm data is consistent, accurate, and trusted across systems so reporting remains dependable and operational issues are minimized.
Partner with business leaders to define analytical requirements, create ad-hoc reports, and dashboards to support KPI.
Leverage relevant data sources and performing advanced analytical modeling using large datasets to support strategic decision-making.
Lead productivity initiatives to support the automation of manual data processes including customizing global Power BI reports to support local needs and working with the IT team to migrate external reports to workspaces within the ERP system.
Interpret complex data into clear insights that directly influence forecasting, planning, cost management, and operational improvement.
Collaborate with the North American IT and the Global Digital Performance organization to evaluate current landscape, enhance artificial intelligence capabilities, and support financial data transitions on ERP upgrades.
Develop AI Agents (Copilot) to streamline and automate local business processes.
Advance digital capabilities that reduce manual effort, improve data accuracy, and modernize reporting tools across the business.
Provide oversight, training and first level support for business users using Power BI, Excel (including working with advanced functions and macros) and other analytical tools.
Collaborate across Finance, Sales, Operations, and IT functions to ensure alignment on analytics and reporting solutions.
Other duties as assigned.

Technologies

Power BI
Excel
VBA
Macros
Tableau
SQL
Power Query
DAX
Copilot
ERP system

Benefits

401(k)
Dental insurance
Health insurance
Life insurance
Paid time off
Vision insurance

Pay

Salary: USD 98,488 - 102,437 per year.

Work Location

In person, Lawrenceville, GA

View full job page →

1mo ago

HRIS Specialist & Data Analyst

Great Day Improvements: A Family of Brands Twinsburg, OH

Twinsburg, OH

1mo ago Closed

$70k - $75k/yr Full time ADP Adp Workforce Now Analyst

This position is no longer accepting applications (closed Aug 1, 2026).

Job Description

The HRIS Specialist and Data Analyst role in Twinsburg, OH (hybrid) offers $70,000 to $75,000 per year and centers on administering ADP Workforce Now and Workforce Manager, maintaining employee data and timekeeping configurations, and delivering dashboards and insights to inform HR, Finance, and Operations.

Responsibilities

Maintain and update employee records in ADP Workforce Now with accuracy, completeness, and proper effective dating.
Process full lifecycle transactions including hires, terminations, transfers, job changes, compensation updates, and status changes.
Manage position management structures and organizational hierarchies to ensure payroll accuracy and reliable reporting.
Conduct routine audits of employee data including tax elections, direct deposit, accrual balances, and earnings configurations.
Monitor data integrity and proactively correct discrepancies.
Administer Workforce Manager including timekeeping profiles, pay codes, schedules, accruals, attendance rules, and work rules.
Maintain attendance tracking and point systems aligned with company policy.
Validate timekeeping configurations in line with FLSA, overtime rules, and state wage laws.
Identify configuration gaps and propose improvements to reduce errors and manual interventions.
Monitor integrations between Workforce Manager, Workforce Now, and external vendors.
Troubleshoot interface failures, data mapping issues, and transmission errors.
Coordinate with vendors and IT teams to resolve system or connectivity issues.
Support system upgrades, patches, testing, and implementation initiatives.
Participate in user acceptance testing and validation of configuration changes.
Ensure configurations support compliance with federal, state, and local employment regulations.
Support new hire reporting, tax setup validation, and regulatory requirements.
Maintain audit-ready documentation and system records.
Assist with internal and external audits related to payroll, timekeeping, and HRIS controls.
Support year-end payroll processes including W-2 and applicable reporting.
Design, generate, analyze, and distribute standard and ad-hoc HRIS, payroll, and workforce analytics reports.
Build and maintain workforce dashboards and data visualizations using Power BI, Tableau, or Excel to surface trends in headcount, turnover, compensation, and labor costs.
Partner with HR, Finance, and business leaders to define data requirements, translate analytical needs into structured queries, and deliver insights that support workforce planning and decision-making.
Validate data accuracy used in leadership reporting and ensure outputs are reconciled against source systems before distribution.
Develop and maintain data models, predictive analytics, and trend analyses that support workforce planning and organizational effectiveness.
Apply data cleansing, transformation, and quality assurance best practices to ensure HR datasets are reliable and analytics-ready.
Maintain role-based system security and user access permissions.
Support access reviews and ensure proper system authorization controls.
Maintain documentation for workflows, configuration standards, and SOPs.
Support enterprise data governance standards and naming conventions.
Assist in maintaining data dictionaries and system field definitions.
Serve as HRIS subject matter resource for managers and HR partners; provide guidance on navigation, data entry, and reporting tools.
Identify process inefficiencies and recommend solutions to strengthen controls and improve efficiency.
Collaborate cross-functionally to support system and reporting initiatives.

Requirements

Strong working knowledge of ADP Workforce Now, including employee lifecycle processing, position management, organizational structure maintenance, effective-dated transactions, and HRIS data integrity.
Working knowledge of ADP Workforce Manager or similar timekeeping systems, including pay codes, schedules, accruals, attendance rules, work rules, and system integrations.
Understanding of payroll, timekeeping, and employment compliance fundamentals, including final pay, benefit deductions, year-end reporting, FLSA/overtime rules, new hire reporting, I-9 documentation, and E-Verify requirements.
Experience auditing HRIS, payroll, and timekeeping data to identify discrepancies, resolve errors, improve controls, and ensure accurate employee records, tax elections, accrual balances, and direct deposit information.
Strong analytical skills with experience generating reports, reconciling data, identifying trends, and translating HR, payroll, and workforce data into clear, actionable insights for business leaders.
Advanced Excel skills, including pivot tables, Power Query, complex formulas, and data reconciliation; experience with Power BI, Tableau, SQL, or similar tools preferred.
Ability to support system integrations, troubleshoot data issues, participate in testing and configuration updates, and maintain accurate documentation, workflows, and standard operating procedures.
Strong attention to detail, organizational skills, confidentiality, and communication abilities; capable of managing multiple priorities and partnering with HR, Payroll, Finance, Operations, IT, vendors, and leaders.
3+ years of HRIS, Payroll, or HR Data Analytics experience.
Experience with ADP Workforce Manager (WFM) preferred.
Understanding of payroll processing and timekeeping compliance.
Knowledge of federal and state employment compliance requirements.
Strong attention to detail and data accuracy.
Ability to manage confidential information appropriately.
Strong analytical and troubleshooting skills.
Experience with data querying (SQL preferred) and working with large datasets across multiple source systems.
Bachelor's degree required.

Technologies

ADP Workforce Now
ADP Workforce Manager
Power BI
Tableau
Excel
SQL
Power Query

View full job page →

1mo ago

Business Intelligence and Data Analyst

GAM Enterprises, Inc. Mount Prospect, IL

Mount Prospect, IL

1mo ago Closed

$80k - $110k/yr Full time Analyst Analytical Skills Analytics

This position is no longer accepting applications (closed Jul 13, 2026).

Job Description

GAM Enterprises, Inc. offers a collaborative, outcomes oriented environment in the Greater Chicago Area. This on-site, full-time role provides a competitive annual salary of USD 80,000 to 110,000 and a benefits package that includes 401(k) with matching, health and life insurance, a flexible schedule, and paid time off. You will own the full data lifecycle, turning raw operational, engineering, and financial data into actionable insights that drive cross-functional decisions and support automation and AI initiatives.

Responsibilities

Pull data from ERP, CRM, and internal databases using SQL (T-SQL, SSMS or equivalent) and run queries to access required datasets
Clean, validate, and structure data to ensure accuracy, consistency, and reliability across systems
Analyze data to uncover trends, identify inefficiencies, and reveal business opportunities
Translate business needs into concrete data requirements and reporting outputs
Create dashboards, reports, and KPI tools using Power BI and advanced Excel
Collaborate with operations, engineering, sales, and leadership to enable data driven decision making
Support automation of reporting processes and reduce manual data tasks
Lead exploration and adoption of AI tools to improve efficiency and insight generation
Serve as internal liaison for outsourced IT support, handling onboarding, access provisioning, and ticket coordination

Requirements

Bachelor’s degree in Data Analytics, Business Analytics, MIS, Computer Science, Engineering, or related field preferred
4 to 5 years of experience in data analytics, business intelligence, or a related role preferred
Candidates with 2 to 3 years of strong, relevant experience will be considered
Industry experience in mid- to large-sized manufacturing environments is required
Strong SQL skills including T-SQL, joins, and filtering datasets
Advanced Excel skills
Power Query for data extraction, transformation, and ETL
Power Pivot for data modeling across multiple sources
Experience handling complex formulas and large datasets
Experience with Power BI or similar data visualization tools
Strong analytical and problem solving abilities with a curiosity driven mindset
Clear communicator able to work with both technical and non-technical teams
Hands-on experience evaluating or implementing AI tools to improve reporting, analysis, efficiency, or decision making, with measurable outcomes
Comfortable working in a fast paced, evolving, cross functional environment

Technologies

SQL (T-SQL)
SSMS
Power BI
Excel
Power Query
Power Pivot
Python

Education

Bachelor's degree is required. Preferred fields include Data Analytics, Business Analytics, MIS, Computer Science, Engineering, or related disciplines.

Ability to commute

Mount Prospect, IL 60056 (Required).

Work location

In person

Application questions

How many years of work experience do you have with Microsoft Power BI?
How many years of experience do you have working with SQL/T-SQL?
Are you now, or will you in the future, require visa sponsorship to legally work in the United States?
What experience do you have using Python or scripting for automation?
Do you have industry experience in a mid- to large-sized manufacturing environment?

Compensation & benefits

Job Type: Full-time
Pay: USD 80,000.00 - 110,000.00 per year
Benefits: 401(k); 401(k) matching; Flexible schedule; Health insurance; Life insurance; Paid time off

View full job page →

Power Query Data Jobs

Data Analyst

Financial Data Analyst (Manufacturing Exp. Req'd)

HRIS Specialist & Data Analyst

Business Intelligence and Data Analyst

Get Power Query Data Jobs alerts