Data Analyst (Power Platform)

We are seeking a detail-oriented and motivated Data Analyst to support the U.S. Customs and Border Protection's (CBP) Office of Facilities and Asset Management (OFAM) within the Power Platform Team. The team develops and maintains Power Platform solutions used by over 10,000 users annually. In this role, you will play a critical part in enhancing CBP's data-driven decision-making by developing and maintaining Power BI dashboards, improving database structures, and supporting modernization of legacy data systems.

The ideal candidate will combine a strong analytical mindset with practical experience in database management, data migration (ETL), and advanced use of Excel and Power BI. Experience supporting cross-functional teams, creating actionable insights, and briefing leadership on analytical findings will be key to success.

This position requires an in-office presence in Washington, D.C. at least two times per week, with the potential for increased on-site presence as mission needs evolve.

If you are passionate about leveraging data to drive operational efficiency and supporting national security missions, we encourage you to apply and become part of our team.

Must meet CBP security requirements

Join us! In modernizing CBP's data ecosystem and delivering impactful solutions for mission success!

Requirements

• Must meet CBP security requirements
• Collect, clean, and organize data from various sources into structured datasets feeding Power BI dashboards.
• Develop and maintain Power BI dashboards that provide actionable insights to leadership.
• Perform detailed analysis of datasets using Excel and other analytical tools to identify trends, patterns, and anomalies.
• Manage and optimize Excel, SharePoint, and SQL database structures that feed Power BI dashboards.
• Present findings and insights clearly to stakeholders, using visualization tools such as Excel and Power BI.

• Bachelor's degree (required). Master's degree holders may have reduced experience requirements.
• 3+ years of experience supporting data analytics, database management, or business intelligence efforts.
• Intermediate to advanced proficiency with Microsoft Power BI.
• Intermediate proficiency with Microsoft Excel.
• Intermediate proficiency with SQL.
• Beginner proficiency with Relational Database Management Systems (RDBMS).

• Beginner to intermediate proficiency with Power Automate .
• Beginner proficiency with ETL technologies such as R, Python, SQL, or SSIS.
• Advanced understanding of RDBMS architecture and database administration.
• Experience with Functional Application Development Documentation .
• Create ETL pipelines to transition data from legacy databases (Excel, SharePoint, Access) to modernized SQL databases .
• Modernize ETL workflows by replacing RStudio and Informatica with Power Automate .

An active security clearance is required.

Qualification

Bachelor's Degree