Data Analytics Developer

PVH (Tommy Hilfiger/Calvin Klein); Washington (District of Columbia); On-site; USD 70,000 - 95,000; Full time

Job summary

PVH Corp is seeking a detail-oriented Data Analyst to support the U.S. Customs and Border Protection's Power Platform team by developing, maintaining, and enhancing Power BI dashboards, and refining Excel, SharePoint, and SQL data sources.

The role emphasizes creating ETL processes to move data from legacy systems to modern databases, collaborating with leadership, and presenting insights clearly. Join a team that supports 10,000+ users annually and helps drive data-driven decisions across the

Qualifications

• Advanced proficiency with Power BI.
• Advanced proficiency with Excel.
• Intermediate proficiency with SQL.
• Beginner proficiency with RDMS architecture and database administration.

Responsibilities

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

Skills

Power BI

Excel

SQL

RDMS architecture

Job description

Position Overview

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.

Responsibilities

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

Required Skills

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