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.
Join us! In modernizing CBP’s data ecosystem and delivering impactful solutions for mission success!
- 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).
Desirable Qualifications:
- 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.
Top Skills
Similar Jobs
What you need to know about the Colorado Tech Scene
Key Facts About Colorado Tech
- Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
- Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
- Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
- Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute
