Data & Reporting Analyst

SGS Consulting; Austin (TX); On-site; USD 70,000 - 100,000; Full time

Job summary

SGS Consulting in Austin, TX is seeking a reporting analyst to analyze requirements, design solutions, and develop tested reporting deliverables for approved projects and change requests. The role focuses on gathering and documenting requirements, producing dashboards and charts, and providing ongoing production reporting support for internal and client users.

Candidates should have 3–5 years in reporting with strong Excel, SQL, Tableau, and Power BI skills, plus ability to work onsite and

Qualifications

• 3–5 years in reporting or analytical roles with increasing responsibility.
• Bachelor’s degree in computer information systems or related field preferred.
• Onsite work at Irving, TX warehouse location.

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 metrics.
• Automate data and reports to improve efficiency and profitability analysis across the organization.
• Measure KPIs, analyze variance, and identify risks and opportunities across operations.
• Collaborate with internal customers to enhance reporting and improve systems continually.

Skills

Advanced Excel & data analysis

Trend analysis

Dashboard visualization

Non-technical stakeholder comm

Automation & process improvement

Statistical analysis

Cross-functional collaboration

Education

Bachelor's degree in Computer Information Systems or related field

3-5 years 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.