Data Warehouse Specialist - U.S. Citizenship Required

ZenPoint Solutions•Arlington, VA

6d•$116,000 - $130,000•Onsite

About The Position

ZenPoint Solutions LLC is seeking a Data Warehouse Specialist to support a federal customer's program. This role involves collecting, analyzing, and interpreting large and complex datasets to inform policy, improve operations, and support mission-critical decision-making. The specialist will collaborate with federal personnel to develop data models, reports, and visualizations that enhance transparency, compliance, and strategic outcomes. The ideal candidate can analyze data from different sources, compare datasets, and possesses advanced SQL experience.

Requirements

Candidate must be a United States Citizen and present proof of Citizenship, if selected
Bachelor’s degree in a relevant discipline from an accredited institution of higher learning.
5+ years of hands-on experience with data architecture, data management, data analysis, IT process reengineering, systems analysis, design, and implementation, and data modeling
Hands-on experience with data migration / integration of multiple data sources into a single repository.
Strong data analysis skills
Advanced proficiency in SQL programming language (e.g., ANSI SQL)
Familiarity with reporting / ad-hoc analysis tools such as Tableau and Power BI
Knowledge of master data management principles
Experience with data integration and data migration
Experience with Microsoft Power Apps
Expert-level proficiency in the Microsoft Office Suite (Word, Excel, PowerPoint, SharePoint)
Excellent communication, consultation, conflict resolution, negotiation, and facilitation skills.
Able to contribute to creating, refining, and documenting team business processes (e.g., in SOPs, design documents, process diagrams, etc.) in a highly flexible environment.
Be flexible and able to thrive in a time-sensitive environment to meet strict deadlines with sudden and unpredictable needs.
Independently synthesize unstructured feedback from stakeholders and consider relevant data to present quality business solutions.
Proven problem-solving skills with demonstrated ability to think out of the box and generate creative solutions; ability to break a complex problem down into its component parts and arrive at the appropriate solution in a timely fashion.
Positive attitude, averse to the status quo, always looking to improve current processes and procedures; ability to see opportunities for change, capitalize on them, and implement them when appropriate for the benefit of the organization.
A self-starter with a strong work ethic who sets high standards for self and others and demonstrates enthusiasm for the mission of the team.

Responsibilities

Perform data cleansing and standardization (e.g., removing duplicates, sanitization), assessing data quality, and eliminating irrelevant data to identify and interpret data patterns and trends.
Plan and execute data migration strategies from legacy systems to modern databases.
Assess data repositories for compliance with data governance policies and standards.
Create database queries using ANSI SQL or other programming languages.
Create reports/dashboards leveraging Power BI.
Analyze data from various systems and formats and audit databases regularly to maintain data quality.
Ensure data integrity and data standards within databases.
Provide enterprise data solutions and enhance reporting capabilities.
Maintain current databases and database objects.
Coordinate with other team members to reach project milestones and deadlines.
Identify areas for improvement in the current process.
Collaborate and work with business users and IT partners to remediate identified gaps, using both manual and automated solutions.
Recommend processes and create reports to continuously monitor data quality.