Data Warehouse Specialist - U.S. Citizenship Required

Job Type: Full-time.

About the role

ZenPoint Solutions LLC (“ZenPoint Solutions”) is a rapidly expanding Information Technology (IT) services company in the federal sector. We foster a thriving, ambitious work environment that prioritizes employee well-being and a positive company culture. We invite you to join our team and help us shape a dynamic future as we deliver innovative solutions to address the nation's most critical IT missions.

Clearance Requirement: None at the time of application. Candidates must be able to attain Moderate Risk Background Investigation (MBI) Public Trust T3 case type.

Work Location: Arlington, VA.

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.

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.