Guidehouse Logo

Guidehouse

Data Analytics Developer

Posted Yesterday
Be an Early Applicant
In-Office
Charlotte, NC, USA
Mid level
In-Office
Charlotte, NC, USA
Mid level
Develop and maintain ETL/ELT pipelines, integrate and transform enterprise data, and support data lakes, warehouses, BI platforms, semantic layers, dashboards, and reporting solutions. Perform data quality validation, metadata documentation, lineage tracking, pipeline monitoring, query troubleshooting, and production support. Collaborate with business and technical stakeholders to deliver scalable analytics solutions using Databricks, ODI, SQL, Python, Power BI, OAS, and Tableau.
The summary above was generated by AI

Job Family:

Systems Engineering


Travel Required:

None


Clearance Required:

Ability to Obtain Public Trust

What You Will Do

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

What You Will Need

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

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

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

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-571-633-1711 or via email at [email protected]. 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 @guidehouse.com or [email protected].  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 Guidehouse’s Ethics Hotline. If you want to check the validity of correspondence you have received, please contact [email protected]. Guidehouse is not responsible for losses incurred (monetary or otherwise) from an applicant’s 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.

Guidehouse Charlotte, North Carolina, USA Office

Charlotte, United States

Similar Jobs

12 Hours Ago
Remote or Hybrid
United States
97K-146K Annually
Senior level
97K-146K Annually
Senior level
Aerospace • Artificial Intelligence • Cloud • Machine Learning • Software • Cybersecurity • Defense
Analyze and automate supplier-quality data using ETL tools, dashboards, KPIs, and statistical techniques. Build actionable insights and predictive reporting for quality, engineering, production, and leadership teams. Collaborate cross-functionally on continuous improvement, coach employees on data-driven decision-making, deliver presentations, and document analytical processes. The role requires expertise in Alteryx or comparable ETL tools, Tableau or Power BI, SQL or Python, UX/UI design, and supplier-quality analytics.
Top Skills: AlteryxPower BIPythonReactSQLTableau
Yesterday
Remote or Hybrid
94K-176K Annually
Senior level
94K-176K Annually
Senior level
Artificial Intelligence • Fintech • Insurance • Marketing Tech • Software • Analytics
Designs and develops scalable data products for Distribution and Marketing using Snowflake, SQL, and Python. Translates ambiguous business needs into technical requirements, prototypes solutions, builds data models and transformation logic, and partners with engineers to deliver production-ready systems. The role includes data quality, governance, security, stakeholder management, technical leadership, mentorship, and evaluating AI-enabled approaches.
Top Skills: SparkBusiness Intelligence ToolsData WarehousingEltETLPythonSnowflakeSQLVersion Control
2 Days Ago
Hybrid
Junior
Junior
Automotive • Big Data • Information Technology • Robotics • Software • Transportation • Manufacturing
Build and maintain data pipelines and analytics infrastructure for high-voltage EV battery thermal runaway diagnostics and prognostics. Lead analytics projects, analyze fleet and battery data using statistical and machine learning methods, create visualizations, and collaborate with controls, software, test, and field service engineers. Support diagnostic algorithm development, vehicle troubleshooting, hardware disposition, and cross-functional analytics initiatives.
Top Skills: CretaETLGgplot2GitHilHiveIncaJIRAMachine LearningMatlabMatlab/SimulinkMatplotlibMdaPower BIPredictive ModelingPythonRSilSparkSQLStatistical AnalysisTableauVehicle Spy

What you need to know about the Charlotte Tech Scene

Ranked among the hottest tech cities in 2024 by CompTIA, Charlotte is quickly cementing its place as a major U.S. tech hub. Home to more than 90,000 tech workers, the city’s ecosystem is primed for continued growth, fueled by billions in annual funding from heavyweights like Microsoft and RevTech Labs, which has created thousands of fintech jobs and made the city a go-to for tech pros looking for their next big opportunity.

Key Facts About Charlotte Tech

  • Number of Tech Workers: 90,859; 6.5% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Lowe’s, Bank of America, TIAA, Microsoft, Honeywell
  • Key Industries: Fintech, artificial intelligence, cybersecurity, cloud computing, e-commerce
  • Funding Landscape: $3.1 billion in venture capital funding in 2024 (CED)
  • Notable Investors: Microsoft, Google, Falfurrias Management Partners, RevTech Labs Foundation
  • Research Centers and Universities: University of North Carolina at Charlotte, Northeastern University, North Carolina Research Campus

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account