Power BI Analytics Developer (ETL & Dashboards)

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

Job summary

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

The role focuses on developing and maintaining Power BI dashboards, improving Excel/SharePoint/SQL data structures, and building ETL processes to move data from legacy sources to modern databases. The ideal candidate will have strong analytical skills with experience in database management or data migration (ETL) and will work with business leaders to

Qualifications

• Desirable Skills: Beginner / Intermediate proficiency with Power Automate
• Beginner proficiency with ETL technology such as R, Python, SQL, or SSIS
• Functional Application Development Documentation proficiency

Responsibilities

• Collect, clean, and organize data from various sources into Power BI dashboards to display actionable insights to leadership and identify trends, patterns, and anomalies
• Perform detailed analysis of datasets using Excel and other analytical tools to derive actionable insights
• Manage Excel, SharePoint, and SQL database structures that store data fed to the Power BI dashboards
• Present findings and insights to key stakeholders in a clear and understandable manner, using Excel and Power BI
• Extract, transform, and load data from legacy databases such as Excel, SharePoint, and Access databases to modernized databases
• Replace ETL technology such as R-Studio and Informatica with Power Automate
• Advanced proficiency with Microsoft Power BI
• Advanced proficiency with Microsoft Excel
• Intermediate proficiency with SQL
• Beginner proficiency with relational database management systems (RDBMS) architecture and database administration

Skills

Power BI

Excel

SQL

ETL

Data analysis

Tools

Power Automate

R-Studio

Informatica

SSIS

Job description

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

The role focuses on developing and maintaining Power BI dashboards, improving Excel/SharePoint/SQL data structures, and building ETL processes to move data from legacy sources to modern databases. The ideal candidate will have strong analytical skills with experience in database management or data migration (ETL) and will work with business leaders to