Databricks Data Analyst

Overview

Guidehouse is seeking a Databricks Data Analyst to join the AI & Data team, supporting client projects involving data analysis, reporting, business intelligence, and advanced analytics solution delivery.

What you'll do

• Design, build, and maintain analytical datasets and data models using Databricks SQL, Delta Lake, and related tools.
• Write, optimize, and maintain SQL queries and Python notebooks to support reporting, analysis, and business use cases.
• Develop dashboards, reports, and data visualizations using BI tools such as Databricks AI/BI Dashboards, Power BI, Tableau, and Databricks SQL.
• Analyze data to identify trends, patterns, anomalies, and insights that support business decisions.
• Translate business requirements into analytical datasets, queries, dashboards, and reporting solutions.
• Perform data validation, quality checks, and issue resolution to support accuracy, consistency, and reliable reporting outputs.
• Work with cross-functional teams including data engineers, data scientists, solution architects, and client stakeholders.
• Communicate analytical findings, reporting logic, and business insights to both technical and non-technical audiences.
• Document data models, transformations, assumptions, and business logic to support transparency, reuse, and ongoing maintenance.
• Support data governance, access control, security, lineage, and compliance standards within the Databricks platform.

What you'll need

• Bachelor's degree in computer science, engineering, mathematics, statistics, or another relevant field.
• 3-10 years of relevant experience in data analytics, reporting, business intelligence, or analytical solution delivery.
• Strong experience with SQL for data querying, transformation, analysis, and reporting.
• Experience with Python or R for data analysis, automation, or exploratory analytics.
• Experience with Databricks or similar cloud-native analytics platforms.
• Experience with BI reporting tools such as Databricks AI/BI Dashboards, Power BI, or Tableau.
• Experience with data modeling, data warehousing, data quality validation, and analytical dataset development concepts.
• Ability to analyze data, communicate insights clearly, and work effectively in team-based delivery environments.
• Experience developing clear documentation for analytic and reporting solutions, including data sources, business logic, metrics definitions, assumptions, and usage guidance.

Nice to have

• Experience using Unity Catalog for governed data discovery, access controls, lineage, schema organization, and secure management of enterprise data assets.
• Familiarity with data modeling, data warehousing, and medallion architecture concepts for curated analytical data delivery.
• Active Databricks Data Analyst Associate or related certification.
• Experience with cloud platforms such as Azure, AWS, or GCP.
• Experience working in project-based or consulting delivery environments.

Details

• Virtual work flexibility within the United States; remote candidates will be considered, with preference given to candidates located near a Guidehouse office (Arlington, VA; Washington, DC; New York, NY; Chicago, IL; Austin, TX; Atlanta, GA; Boston, MA; Boulder, CO).
• Travel: None. Clearance: None.
• Annual salary range: $113,000.00-$188,000.00, varying by experience, qualifications, location, and level.