Power BI Data Analytics Engineer (ETL & Dashboards)

TechOp Solutions International; Washington (District of Columbia); On-site; USD 85,000 - 120,000; Full time

Job summary

TechOp Solutions International is seeking a detail-oriented Data Analyst to join its team and support the U.S. Customs and Border Protection Power Platform initiatives.

The role focuses on building, maintaining, and enhancing Power BI dashboards, structuring Excel, SharePoint, and SQL data stores, and developing ETL processes to move data from legacy systems to modern databases. You will analyze data to identify trends and anomalies, present insights to leadership, and collaborate with

Qualifications

• Collect, clean, and organize data to create Power BI dashboards.
• Perform detailed analysis of datasets using Excel and related tools.
• Manage Excel, SharePoint, and SQL database structures feeding dashboards.
• Present findings to leadership in a clear, actionable format.
• Extract, transform, and load data from legacy databases to modern systems.
• Replace ETL tech with Power Automate where feasible.
• Proficient with Power BI, Excel; intermediate SQL; basic RDMS concepts.

Responsibilities

• Build and maintain Power BI dashboards to display actionable insights.
• Clean and centralize data from multiple sources for leadership review.
• Optimize Excel, SharePoint, and SQL data stores used by dashboards.
• Develop ETL processes to move data from legacy databases to SQL platforms.
• Present findings to stakeholders in clear, concise terms.

Skills

Power BI

Excel

SQL

ETL

Power Automate

Data analysis

Data migration

Tools

Power BI

Excel

SharePoint

SQL

Power Automate

R-Studio

Informatica

Access

Job description

TechOp Solutions International is seeking a detail-oriented Data Analyst to join its team and support the U.S. Customs and Border Protection Power Platform initiatives.

The role focuses on building, maintaining, and enhancing Power BI dashboards, structuring Excel, SharePoint, and SQL data stores, and developing ETL processes to move data from legacy systems to modern databases. You will analyze data to identify trends and anomalies, present insights to leadership, and collaborate with