TechOp Solutions International · 17 hours ago
Data Analyst (Power Platform)
Washington, DC
Full-time
Hybrid
Mid Level
3+ years expTechOp Solutions International is seeking a detail-oriented and motivated Data Analyst to support the U.S. Customs and Border Protection's Office of Facilities and Asset Management. The role involves developing and maintaining Power BI dashboards, improving database structures, and supporting the modernization of legacy data systems to enhance data-driven decision-making.
Information Technology & Services
No H1B
U.S. Citizen Only
Responsibilities
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
Qualification
Required
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)
Preferred
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
Company
TechOp Solutions International
TechOp Solutions International provides solutions to technology and operational related matters.
51-200 employees
Funding
Current Stage
Growth StageLeadership Team
Crawford Cole
Co-Founder & Partner
Company data provided by crunchbase