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

cUtpTWp4Q0duZHZQcEM5UDZjWld4YW00WlE9PQ==
  • 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.

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

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 .

Job Tags

Similar Jobs

Hawthorn Innovations

Graphic Designer Job at Hawthorn Innovations

 ...day. Our work spans digital advertising, product and industrial design, print, OOH/BTL campaigns, billboards, retail mechanicals, animation, illustration, and beyond and we need a well-rounded Graphic Designer who thrives in a fast-paced, high-impact environment.... 

Walmart

Senior Analyst, Business operations ecommerce Job at Walmart

 ...What you'll do...**Are you looking for a rewarding career within eCommerce? Do you consider yourself to have a strategic mindset? If so,...  ...Senior Analyst " Business Operations eCommerce position at Walmart!We are seeking an experienced and proactive Senior Analyst, Business... 

Figma

Remote Sales Recruiter Job at Figma

 ...hire an experienced full-life cycle Sales Recruiter to support the organization through its...  ...scope of role), market demands, and specific work location. The listed range is a guideline...  ...& development stipend, a work from home stipend, and cell phone reimbursement. Figma... 

Pronghorn

APL Analyst Intern Job at Pronghorn

 ...innovation, diversity, and leadership. Our Spirits Internship Program (SIP) offers a unique 10-week paid experience designed for college students and graduating seniors to gain hands-on exposure to the business of Spirits, entrepreneurship, and brand-building. SIP... 

American Exchange Group

Sales Assistant, Home Division Job at American Exchange Group

 ...to major retailers. Visit our website at Job Title: Sales Assistant Department: AXNY Home (Bedding & Bath) Location:...  ...holidays ~ Flexible Fridays with shortened hours during both Summer and Winter seasons ~ Health Savings Accounts (HSAs)~ Flexible...