Power BI Data Engineer: Front-End & Visualization (Onsite)

Zachary Piper Solutions; Norfolk, Northern (VA, KY); Hybrid; USD 95,000 - 100,000; Full time

Benefits offered by this job

Medical

Dental

Vision

401k Plan

Holidays

PTO

Sick leave

Job summary

Zachary Piper Solutions is seeking a Front-End/BI Data Engineer to support the US Navy. This role is 100% onsite in Norfolk, VA, joining a small team that maintains government tools connected to the Navy's enterprise network.

The engineer will transform datasets into usable BI, dashboards, reports, and enterprise data products focused on Power BI, reporting, and visualization. The position requires 3–4 years of data engineering/BI experience, active Secret clearance, IAT Level II, and strong

Qualifications

• 3–4 years of hands‑on Data Engineering, BI, or BI/Data Reporting experience.
• Active Secret clearance.
• IAT Level II certification.
• Strong hands‑on Power BI experience building reports and dashboards.
• Experience with SQL and SQL databases.
• Understanding of ETL/data transformation, staging, aggregation, and data pipelines.
• Experience with enterprise datasets and reporting.
• Experience integrating data from multiple, disparate, or legacy systems.
• Sufficient Azure Data Factory experience to understand pipelines feeding reporting.
• Knowledge of source data pipelines, transformation repositories, and reporting.
• Preferred: Azure Data Factory (ADF), Python, PowerShell, XML, SSIS, Azure/cloud data environments, data modeling, enterprise BI/data warehousing, Splunk.

Responsibilities

• Design, develop, and maintain Power BI dashboards, reports, and enterprise reporting solutions.
• Translate business and technical requirements into meaningful data visualizations and reporting products.
• Work with transformed and aggregated enterprise datasets to develop reporting solutions.
• Partner with backend data engineers to ensure the appropriate data is available, structured, and optimized for reporting.
• Understand the underlying data pipelines, sources, transformations, staging processes, and repositories that support reporting.
• Develop SQL queries and work directly with SQL databases to investigate, validate, and prepare data for reporting.
• Help identify data quality issues, inconsistencies, and gaps that impact reporting accuracy.
• Work with data from legacy, disparate, and enterprise systems and understand how those systems feed downstream reporting.
• Support data ingestion and transformation activities when necessary, including working with Azure Data Factory (ADF).
• Develop dashboards and reports that make complex enterprise data accessible and actionable to technical and business stakeholders.
• Optimize Power BI reports, data models, queries, and visualizations for enterprise use.
• Collaborate with backend data engineering resources on data requirements, pipeline dependencies, and reporting architecture.
• Document reporting solutions, data sources, data relationships, and technical dependencies.

Skills

Power BI

SQL

Data Visualization

ETL / Data Transformation

Azure Data Factory

Data Pipelines

Security Clearance

DAX

Cloud Data

Reporting

Education

IAT Level II certification

Active Secret clearance

Tools

Power BI

Azure Data Factory

Job description

Zachary Piper Solutions is seeking a Front-End/BI Data Engineer to support the US Navy. This role is 100% onsite in Norfolk, VA, joining a small team that maintains government tools connected to the Navy's enterprise network.

The engineer will transform datasets into usable BI, dashboards, reports, and enterprise data products focused on Power BI, reporting, and visualization. The position requires 3–4 years of data engineering/BI experience, active Secret clearance, IAT Level II, and strong