Front-End/BI Data Engineer - 174511

Piper Companies; Norfolk (VA); On-site; AUD 135,000 - 142,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

401k Plan

Holidays

PTO

Sick leave

Job summary

Zachary Piper Solutions is seeking a Front-End/BI Data Engineer to support the US Navy in a 100% onsite role, open to candidates in Norfolk, VA. The engineer will design and maintain Power BI dashboards, reports, and enterprise reporting solutions, ensuring data pipelines meet reporting needs.

You will work with backend data engineers, understand ETL pipelines, and ensure data quality across legacy and enterprise systems while leveraging Azure Data Factory and SQL in a DoD-friendly environment.

Qualifications

• 3–4 years of hands-on Data Engineering, BI, or BI reporting experience.
• Active Secret clearance required.
• IAT Level II certification required.
• Strong hands-on experience with Power BI, including building reports & dashboards.
• Experience with SQL and SQL databases.
• Understanding of ETL/data transformation, staging, aggregation, and data pipelines.
• Experience with enterprise datasets and reporting preparation.
• Experience integrating data from multiple, disparate, or legacy systems.
• Azure Data Factory experience to support pipelines feeding reporting.

Responsibilities

• Design, develop, and maintain Power BI dashboards, reports, and enterprise reporting solutions.
• Translate business 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 data is available and optimized for reporting.
• Understand data pipelines, transformations, staging processes, and repositories supporting reporting.
• Develop SQL queries and work with SQL databases to prepare data for reporting.
• Identify data quality issues and data gaps affecting reporting accuracy.
• Work with data from legacy, disparate, and enterprise systems to feed reporting.
• Support data ingestion and transformation activities including Azure Data Factory (ADF).
• Develop dashboards and reports that make complex data accessible to stakeholders.
• Optimize Power BI reports, data models, queries, and visualizations for enterprise use.
• Collaborate with backend data engineers on data requirements and reporting architecture.
• Document reporting solutions and data dependencies.

Skills

Power BI

SQL

ETL

Azure Data Factory

IAT Level II

Secret clearance

Tools

SQL Server

SSIS

PowerShell

XML

Job description

Zachary Piper Solutions is seeking a Front-End/BI Data Engineer to support the USN. This role is 100% onsite and is open to candidates in Norfolk, VA. The Front-End/BI Data Engineer will join a small team that supports and manages government tools connected to the Navy's enterprise network. As the team's mission continues to expand into enterprise data, this engineer will help turn transformed and aggregated datasets into usable business intelligence, dashboards, reports, and enterprise-facing data products. This position is primarily focused on the Power BI, reporting, visualization, and data-consumption layer, while still requiring enough hands‑on data engineering knowledge to understand where data comes from, how it is transformed, and how reporting requirements affect the underlying data pipeline.

Responsibilities of the Front-End/BI Data Engineer

• 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

Qualifications of the Front-End/BI Data Engineer

• 3–4 years of hands-on Data Engineering, Business Intelligence, or BI/Data Reporting experience
• Active Secret clearance
• IAT Level II certification
• Strong hands‑on experience with Power BI, including building reports & dashboards
• Experience working directly with SQL and SQL databases
• Understanding of ETL/data transformation, staging, aggregation, and data pipelines
• Experience working with enterprise datasets and preparing data for reporting
• Experience integrating or working with data from multiple, disparate, or legacy systems
• Sufficient Azure Data Factory experience to understand and work with the pipelines feeding downstream reporting
• Ability to work across the data lifecycle and understand how source data → pipelines → transformation → repositories → reporting fit together
• Preferred: Azure Data Factory (ADF), Python, PowerShell, XML, SSIS, Azure/cloud data environments, data modeling, enterprise BI/data warehousing, Splunk

Compensation for the Front-End/BI Data Engineer

• Salary: $95,000–100,000 depending on experience
• Benefits: Medical, Dental, Vision, 401k Plan, Holidays, PTO, sick leave as required by law

Keywords

Power BI, Business Intelligence, BI, BI Developer, BI Engineer, Data Visualization, Dashboard Development, Reporting, Enterprise Reporting, SQL, SQL Server, Data Modeling, DAX, Power Query, M, ETL, ELT, Azure, Azure Data Factory,ADF, Data Transformation, Data Warehouse, Data Engineering, Data Integration, Azure Data Factory, ADF, Data Engineering, Data Pipelines, ETL, ELT, Data Integration, SQL, SQL Server, Data Transformation, Data Staging, Data Aggregation, Data Ingestion, Data Migration, Legacy Systems, System Integration, Data Warehouse, Data Repository, SSIS, Azure, Python, PowerShell, XML, Security, Clearance, DoD Secret, Active Secret Clearance, IAT Level II, Security+, DoD 8570, 8570, dod cleared, dod clearance, secret clearance, secret, secret cleared, secret security clearance, security clearance, security cleared, sec+, sec +, s+, security+, security +, "sec plus, secplu, securityplus, security plus, CompTIA Sec+, Comptiasecurity, cysa+, cysa +, cysa plus, cysa plus, cybersecurity +, cybersecurity+, cyber security +, cyber security plus, iat2, iatii, iattwo, "iat ii, iat two, iat 2, iat level ii, iat levelii, iat level 2, iat level two

#LI-SW1 #LI-ONSITE