Job description

Job DescriptionJob Description We are seeking a detail-oriented and motivated Data Analyst to support the U.S. Customs and Border Protections (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 CBPs 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 security missions, we encourage you to apply and become part of our team. • **Must meet CBP security requirements*** Join us! In modernizing CBPs 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. Bachelors degree (required). Masters 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 . An active security clearance is required. Benefits The wage range for this role takes into account the wide range of factors that are considered in making compensation decisions including but not limited to skill sets; experience and training; licensure and certifications; and other business and organizational needs. The disclosed range estimate has not been adjusted for the applicable geographic differential associated with the location at which the position may be filled. At TechOp, it is not typical for an individual to be hired at or near the top of the range for their role and compensation decisions are dependent on the facts and circumstances of each case. A reasonable estimate of the current range is $75,000 to $95,000.00. #J-18808-Ljbffr ZipRecruiter

Requirements