Data Engineer

JOB SUMMARY Support a Washington State agency implementing a modern analytics platform using Microsoft Fabric, Azure Data Services, and Power BI. This role focuses on data quality, validation, and testing activities to ensure analytics outputs are accurate, reliable, and aligned with business requirements. Key Responsibilities Execute data validation and testing aligned to data quality dimensions including completeness, accuracy, consistency, timeliness, uniqueness, and validity. Write SQL queries to validate transformations, aggregations, and business rules. Perform source to target reconciliation across bronze, silver, and gold data layers. Support validation of pipelines and data assets in Azure Data Factory, Azure Synapse, Azure SQL, and Microsoft Fabric. Validate Power BI datasets, measures, and reports against source data and defined KPIs. Assist with User Acceptance Testing and communicate data quality findings clearly. Develop and run automated data validation scripts using Python, pandas, and PySpark. Document test results, defects, and supporting evidence in Azure DevOps. Required Qualifications 2 to 5 years of experience in data testing, analytics, or data engineering support. Strong SQL skills including joins, CTEs, window functions, and aggregations. Understanding of data quality concepts and dimensional modeling basics. Experience with Azure data platforms such as Azure Data Factory, Azure Synapse, or Azure SQL. Experience validating Power BI datasets and reports. Python experience for data analysis or validation. Strong attention to detail and communication skills. Preferred Qualifications Exposure to Microsoft Fabric including lakehouses, warehouses, and OneLake. Experience with Great Expectations or dbt tests. Azure DevOps CI/CD exposure. Experience with Azure Data Lake Storage Gen2. Experience in public sector or regulated data environments. Certifications None specified. Education: Bachelors Degree