Data Analyst – Data Engineering & Architecture Consulting

Apply for the full-time Data Analyst position at Guidehouse in Fairview Heights, IL. Requires an active DoD Secret clearance, a Bachelor’s degree, and 3+ years of data management experience utilising SQL, Python/R, and Power BI/Tableau.

About the Company: Guidehouse

Guidehouse is a leading global provider of strategic consulting, digital technology infrastructure, and managed services to both public sector agencies and commercial markets. Formed by blending deep commercial domain expertise with massive public sector scale, Guidehouse helps organisations navigate high-stakes regulatory environments, structural market shifts, and complex technical modernisation vectors. The firm operates globally across major industries, including healthcare, financial services, energy, sustainability, and national security.

Operating within the specialised Data Engineering & Architecture Consulting family, Guidehouse’s defence and public sector teams build highly secure data solutions for federal entities. The company cultivates a compliance-driven, technically rigorous, and deeply collaborative workplace environment. Guidehouse places a massive premium on process optimisation, strict data governance, and technology-driven efficiency, allowing experienced technical experts to scale their data modelling capabilities on mission-critical national platforms.

About the Role: Data Analyst (Consulting Track)

Guidehouse is actively hiring a technically precise, clearance-holding Data Analyst to join its Data Engineering & Architecture Consulting division in Fairview Heights, Illinois. This full-time, 5 days a week, onsite position is designed for professionals with at least 3 years of proven experience who want to work at the intersection of business intelligence, database troubleshooting, and federal mission support.

In this role, you will assume operational ownership over reporting lifecycles for enterprise systems and mission-critical programs. Your day-to-day focus will center on building and maintaining enterprise-level performance dashboards using Power BI or Tableau and writing optimised SQL routines for relational databases. You will be tasked with identifying operational trends, establishing data dictionaries, mentoring junior analysts, and implementing automated scripts via Python or R to streamline internal metrics tracking, root cause analysis, and compliance documentation.

Key Responsibilities & Analytical Workflows

• Enterprise System Support: Provide end-to-end data analysis, management, and reporting support for high-stakes enterprise systems and mission-critical federal programs.

• BI Dashboard Engineering: Design, develop, and maintain advanced corporate data models, reporting structures, and visual telemetry dashboards in Power BI or Tableau to deliver actionable operational insights.

• Data Wrangling & Processing: Ingest, parse, and clean large, complex datasets from multiple internal and external databases to isolate outperforming trends and operational anomalies.

• Root Cause Analysis: Lead complex data-related troubleshooting sprints to resolve structural data discrepancies, query bottlenecks, and reporting errors.

• Data Governance & Documentation: Standardise and maintain meticulous technical documentation outlining data dictionaries, pipeline transformation logic, and reporting procedures.

• Mentorship & Tool Evaluation: Mentor junior team members, contribute to team knowledge sharing, and evaluate modern analytics platforms or automation capabilities to optimise workflows.

Candidate Prerequisites & Required Skill Stack

Guidehouse values analytical professionals who combine structured database thinking with a proactive problem-solving aptitude and clear communication habits under strict compliance frameworks.

Security & Location Mandates:

• Security Clearance: Must hold an ACTIVE federal or DoD “SECRET” security clearance at the time of application.

• Work Framework: Must be able to be on-site 5 days a week at the Fairview Heights, IL facility, with the flexibility for up to 10% travel.

Educational Profile & Experience Baseline:

• Academic Matrix: Bachelor’s degree from an accredited institution.

• Experience Horizon: Minimum 3 or more years of relevant corporate data analysis or data management experience, consistent with senior-level technical labour categories.

Required Technical Competencies:

• Database Syntax Foundations: High operational proficiency in writing structured queries and managing data inside SQL and relational databases.

• Data Programming Libraries: Hands-on experience executing data manipulation or automated transformation scripts utilising Python, R, or equivalent analytical programming frameworks.

• Business Intelligence Toolkits: Practical corporate familiarity deploying interactive visual metrics frameworks within Power BI or Tableau.

Preferred Assets (The Plus Stack):

• Statistical Reasoning: Conceptual comfort applying advanced metrics, including Regression Analysis, Time Series Analysis, or Operations Research.

• Modern Architecture: Familiarity with high-volume data warehousing and data lake structural frameworks.

• Advanced Analytics: Basic knowledge of machine learning methodologies or advanced predictive modelling.

• Regulated Environments: Previous experience working within federal, defence, or highly regulated corporate environments.

Core Position Specifications

• Position Title: Data Analyst

• Job Family Allocation: Data Engineering & Architecture Consulting

• Hiring Enterprise: Guidehouse

• Primary Work Location: Fairview Heights, Illinois, United States (100% Onsite Operations)

• Annual Salary Range: $77,000.00 – $129,000.00 (Determined by experience, skill sets, and clearance status)

• Core Systems Domain: SQL Relational Queries, Python/R Data Manipulation, Power BI & Tableau Visuals, Data Architecture Documentation, Root Cause Analysis, DoD Security Compliance