Data Analyst

Pioneer Consulting Services, LLC.; Plano (TX); Hybrid; USD 70.000 - 90.000; Vollzeit

Zusammenfassung

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.

Qualifikationen

• 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.

Aufgaben

• 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.

Kenntnisse

SQL

Microsoft Excel

Data visualization

Analytical thinking

Communication

Data interpretation

Problem solving

Ausbildung

Bachelor's degree in a relevant field

Tools

Power BI

Tableau

SQL Server

MySQL

PostgreSQL

Jobbeschreibung

Job Summary (List Format) Data Analyst

• 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 key performance indicators (KPIs) and prepare actionable insights.
• Document analytical processes, reports, and data definitions.
• Support data-driven decision-making through clear presentations and visualizations.

Required Skills

• 1 5 years of experience in data analysis, reporting, business intelligence, or a 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.

Preferred Qualifications

• Experience with Python or R for data analysis.
• Familiarity with databases (SQL Server, MySQL, PostgreSQL, Oracle).
• Exposure to cloud data platforms (AWS, Azure, Google Cloud).
• Knowledge of ETL/ELT processes and data warehousing concepts.
• Bachelor s degree in a relevant field (Computer Science, Information Systems, Statistics, Mathematics, Business Analytics) or equivalent experience.

Work Locations

• Multiple locations across the USA, with on-site, hybrid, or remote options depending on the position. Sample locations: Dallas, TX; Austin, TX; New York, NY; Jersey City, NJ; Houston, TX; Atlanta, GA; Chicago, IL; Charlotte, NC; Raleigh, NC; Boston, MA; Seattle, WA; San Francisco, CA; San Jose, CA; Los Angeles, CA; Denver, CO; Phoenix, AZ; Tampa, FL; Orlando, FL; Washington, DC; Minneapolis, MN.

Ideal Candidate

• 1 5 years of relevant experience.
• Hands-on expertise in SQL, Excel, dashboards, and data analysis.
• Interested in solving real-world business problems through data.