Data Analyst (Power Platform) Job at TechOp Solutions International, Washington DC

QTZZTGJUYWhGWEVJNmU5UDV3NncvSExvK1E9PQ==
  • TechOp Solutions International
  • Washington DC

Job Description

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).

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.

Job Tags

Full time,

Similar Jobs

Morris Group, Inc.

Warehouse Supervisor Job at Morris Group, Inc.

 ...advantage in the world economy by improving productivity. Summary of Responsibility: We are looking for an effective Warehouse Supervisor to oversee the daily operations of a warehouse, managing staff, inventory, and the flow of materials in and out of the facility... 

Summit 7 Systems

Cisco Engineer Job at Summit 7 Systems

 ...Position Title: Cisco Engineer Clearance: Desired, not required Location: Huntsville, AL/Remote Salary...  ...to detail. Strong communication and collaboration skills. CCIE certification. Qualifications - Optional/Desired Relevant... 

SHENZHEN AMERICAN INTERNATIONAL SCHOOL

Chinese Homeroom Teacher Job at SHENZHEN AMERICAN INTERNATIONAL SCHOOL

Responsible for daily homeroom teaching and student management. - Cooperates closely with the Chinese Homeroom Teacher to plan and implement the class teaching plan. - Teach transdisciplinary units based on the Common Core State Standards, covering the scope of IB PYP... 

The International Center for TMJ and Jaw Surgery

Oral Surgery Assistant Job at The International Center for TMJ and Jaw Surgery

 ...Job Description: We are seeking a highly skilled and dedicated Oral Surgery Assistant to join our dynamic team. The ideal candidate will have experience assisting oral surgeons in a clinical setting, providing patient care, and ensuring a smooth flow of operations during... 

DrHouse, Inc.

Telehealth Physician - Specialists in Cardiology, Endocrinology, Rheumatology, GI, Dermatology, Pulmonary, or Allergy/Asthma - Part Time or Full Time @DrHouse Job at DrHouse, Inc.

 ...to ensure comprehensive, patient-centered care. Stay informed on the latest guidelines and innovations in your specialty and telemedicine best practices. Qualifications: Board certification in one or more of the following: Cardiology, Endocrinology, Rheumatology...