ZipRecruiter

Log In

2

Remote Power Query Jobs in McKinney, TX (NOW HIRING)

AE Perkins

Data Team Supervisor

Dallas, TX · On-site +1

$105K - $120K/yr

Remote-First with In-Person Training: This position is remote following successful completion of ... Develop, create, and modify query-based dashboards, reports, KPIs, and advanced analytics to ...

previous page

Showing results 21-32

All JobsPower Query JobsRemote Power Query JobsRemote Power Query Jobs in McKinney, TX

Remote Power Query information

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?

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 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 are popular job titles related to Remote Power Query jobs in McKinney, TX?

For Remote Power Query jobs in McKinney, TX, the most frequently searched job titles are:

What job categories do people searching Remote Power Query jobs in McKinney, TX look for?

The top searched job categories for Remote Power Query jobs in McKinney, TX are:

What cities near McKinney, TX are hiring for Remote Power Query jobs?

Cities near McKinney, TX with the most Remote Power Query job openings:

Remote Power Query jobs near you

Data Team Supervisor

AE Perkins

Dallas, TX • On-site, Remote

$105K - $120K/yr

Full-time

Medical, Dental, Vision, Life, Retirement

Re-posted 28 days ago

Key responsibilities

  • Manage the daily activities of the data analysis team involved in designing, implementing, maintaining, and supporting data warehouse systems and projects.

  • Supervise team members to ensure workloads are balanced and deadlines are met, and establish auditing processes to ensure data accuracy and quality.

  • Collaborate with stakeholders to gather requirements, develop technical solutions, and create dashboards, reports, and analytics to support decision-making.

Job description

Candidate Authenticity Statement
We recognize that AI tools are increasingly used in professional settings. However, during our assessment and interview process, we ask candidates to complete all responses independently, without the use of AI-generated assistance.
This ensures we can accurately assess your individual skills, communication style, and problem-solving approach. Submissions or responses that appear AI-generated may be considered misaligned with our evaluation standards.
Remote-First with In-Person Training: This position is remote following successful completion of onboarding. New hires are required to attend two weeks of in-person training at our Carrollton, TX corporate office to ensure a smooth and successful transition into the role.
POSITION SUMMARY:
The Data Team Supervisor is responsible for managing the daily activities of the data analysis team involved in designing, implementing, maintaining, and supporting data warehouse systems and projects. The role ensures that data reporting, data modeling, and data-related projects run efficiently, supporting organizational objectives and maintaining data quality. The supervisor also acts as the primary point of contact for all data reporting, analytics, and database support needs.
PRINCIPAL DUTIES & RESPONSIBILITIES:
Data Management and Supervision:
  • Provide leadership and oversight in the full lifecycle of data warehouse projects, from planning and design to implementation and support.
  • Supervise a team of Data Warehouse Analysts and Database Administrators, ensuring that workloads are appropriately balanced and deadlines are met.
  • Establish and maintain auditing processes to ensure data accuracy and quality across all data warehouses.

Technical Solution Development:
  • Collaborate with business users and stakeholders to gather requirements and translate them into effective technical solutions for data reporting and analytics.
  • Develop, create, and modify query-based dashboards, reports, KPIs, and advanced analytics to support decision-making across the organization.
  • Stay current with advancements in data warehousing, business intelligence (BI) technologies, and analytics to bring innovative solutions to the team.

On-Call and Technical Support:
  • Be available for on-call support as assigned by the manager, providing prompt assistance to resolve data reporting and database-related issues.
  • Provide technical advice, assistance, and training to users, helping them understand and utilize data reporting tools effectively.

Documentation and Best Practices:
  • Document and maintain standard operating procedures, troubleshooting guides, and technical documentation for the data warehouse team.
  • Ensure that best practices for data management, storage, and retrieval are followed across all data warehouse projects.

Additional Responsibilities:
  • Perform other duties as assigned by management to support the department's and organization's goals.

Requirements
KNOWLEDGE, SKILLS, AND ABILITIES REQUIRED:
Data Warehousing and BI Expertise:
  • Extensive knowledge of data warehousing and business intelligence (BI) technologies, including Power BI and SQL querying.
  • Proven ability to develop and maintain complex dashboards, reports, and alerts, as well as to create requirement specifications, technical designs, and user training documents.

Communication and Team Leadership:
  • Strong written and verbal communication skills, with the ability to collaborate effectively across departments and provide clear instructions to team members.
  • Demonstrated leadership skills, with a history of managing teams and mentoring team members to achieve their full potential.

Project and Time Management:
  • Ability to manage multiple priorities independently while meeting deadlines in a fast-paced environment.
  • Strong time management skills and the ability to work well under pressure to resolve issues and meet service level agreements (SLAs).

Customer Service Orientation:
  • Ability to deliver exceptional customer service, responding promptly to requests for assistance and providing support that aligns with user needs.

Continuous Learning:
  • A commitment to staying updated on industry trends and new technologies related to data analytics and BI.

CREDENTIALS & EXPERIENCE:
  • Bachelor's degree in computer science, information systems, or a related field required; equivalent experience may be considered.
  • 7+ years of experience in a data-focused technology role, with heavy exposure to SQL server databases and Power BI (or similar tools)
  • Previous experience in a supervisory or management role required.

Benefits
NOTE: This position pays between $105,000.00 - 120,000.00 per year, plus bonus potential.
BENEFITS
  • Medical Insurance
  • Vision Insurance
  • Dental Insurance
  • 401(k) Matching
  • Flexible Spending Accounts
  • Health Savings Accounts
  • Disability & Life Insurance
  • Employee Assistance Program
  • LegalShield
  • ID Shield
  • Commuter Reimbursement Plan
  • Tuition Reimbursement
  • Bonus Pay - This position falls under our "Corporate Bonus Plan" which entitles you to a potential bonus payout of up to 10% of your annual salary as an annual bonus, if offered employment.

ADDITIONAL BENEFITS INCLUDE:
  • Wellable membership
  • Telescope Health (telehealth) through Accresa
  • Intellect (mental health) application
  • Employee engagement activities, including voluntary events, raffles, book club, and more!

Apply