Data Analyst: Data Insights, SQL & BI Dashboards

Pioneer Consulting Services, LLC.; Plano (TX); Hybrid; USD 70,000 - 90,000; Full time

Job summary

Pioneer Consulting Services, LLC. is seeking a Data Analyst to collect, clean, and analyze data from multiple sources, write SQL queries, and develop dashboards using Power BI or Tableau.

You will collaborate with business, product, finance, and technical teams to deliver clear, actionable insights. The ideal candidate has 1–5 years of experience, strong SQL and Excel skills, and a knack for translating data into business opportunities.

Qualifications

• 1–5 years of experience in data analysis, reporting, BI, or related field.
• Strong SQL skills (joins, aggregations, subqueries, CTEs).
• Proficiency in Microsoft Excel (PivotTables, lookup functions, data cleaning).
• Experience with Power BI, Tableau, or similar data visualization tools.
• Knowledge of data cleaning, validation, transformation, and reporting.
• Strong analytical, problem-solving, and communication skills.
• Ability to interpret data and communicate findings to technical and non-technical stakeholders.

Responsibilities

• Collect, clean, validate, and analyze data from multiple sources.
• Write SQL queries to extract, transform, and manipulate datasets.
• Develop and maintain dashboards and reports using Power BI, Tableau, or similar tools.
• Perform exploratory data analysis to identify trends, patterns, and business opportunities.
• Prepare recurring and ad hoc reports for business stakeholders.
• Collaborate with business, product, finance, and technical teams to understand reporting requirements.
• Identify data quality issues and recommend solutions.
• Track KPIs and prepare actionable insights.
• Document analytical processes, reports, and data definitions.
• Support data-driven decision-making through clear presentations and visualizations.

Skills

SQL

Microsoft Excel

Data visualization

Analytical thinking

Communication

Data interpretation

Problem solving

Education

Bachelor's degree in a relevant field

Tools

Power BI

Tableau

SQL Server

MySQL

PostgreSQL

Job description

Pioneer Consulting Services, LLC. is seeking a Data Analyst to collect, clean, and analyze data from multiple sources, write SQL queries, and develop dashboards using Power BI or Tableau.

You will collaborate with business, product, finance, and technical teams to deliver clear, actionable insights. The ideal candidate has 1–5 years of experience, strong SQL and Excel skills, and a knack for translating data into business opportunities.