Data Analyst

Pioneer Consulting Services LLC
Plano, TX, United States
4 days ago
Apply on www.careerjet.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
5 years minimum
Working hours
Regular working hours

Tech stack

Microsoft Excel Amazon Web Services Data Analysis Microsoft Azure Information Systems Databases Data Cleansing Extract Transform Load (ETL) Data Visualization Data Warehousing Database Queries Python (Programming Language)
+11 more
PostgreSQL Microsoft SQL Server MySQL Oracle (Applications) Pivot Tables Power BI Cloud Services SQL Databases Tableau (Software) Google Cloud Information Technology

Job description

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.

Requirements

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., 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. Application Instructions

  • Submit updated resume, current location, relevant technical skills, total experience, work authorization status, and preferred work location.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.careerjet.com
Prepare application

Good distractions

Loading talks and stories from around this role…