Data Analytics Developer

• Support data analytics, reporting, and data engineering activities across enterprise data lakes, data warehouses, and business intelligence platforms.
• Design, develop, and maintain ETL/ELT data pipelines to support reporting and analytics requirements.
• Utilize Databricks, Oracle Data Integrator (ODI), SQL, and Python to integrate, transform, and validate large datasets.
• Perform data quality assessments, troubleshoot data issues, and support data governance efforts through metadata documentation and lineage tracking.
• Develop and support BI semantic layers to ensure accurate and scalable reporting solutions.
• Create and maintain dashboards and reports using tools such as Power BI, Oracle Analytics Server (OAS), Tableau, and other enterprise reporting platforms.
• Monitor production data pipelines, troubleshoot query performance issues, validate dashboard data, and support ongoing operations and maintenance activities.
• Collaborate with business stakeholders, analysts, and technical teams to deliver scalable data and reporting solutions.

• Must be able to OBTAIN and MAINTAIN a Federal “PUBLIC TRUST”; candidates must obtain approved adjudication of their PUBLIC TRUST prior to onboarding with Guidehouse. Candidates with an ACTIVE PUBLIC TRUST or SUITABILITY are preferred
• Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Engineering, Mathematics, or a related technical field.
• Three (3) or more years of professional experience supporting data analytics, reporting, data engineering, or business intelligence initiatives.
• Hands-on experience supporting enterprise data lakes, data warehouses, and analytics platforms.
• Strong expertise with:
• Databricks
• ETL/ELT development and orchestration
• Oracle Data Integrator (ODI)
• SQL
• Python
• Data integration and transformation
• Data quality validation and monitoring
• Metadata management and documentation
• BI semantic layer development and support
• Experience developing reports, dashboards, and visualizations using Power BI, OAS, Tableau, or similar BI tools.
• Knowledge of production support processes, including pipeline monitoring, issue resolution, defect management, and operational maintenance.

What Would Be Nice To Have

• Experience applying AI-enabled tools and technologies to support:
• Data modeling and optimization
• Anomaly detection
• Pipeline automation
• Analytics acceleration
• Experience with SEMOSS (Semantic Open Source Software).
• Strong analytical, problem-solving, and communication skills.
• Ability to work independently while collaborating effectively with technical and business teams.
• Experience supporting cloud-based data and analytics environments.
• Familiarity with data governance, master data management, and modern data architecture best practices.
• Experience working in large-scale enterprise or federal data environments.

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
• Parental Leave
• 401(k) Retirement Plan
• Group Term Life and Travel Assistance
• Voluntary Life and AD&D Insurance
• Health Savings Account, Health Care & Dependent Care Flexible Spending Accounts
• Transit and Parking Commuter Benefits
• Short-Term & Long-Term Disability
• Tuition Reimbursement, Personal Development, Certifications & Learning Opportunities
• Employee Referral Program
• Corporate Sponsored Events & Community Outreach
• Care.com annual membership
• Employee Assistance Program
• Supplemental Benefits via Corestream (Critical Care, Hospital Indemnity, Accident Insurance, Legal Assistance and ID theft protection, etc.)
• Position may be eligible for a discretionary variable incentive bonus

About Guidehouse

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.