Onsite Power BI & Data Engineering Specialist

Piper Companies; Norfolk (VA); Presencial; AUD 136.000 - 143.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Medical

Dental

Vision

401k Plan

Holidays

PTO

Sick leave

Descripción de la vacante

Zachary Piper Solutions seeks a Front-End/BI Data Engineer to join a team supporting government tools on the Navy's network. The role centers on Power BI, reporting, visualization, and data consumption, with hands-on data engineering to trace data origins and transformations.

The engineer will design dashboards, transform enterprise datasets for reporting, and collaborate with backend data engineers to optimize data for enterprise use.

Formación

• 3–4 years of hands-on Data Engineering, BI, or BI 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 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

Responsabilidades

• 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

Conocimientos

Power BI

Data visualization

SQL

ETL

Herramientas

Azure Data Factory

SQL Server

SSIS

PowerShell

Descripción del empleo

Zachary Piper Solutions seeks a Front-End/BI Data Engineer to join a team supporting government tools on the Navy's network. The role centers on Power BI, reporting, visualization, and data consumption, with hands-on data engineering to trace data origins and transformations.

The engineer will design dashboards, transform enterprise datasets for reporting, and collaborate with backend data engineers to optimize data for enterprise use.