Data Analyst

Essential Duties & Responsibilities

Parker & Sons is currently seeking a Data Analyst to join our team comprised of creative and energetic employees, who are dedicated to delivering the best customer service experience every day. We are looking for a Data Analyst with a strong emphasis on Domo and Power BI to deliver trusted, actionable reporting across the organization. This role will provide ad hoc analysis and build automated reporting solutions that scale using Power Query, Power Automate, SQL, APIs, and data integrations. The right candidate is detail-driven, business-minded, and capable of owning reporting from intake through delivery and ongoing support.

Keeping you comfortable with expert heating, cooling, plumbing and electrical service Since 1974. Parker & Sons has been serving homeowners and businesses for over 50 years and is recognized nationally for being one of the most knowledgeable heating, cooling, plumbing, and air quality contractors in the industry. Serving Maricopa, Pinal, and Gila Counties, Parker & Sons continues after all these years to maintain an A rating with the Better Business Bureau and even won the BBB Torch Award For Ethics (Twice!)

What's in it For Me?

• Starting salary of $80,000 (DOE)
• Robust PTO Plan
• Health, Vision and Dental plans for you and your family to choose from
• 401K Retirement Plan with company match
• Life Insurance, Short-Term and Long-Term Disability
• Special Program Options FSA, EPA, Legal Services, and Identity Theft
• Continuous Training for your Professional Development
• Working in a dynamic, collaborative, and fun environment
• Coached and supported career growth
  
  
  

Responsibilities

Business Intelligence & Reporting (Primary)

• Design, build, and maintain Business Intelligence dashboards and automated reporting in Domo and Power BI.
• Deliver ad hoc reporting and analysis to support leadership and operational decision-making.
• Translate business questions into well-defined KPIs, dashboards, and repeatable reports with clear definitions and assumptions.
• Improve reporting usability through strong visual design, drilldowns, filters, and stakeholder-friendly layouts.
  
  
  

Power Platform Expertise (Required)

• Develop and maintain advanced Power Query transformations (data shaping, cleansing, merging, and modeling-ready outputs).
• Build and support Power Automate workflows to automate reporting processes, refresh notifications, exception alerts, and cross-system tasks.
• Create standardized, repeatable reporting workflows that reduce manual effort and improve speed and consistency.
  
  
  

SQL, Data Quality & Automation

• Write and optimize SQL queries to extract, validate, and reconcile data across multiple relational databases.
• Ensure reporting accuracy with strong data validation, reconciliation, and documentation practices.
• Own automated refresh schedules, monitoring, and troubleshooting for Domo and Power BI reporting.
  
  
  

Data Integration & APIs

• Integrate data across systems using connectors, scheduled pipelines, file-based transfers, and APIs.
• Support ETL/ELT-style workflows by preparing data for reliable downstream reporting and automation.
• Document data sources, transformations, definitions, and refresh logic to ensure auditability and continuity.
  
  
  

Stakeholder Partnership

• Partner with leaders across operations, finance, and field teams to prioritize reporting needs and deliver clear outcomes.
• Communicate findings clearly and recommend actions based on trends, exceptions, and opportunities.
• Support adoption by guiding stakeholders on how to interpret dashboards and metrics.
  

Minimum Qualifications

• 3 years of experience in a Business Intelligence, reporting, or data analyst role (or equivalent experience).
• Expert-level experience with Power BI and Power Query (advanced transformations, shaping, and troubleshooting).
• Expert-level experience with Power Automate (building workflows, integrations, notifications, and automation logic).
• Strong hands-on experience with Domo (dashboards, reporting, data preparation/transformations, connectors).
• Advanced SQL skills (joins, aggregations, window functions preferred; query optimization).
• Experience with data integration including use of APIs (REST concepts, authentication, JSON/CSV formats).
• Strong proficiency with the Microsoft 365 suite, especially Excel (advanced formulas, pivots, and data handling).
• Strong communication skills with the ability to turn ambiguous requests into accurate, repeatable deliverables.
  
  
  

Preferred Qualifications

• Power BI DAX measures and data model optimization; familiarity with semantic-layer concepts.
• Domo Magic ETL, DataFlows, and calculated metrics (Beast Modes or equivalent).
• Experience supporting operations reporting for trades, construction, home services, or multi-site field operations.
• Familiarity with data governance practices (standard metric definitions, documentation, change control).
  
  
  

Wrench Group and its affiliates are proud to be an Equal Employment Opportunity employer. We do not discriminate based upon race, religion, color, national origin, gender (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, gender expression, genetic information, age, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics. Wrench Group and its affiliates comply with federal and state disability laws and makes reasonable accommodations for applicants and employees with disabilities. If reasonable accommodation is needed to participate in the job application or interview process, please contact the company Human Resources office.