Data & Reporting Analyst

SGS Consulting; Clifton (TX); On-site; USD 65,000 - 90,000; Full time

Job summary

SGS Consulting is seeking a Reporting Analyst to analyze requirements, design solutions, and develop tested reporting deliverables for approved projects and change requests in Irving, Texas. You will gather and document requirements, perform system data analysis, and produce reliable internal and client reports using dashboards and operational metrics.

You will automate data and reports to improve efficiency and profitability analysis, measure KPIs, and proactively identify risks and

Qualifications

• 3–5 years in reporting or analytics with increasing responsibility.
• Bachelor’s degree in CIS or related field or equivalent experience.
• Onsite work at Irving, Texas warehouse.
• Advanced Excel with pivot tables, VLOOKUPs, and macros.
• Proficient in SQL, Tableau, and Power BI.

Responsibilities

• Analyze requirements, design solutions, and develop tested reporting deliverables for approved projects and change requests.
• Gather, organize, and document requirements while performing system data analysis and report solution development activities.
• Provide ongoing production reporting support ensuring accuracy, timeliness, and reliability for internal and external customers.
• Produce regular internal and client reports using charts, dashboards, and standardized operational metrics.
• Automate data and reports to improve efficiency, profitability analysis, and scalable reporting processes organization-wide.
• Measure key performance indicators, analyze variance, and identify risks and opportunities proactively across operations teams.
• Collaborate with internal customers to enhance existing reporting, develop new solutions, and improve systems continually.

Skills

Advanced Excel

Trend analysis

Dashboards & visualization

Stakeholder communication

Data automation

Statistical analysis

Collaboration & mentoring

Education

Bachelor’s degree in CIS or related field

Experience in reporting/analytical roles

Tools

SQL

Tableau

Power BI

SSMS

Oracle SQL Developer

Job description

Job Responsibilities:

• Analyze requirements, design solutions, and develop tested reporting deliverables for approved projects and change requests.
• Gather, organize, and document requirements while performing system data analysis and report solution development activities.
• Provide ongoing production reporting support ensuring accuracy, timeliness, and reliability for internal and external customers.
• Produce regular internal and client reports using charts, dashboards, and standardized operational metrics consistently delivered.
• Automate data and reports to improve efficiency, profitability analysis, and scalable reporting processes organization-wide performance.
• Measure key performance indicators, analyze variance, and identify risks and opportunities proactively across operations teams.
• Collaborate with internal customers to enhance existing reporting, develop new solutions, and improve systems continually.

Skills:

• Advanced Excel expertise utilizing pivot tables, formulas, Power Query, lookups, and complex data manipulation techniques.
• Strong ability performing trend analysis, time based comparisons, and insightful visualization development for business reporting.
• Proficiency designing and maintaining operational dashboards, charts, and management level reporting outputs supporting decision making.
• Capability translating technical concepts into non technical language for effective stakeholder communication and collaboration success.
• Experience automating data and reports to drive efficiency and improved profitability analysis through scalable solutions.
• Competence conducting statistical analysis including variance, correlation, trend identification, and root cause evaluation methods effectively.
• Strong collaboration skills supporting customers, mentoring peers, and coordinating reporting improvement initiatives across departments successfully.

Education/Experience:

• Three to five years professional experience with increasing responsibility in reporting or analytical roles environments.
• Bachelor’s degree in computer information systems or related field or equivalent relevant experience preferred qualifications.
• Ability to work onsite at Irving Texas warehouse location within a desk based environment setting.
• Intermediate to advanced proficiency with Excel including pivot tables, vlookups, and advanced macros usage requirements.
• Intermediate to advanced knowledge of SQL, Tableau, Power BI, and reporting databases platforms tools required.
• Working knowledge of SSMS and Oracle SQL Developer for data analysis activities within enterprise environments.
• Professional demeanor, integrity, sound judgment, and ability managing multiple tasks while meeting deadlines consistently effectively.