Data Analyst

Dutch Ridge Consulting Group (DRCG), LLC; Harrisburg (Dauphin County); On-site; USD 65,000 - 90,000; Full time

Job summary

Dutch Ridge Consulting Group, LLC (DRCG) is seeking an experienced Data Analyst to transform complex data into actionable insights using Tableau, SQL, and BI techniques. This on-site role focuses on building dashboards, exploring data trends, and communicating findings to stakeholders.

You will collaborate with court administration and IT teams to define requirements, optimize data quality, and deliver scalable analytics solutions that support informed decision-making in a government context.

Qualifications

• Five or more years of experience in data analytics, BI, or related field.
• Experience using Tableau to develop interactive dashboards and visualizations.
• Strong proficiency in SQL and relational databases.
• Experience translating business questions into analytical and reporting solutions.
• Understanding of data visualization principles and dashboard design.

Responsibilities

• Design, develop, and maintain dashboards and reports that provide meaningful insights.
• Explore and analyze data to identify trends and opportunities.
• Apply statistical analysis to evaluate business questions and support decisions.
• Collaborate with stakeholders across court administration to define requirements.
• Use data storytelling to communicate complex information clearly to varied audiences.
• Write and optimize SQL queries to extract, analyze data from multiple sources.
• Validate data to ensure accuracy and integrity of reporting data.
• Work with IT teams to improve data quality and reporting processes.
• Evaluate existing dashboards and recommend usability improvements.
• Identify opportunities to improve data collection and analytics practices.
• Support BI capabilities through best practices and reusable solutions.
• Help stakeholders interpret dashboards and metrics effectively.

Skills

Tableau

SQL

Data analysis

Data visualization

Tools

Tableau Server/Cloud

Microsoft SQL Server

SAP ASE/IQ

Job description

Company Overview

Dutch Ridge Consulting Group, LLC (DRCG) is an ISO 9001:2015, Small Business Administration (SBA) Certified Service-Disabled Veteran-Owned Small Business (SDVOSB). DRCG provides cleared technical support staff throughout the United States with corporate offices in Ashburn, Virginia. DRCG offers expertise in Systems Integration (SI), Information Technology (IT) solutioning, Program Management, Risk Management, Business Process Reengineering (BPR), Requirements Engineering, Workflow Solutioning, and Business Consulting Services. Established in 2016, DRCG is 100% US owned and predominately supports the DoJ, DoW, and DHS. DRCG optimizes client investments by leveraging expertise to better manage the growth and transformation of existing IT environments.

(If you do not currently live in the Mechanicsburg/Harrisburg Pennsylvania area please do not apply, we will only review candidates that currently live in the area)

Description

DRCG is looking to hire an experienced Data Analyst with strong skills in data analysis, visualization (Tableau), SQL, and business intelligence to transform complex data into clear and meaningful insights. This role is ideal for a data professional who enjoys exploring data, identifying trends and opportunities, and using visualization techniques to tell compelling stories with data. The ideal candidate is naturally curious, comfortable working with complex datasets, and skilled at translating analytical findings into visualizations that make information easier to understand and act upon.

Location

On-Site in Mechanicsburg / Harrisburg, PA

Job Duties

• Design, develop, and maintain dashboards, reports, and data visualizations that provide meaningful insights into operations and performance.
• Explore and analyze data to identify trends, patterns, relationships, anomalies, and opportunities for improvement.
• Apply statistical analysis and modeling techniques to identify trends and patterns, evaluate business questions, and support informed decision-making.
• Collaborate with stakeholders across court administration to understand business needs, define requirements, and translate them into effective analytics solutions.
• Use data storytelling and visualization best practices to communicate complex information clearly to technical and non-technical audiences.
• Write and optimize SQL queries to extract, combine, validate, and analyze data from multiple sources.
• Perform data profiling and validation to ensure accuracy, consistency, and integrity of analytical and reporting data.
• Work with IT teams, data owners, and business stakeholders to investigate data issues and improve data quality and reporting processes.
• Evaluate existing dashboards and reporting solutions and recommend enhancements to usability, performance, visualization, and analytical value.
• Identify opportunities to improve data collection, business processes, reporting standards, and analytics practices.
• Support and advance the organization's business intelligence capabilities through best practices, reusable solutions, and visualization standards.
• Help stakeholders become more effective consumers of data by guiding their interpretation of dashboards, metrics, and analytical findings.

Requirements

• Five or more years of experience in data analytics, business intelligence, data visualization, or a related field.
• Demonstrated experience using Tableau to develop interactive dashboards and compelling visualizations.
• Strong proficiency in SQL and experience working with relational databases and complex datasets.
• Experience performing data analysis to identify trends, patterns, anomalies, and actionable insights.
• Experience gathering requirements and translating business questions into analytical and reporting solutions.
• Understanding of data visualization principles, dashboard design, and reporting best practices.
• Working knowledge of data modeling and the relationships between source data, analytical datasets, and reporting solutions.

Preferred Skills

• Strong analytical and problem-solving skills with a curious, investigative approach to data.
• Ability to move beyond presenting numbers to explain what the data means and why it matters.
• Excellent written, verbal, and visual communication skills.
• Ability to communicate analytical and technical concepts clearly to non-technical audiences.
• Strong attention to detail and commitment to data accuracy and quality.
• Ability to manage multiple priorities and work independently while collaborating effectively with others.
• A collaborative and empathetic approach to working with stakeholders with varying levels of technical and data expertise.
• Strong customer-service orientation and commitment to delivering useful, high-quality analytics solutions.

Preferred Technical Qualifications

• Experience with Tableau Server or Tableau Cloud, including publishing, permissions, data sources, extracts, and dashboard performance optimization.
• Familiarity with data warehouses, data lakes, and modern analytics architectures.
• Familiarity with Microsoft SQL Server and/or SAP ASE/IQ.
• Experience working with large or complex datasets from multiple systems.
• Experience supporting data governance, metric definitions, data quality, or reporting standards.

Nice To Have

• Tableau Certified Data Analyst or similar certification.
• Experience with Python or R for data analysis, data preparation, or automation.
• Experience with exploratory data analysis, statistical analysis, or advanced analytics.
• Experience developing dashboards or analytics solutions for operational, performance, or executive reporting.