About
Design, build, and maintain scalable ETL pipelines using Databricks, PySpark, SQL, and Delta Lake.
Troubleshoot and resolve Databricks job failures, cluster performance issues, data quality gaps, and pipeline bottlenecks.
Implement CI/CD practices for notebooks, workflows, and data jobs.
Lead and review data cleaning scripts using tools such as Python.
Maintain and enhance dashboards, analytics solutions, and reporting tools used in operational and strategic decision making.
Develop dashboards using tools such as Qlik and Tableau.
Collaborate with internal technical and functional teams and serve as a trusted advisor to government clients on data analytics, automation, modeling, and visualization initiatives.
Focus on client services, while also supporting business development, internal firm initiatives, and ongoing professional development.
Operate successfully on remote projects as well as hybrid on‑site projects in the DC metro area.
Job Family Data Science Consulting
Travel Required Up to 10%
Clearance Required Ability to obtain Public Trust
Qualifications
Ability to obtain and maintain a Federal or DHS Public Trust.
Bachelor’s degree.
One (1) or more years of experience in data analysis, data engineering, or business analysis.
Experience with Databricks.
Nice to Have
Active DHS Public Trust.
Law Enforcement experience.
Experience using Databricks.
2+ years of relevant experience.
Experience with simulation, transportation/logistics modeling, or operations research.
Ability to identify client needs, build relationships, design, and implement solutions.
Strong communication and presentation skills and ability to explain technical topics to non‑technical audiences.
Familiarity with cloud‑based analytics environments such as Databricks, Palantir, AWS, Azure, or Google.
Experience performing analytics and data transformation using Python.
Proficiency in querying data using SQL and experience optimizing SQL query performance for large datasets.
Ability to gather requirements and present to clients with strong written and verbal communication skills.
Experience working with Python, R, or other modern scripting languages used in analytics.
Knowledge of ETL/ELT processes and tools for data integration such as Databricks, Snowflake, Azure Data Factory, Microsoft SQL Server tools (SSIS, SSMS, SSAS, SSRS), Azure Synapse Analytics.
Benefits Include
Medical, Rx, Dental & Vision Insurance.
Personal and Family Sick Time & Company Paid Holidays.
Position may be eligible for a discretionary variable incentive bonus.
Parental Leave and Adoption Assistance.
401(k) Retirement Plan.
Basic Life & Supplemental Life.
Health Savings Account, Dental/Vision & Dependent Care Flexible Spending Accounts.
Short‑Term & Long‑Term Disability.
Student Loan Paydown.
Tuition Reimbursement, Personal Development & Learning Opportunities.
Skills Development & Certifications.
Employee Referral Program.
Corporate Sponsored Events & Community Outreach.
Emergency Back‑Up Childcare Program.
Mobility Stipend.
Equal Opportunity Employer Guidehouse is an Equal Opportunity Employer—Protected Veterans, Individuals with Disabilities or any other basis protected by law, ordinance, or regulation.
Guidehouse will consider for employment qualified applicants with criminal histories in a manner consistent with the requirements of applicable law or ordinance including the Fair Chance Ordinance of Los Angeles and San Francisco.
#J-18808-Ljbffr
Languages
- English
Notice for Users
This job comes from a TieTalent partner platform. Click "Apply Now" to submit your application directly on their site.