Data Analyst Databricks

Job Family:

Travel Required:

Clearance Required:

What You Will Do:

Our consultants on the Defense & Security AI & Data team help clients maximize the value of their data and automate business processes. This high performing team works with clients to implement the full spectrum of data analytics and data science from data querying and wrangling to data engineering to data visualization dashboarding and business intelligence (BI) to predictive analytics machine learning (ML) and artificial intelligence (AI). Our services enable our clients to define their information strategy enable mission critical insights and data-driven decision making reduce cost and complexity increase trust and improve operational effectiveness. This individual will support of organizational and mission goals within the Department of Homeland Security (DHS). This role requires handson technical expertise and strong communication skills. Responsibilities include but are not limited to:

• 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.

• Leading and reviewing 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.

• Support business development (such as RFP RFQ and RFI responses and white papers) internal firm initiatives and ongoing professional development.

• Operate successfully on remote projects as well as hybrid on-site projects in the DC metro area.

What You Will Need:

• Ability to OBTAIN and MAINTAIN a Federal or DHS Public Trust

• Bachelors Degree

• ONE (1) or more years of experience in data analyst data engineering or business analysis

• Experience with Databricks.

What Would Be 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 toidentifyand address client needs build relationshipsdesignand implement solutions.

• Strong communicationand 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.

What We Offer:

Guidehouse offers a comprehensive total rewards package that includes competitive compensation and a flexible benefits package that reflects our commitment to creating a diverse and supportive workplace.

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

About Guidehouse

Guidehouse is an Equal Opportunity EmployerProtected 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.

If you have visited our website for information about employment opportunities or to apply for a position and you require an accommodation please contact Guidehouse Recruiting at 1- or via email at . All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodation.

All communication regarding recruitment for a Guidehouse position will be sent from Guidehouse email domains including @ or . Correspondence received by an applicant from any other domain should be considered unauthorized and will not be honored by Guidehouse. Note that Guidehouse will never charge a fee or require a money transfer at any stage of the recruitment process and does not collect fees from educational institutions for participation in a recruitment event. Never provide your banking information to a third party purporting to need that information to proceed in the hiring process.

If any person or organization demands money related to a job opportunity with Guidehouse please report the matter to Guidehouses Ethics Hotline. If you want to check the validity of correspondence you have received please contact . Guidehouse is not responsible for losses incurred (monetary or otherwise) from an applicants dealings with unauthorized third parties.

Guidehouse does not accept unsolicited resumes through or from search firms or staffing agencies. All unsolicited resumes will be considered the property of Guidehouse and Guidehouse will not be obligated to pay a placement fee.