2

Remote Power Query Jobs in Columbus, OH (NOW HIRING)

Senior Accountant

Columbus, OH ยท On-site +1

$71K - $89K/yr

Remote- OH Preferably Reports to: CEO Role Overview: In the BPO industry, our "product" is our ... Expert-level Excel/Google Sheets (Power Query, Data Modeling) to handle high-volume transaction ...

Sr Business Data Analyst

Westerville, OH ยท On-site +1

$70K - $115K/yr

Remote/U.S.-based position with up to 50% travel required to support startup implementations and ... to query, clean, and transform data, required * Proficiency in Power BI, including building ...

Remote Power Query information

What are the typical challenges faced by Remote Power Query professionals, and how can they be addressed?

Remote Power Query professionals often encounter challenges related to data connectivity, especially when integrating multiple data sources across different environments. Ensuring consistent data refreshes and troubleshooting connection issues can require creative problem-solving. Effective communication with team members and data owners is key to resolving discrepancies and clarifying requirements. Maintaining documentation and using version control for queries help streamline collaboration and minimize errors while working remotely.

What is the difference between Remote Power Query vs Remote Data Analyst?

AspectRemote Power QueryRemote Data Analyst
Required SkillsData transformation, Power Query, Excel, Power BIData analysis, SQL, Excel, Power BI, visualization
Work EnvironmentRemote, primarily using data tools and platformsRemote, involving data interpretation and reporting
Industry UsageBusiness intelligence, data preparation rolesData analysis, reporting, business insights

Remote Power Query focuses on data transformation and preparation using Power Query tools, often as part of data cleaning and modeling. Remote Data Analysts perform broader data analysis, including interpreting data, creating reports, and providing insights. While both roles require skills in Power BI and Excel, Power Query specialists concentrate on data shaping, whereas Data Analysts handle comprehensive analysis and reporting tasks.

What is a Remote Power Query specialist?

A Remote Power Query specialist is a professional who works from a remote location and is skilled in using Microsoft Power Query, a data connection technology that helps users discover, connect, combine, and refine data across a wide variety of sources. These specialists typically assist organizations in automating data preparation and transformation tasks for business intelligence and reporting. Their expertise allows businesses to streamline data workflows, improve data accuracy, and save time by creating efficient data models and queries without needing in-person support.

What are the key skills and qualifications needed to thrive as a Remote Power Query Specialist, and why are they important?

To thrive as a Remote Power Query Specialist, you need advanced knowledge of data analysis, Power Query (M language), and data transformation concepts, often supported by a degree in computer science, information systems, or a related field. Proficiency with Microsoft Power BI, Excel, and other data visualization or ETL tools, along with relevant certifications like Microsoft Certified: Data Analyst Associate, is typically required. Strong problem-solving ability, attention to detail, and clear communication are vital soft skills for understanding client needs and delivering accurate data solutions remotely. These skills and qualifications ensure efficient data management, enable effective remote collaboration, and drive insightful business decisions.
What are popular job titles related to Remote Power Query jobs in Columbus, OH? For Remote Power Query jobs in Columbus, OH, the most frequently searched job titles are:
Infographic showing various Remote Power Query job openings in Columbus, OH as of July 2026, with employment types broken down into 90% Full Time, and 10% Contract. Highlights an 100% Remote job distribution.

Senior Accountant

Compass Experience Labs

Columbus, OH โ€ข On-site, Remote

$71K - $89K/yr

Other

Re-posted yesterday


Job description

Senior Internal Accountant- Global BPO Operations

Industry: Business Process Outsourcing (BPO) & Professional Services

Location: Remote- OH Preferably

Reports to: CEO

Role Overview:
In the BPO industry, our "product" is our people and their time. As a Senior Internal Accountant, you will manage the financial complexities of a high-volume, global service delivery model. Your role is unique: you aren't just managing books; you are tracking the profitability of global delivery locations, managing complex intercompany cross-charges for labor, and ensuring that our global footprint remains compliant with diverse tax and labor regulations.

Key Responsibilities:
Intercompany & Transfer Pricing: Manage the month-end billing between our offices. Ensure all intercompany service fees are recorded accurately. Coordinate/assist in the annual transfer pricing audit

Workforce & Utilization Analysis: Partner with HR and Operations to reconcile payroll across different geographies. Analyze "Cost per Seat" and "Utilization Rates" to provide insights into regional profitability.

Revenue Recognition: Oversee billing for varied contract types, including FTE-based (Full-Time Equivalent), transaction-based, and outcome-based pricing models.

Global Statutory Compliance: Coordinate manual recording of journal entries with local Accounting Firm. Manage/assist month-end closing process in coordination with local Accounting Firm. Coordinate with local accounting and tax partners to ensure compliance with all federal and local taxes. Manage year end external audit with External Audit firm. Coordinate with local accounting firm the annual filing with SEC of all required reports

Forecasting & Budgeting: Assist in the annual budgeting process.

Leadership: manage Operations Finance, and Payroll teams

Required Qualifications:
Education: Bachelors Degree in Accounting or Finance.
Experience: 5+ years of experience, ideally within a BPO, Shared Services, or Global Consulting firm.
Technical Skills: Advanced proficiency in Global Accounting and Payroll systems.
Regulatory Knowledge: Strong understanding of US GAAP/IFRS and basic knowledge of international labor/tax laws.
Analysis: Expert-level Excel/Google Sheets (Power Query, Data Modeling) to handle high-volume transaction data.
Preferred Attributes:
Multi-Currency Mastery:
High comfort level managing "functional" vs. "reporting" currencies and calculating FX gains/losses.

Operational Curiosity: A desire to understand the "why" behind the numberse.g., why a specific delivery center's margins are fluctuating.

Communication: Ability to bridge the gap between "Corporate HQ" and "Local Operations" across different cultures.

Why Join Our Team?
Working internally for a BPO offers a masterclass in global business. You will gain exposure to international tax, complex labor laws, and high-scale financial automation that few other industries can provide.