Data Analytics Developer

Hybrid in Washington, DC, US • Posted 4 hours ago • Updated 4 hours ago
Full Time
No Travel Required
Hybrid
90000 - 100000/yr
Fitment

Dice Job Match Score™

⏳ Almost there, hang tight...

Job Details

Skills

  • TOP SECRET DOD CLEARANCE
  • CBP/ICE Public Trust

Summary

We are seeking a detail-oriented Data Analyst to join our team and contribute to our data-driven decision-making processes. The candidate will support the U.S. Customs and Border Protection’s Power Platform team by developing, maintaining, and enhancing Power BI dashboards, improving the structure of Excel, SharePoint, and SQL databases that feed into the Power BI dashboards, and creating ETL (Extract, Transform, Load) processes to facilitate the movement of data from legacy databases such as Excel and SharePoint to modernized databases such as SQL. The team’s current Power Platform solutions are utilized by 10,000+ users annually. The ideal candidate will possess a strong analytical mindset coupled with experience in database management or data migration (ETL).

  • Collect, clean, and organize data from various sources into Power BI dashboards to display actionable insights to leadership and identify trends, patterns, and anomalies
  • Perform detailed analysis of datasets using Excel and other analytical tools to derive actionable insights
  • Manage Excel, SharePoint, and SQL database structures that store data fed to the Power BI dashboards
  • Present findings and insights to key stakeholders in a clear and understandable manner, using Excel and Power BI
  • Extract, transform, and load data from legacy databases such as Excel, SharePoint, and Access Databases to modernized databases
  • Replace ETL technology such as R-Studio and Informatica with Power Automate
  • Advanced proficiency with Microsoft PowerBI
  • Advanced proficiency with Microsoft Excel
  • Intermediate proficiency with SQL
  • Beginner proficiency with Relationship Database Management Systems (RDMS) architecture and database administration
  • Desirable Skills:
  • Beginner / Intermediate proficiency with Power Automate
  • Beginner proficiency with ETL technology such as R, Python, SQL, or SSIS
  • Functional Application Development Documentation proficiency
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: PTPfDlXrJvsFffq
  • Position Id: 9037646
  • Posted 4 hours ago
Contact the job poster
RC

RAYMOND COLE

Recruiter @ TechOp Solutions
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Springfield, Virginia

Today

Full-time

USD 85,000.00 - 110,000.00 per year

Washington, District of Columbia

Today

Full-time

Remote or McLean, Virginia

Today

Full-time

Washington, District of Columbia

Today

Full-time

USD 88,400.00 - 154,700.00 per year

Search all similar jobs