BI Engineer - Data Warehousing & ETL Specialist

U.S. Department of Veterans Affairs; Oklahoma; On-site; USD 95,000 - 135,000; Full time

Job summary

U.S. Department of Veterans Affairs is seeking a Business Intelligence Engineer to join our in-person team in Oklahoma. The role focuses on data migration, ETL pipelines, data warehousing, and BI solutions using Microsoft technologies like Power BI and Azure Data Factory.

You will analyze source/target systems, develop data mappings, and build dashboards and reports to support operational needs. Applicants must be authorized to work in the United States without visa sponsorship.

Qualifications

• Strong proficiency in SQL, database development, administration, performance tuning, troubleshooting, and security.
• Experience with ETL development, data migration, data warehousing, BI platforms, and large relational and dimensional data models.
• Experience with Microsoft BI technologies Power BI, and/or Azure Data Factory.
• Ability to use AI tools to improve data quality, develop and troubleshoot transformations using SQL, Python, Power Query/M, and DAX, perform exploratory and statistical analysis, and enhance data modeling, visualization, and reporting.
• Knowledge of conceptual, logical, and physical data modeling concepts.

Responsibilities

• Analyze source and target systems, data structures, constraints, and business requirements to develop data mappings and transformation logic.
• Develop, execute, and maintain ETL pipelines using SQL, SSIS, Azure Data Factory (ADF), or equivalent tools to migrate data and populate data warehouses and data marts.
• Perform data profiling, cleansing, deduplication, quality checks, reconciliation, and pre- and post-migration validation, including identification of county-specific anomalies.
• Support migration planning, dry runs, cutovers, incremental data loads, rollback procedures, and post-deployment stabilization.
• Design, develop, deploy, and maintain secure, highly available data warehouses, data marts, and BI solutions using Microsoft BI technologies.
• Develop and maintain dashboards, reports, analytical models, SQL queries, stored procedures, and data visualizations that support operational and business needs.
• Translate business requirements into actionable reporting and analytics solutions, documenting report purpose, business logic, and dependencies.
• Develop data monitoring models and establish strategies for data acquisition, transformation, warehousing, reporting, and analytics.
• Design, develop, and maintain database objects, including tables, indexes, views, stored procedures, functions, ETL packages, analytical models, and reports.
• Monitor and optimize database performance, reliability, scalability, and security across development, testing, staging, and production environments.
• Manage database deployments, updates, and migrations across environments while maintaining data integrity and operational standards.
• Provide guidance and support to database administrators and application developers on database design, development, deployment, and performance tuning.
• Maintain data dictionaries, mappings, lineage, database architecture, and implementation documentation.
• Ensure data accuracy, integrity, confidentiality, security, retention, and compliance with MIS standards and court privacy requirements.

Skills

SQL proficiency

ETL development

Data migration

Data warehousing

BI platforms

Dimensional data models

Power BI

Azure Data Factory

Python

Power Query/M

DAX

AI tools for data quality

Data modeling concepts

Job description

U.S. Department of Veterans Affairs is seeking a Business Intelligence Engineer to join our in-person team in Oklahoma. The role focuses on data migration, ETL pipelines, data warehousing, and BI solutions using Microsoft technologies like Power BI and Azure Data Factory.

You will analyze source/target systems, develop data mappings, and build dashboards and reports to support operational needs. Applicants must be authorized to work in the United States without visa sponsorship.