Data Analyst

Zachary Piper Solutions is seeking a Data Analyst to join a federal-focused technology firm specializing in data-driven solutions, cloud engineering, and digital transformation for government agencies. This is a Hybrid role, 2 days on-site in the Washington D.C. area, and requires either an active DHS clearance or active DoD Top Secret Clearance. The Data Analyst will support advanced analytics, AI, and machine learning initiatives by developing robust reporting solutions, enhancing data transparency, and enabling data-driven decision-making across the organization.

Responsibilities of the Data Analyst :

• Partner with data engineers to ensure data is accessible, reliable, and structured for analytical use, including validation of data pipelines and outputs
• Analyze large, complex datasets to identify trends, patterns, and actionable insights that support mission and business objectives
• Develop, maintain, and enhance dashboards and reports using Tableau and Power BI to support operational and strategic decision-making
• Perform exploratory data analysis, data profiling, and statistical analysis to assess data quality, completeness, and usability
• Validate and reconcile data across systems to ensure consistency and accuracy in reporting and downstream analytics
• Support the design and refinement of data models from an analytical perspective to optimize reporting and insight generation
• Collaborate with stakeholders to gather requirements and deliver data-driven insights tailored to technical and non-technical audiences
• Leverage SQL and Python to query, manipulate, and analyze data across relational and cloud-based data platforms
• Assist in the development and validation of analytical datasets derived from ETL processes implemented by data engineering teams
• Identify opportunities to automate recurring analyses, reporting, and data validation tasks using scripting and analytical tools
• Support ad hoc analysis and time-sensitive data requests to inform operational decisions and leadership priorities
• Contribute to data governance efforts by promoting data standards, documentation, and proper data usage practices
• Present findings, insights, and recommendations through clear visualizations, written reports, and briefings

Qualifications for the Data Analyst:

• Bachelor's Degree in Mathematics, Computer Science, Information Systems, or a related field with 4+ years of experience in data analytics, business intelligence, data visualization, and reporting, with demonstrated ability to deliver actionable insights
• Strong proficiency in SQL for querying, transforming, and analyzing structured data across relational databases (e.g., Oracle, PostgreSQL, MySQL, Redshift)
• Proficiency in Python for data analysis, data manipulation, and automation (e.g., Pandas, NumPy)
• Demonstrated experience developing dashboards and reports using Tableau and/or Power BI, with a focus on usability and data storytelling
• Experience performing exploratory data analysis, statistical analysis, and data validation to support decision-making
• Ability to interpret and work with data pipelines and ETL outputs, partnering effectively with data engineers to ensure analytical readiness
• Experience working with cloud-based data environments (e.g., AWS S3, RDS, Redshift) for data access and analysis
• Strong analytical thinking and problem-solving skills, with the ability to translate ambiguous business questions into structured analyses
• Experience defining metrics, KPIs, and performance indicators aligned to business or mission outcomes
• Ability to communicate complex analytical findings clearly to both technical and non-technical stakeholders
• Experience supporting the full analytics lifecycle, including data acquisition, analysis, visualization, and delivery of insights
• Familiarity with data governance, data quality frameworks, and best practices in regulated or federal environments preferred
• Experience with version control tools (e.g., Git) and collaborative development environments preferred
• Active DHS clearance or active DoD Top Secret Clearance
• Desired Skills
  • Prior experience working with ETL tools like Informatica, Talend, or Airflow
  • Familiarity with automation tools (e.g., UiPath, Power Automate) and their integration into data pipelines
  • Experience working in environments requiring DHS Suitability Clearance is highly preferred.
  • Strong knowledge of change management processes and technologies (e.g., GitHub)
  • Knowledge of federal data governance standards and compliance frameworks.

Compensation for the Data Analyst:

• Salary Range: $130,000 - $145,000 *depending on experience*
• Comprehensive Benefits: Comprehensive Medical, Dental, Vision, 401k Plan, PTO, Holidays, Sick Leave if required by law

This job opens for applications on 04/02. Applications for this job will be accepted for at least 30 days from the posting date.

#LI-MS1

#LI-HYRBID

Keywords: Data Analyst, data analytics, advanced analytics, artificial intelligence, AI, machine learning, ML, business intelligence, BI, data-driven decision making, data transparency, data accessibility, data reliability, data structuring, data pipelines, ETL, data validation, data reconciliation, data quality, data integrity, data governance, data standards, data documentation, data usage practices, large datasets, big data, exploratory data analysis, EDA, statistical analysis, data profiling, trend analysis, pattern recognition, actionable insights, reporting, dashboard development, Tableau, Power BI, data visualization, data storytelling, KPI development, metrics, performance indicators, SQL, Python, Pandas, NumPy, scripting, automation, workflow automation, ad hoc analysis, relational databases, Oracle, PostgreSQL, MySQL, Redshift, cloud data platforms, AWS, S3, RDS, cloud analytics, data modeling, analytical datasets, data transformation, data manipulation, data querying, cross-functional collaboration, stakeholder engagement, requirement gathering, technical and non-technical communication, presentation skills, written reports, briefings, problem solving, analytical thinking, decision intelligence, analytics lifecycle, data acquisition, insight delivery, version control, Git, GitHub, collaborative development, ETL tools, Informatica, Talend, Airflow, automation tools, UiPath, Power Automate, federal environment, compliance frameworks, DHS Suitability Clearance, change management