Data Warehouse Specialist - U.S. Citizenship Required

ZenPoint Solutions LLC; Arlington (VA); On-site; USD 116,000 - 130,000; Full time

Benefits offered by this job

Health, dental, and vision

Life insurance

Disability insurance

401(k) with match

Flexible spending accounts

Paid leave

Tuition assistance

Job summary

ZenPoint Solutions LLC in Arlington, VA seeks a Data Warehouse Specialist to support a federal program by collecting, analyzing, and interpreting large datasets to inform policy and decision‑making.

You will build data models, SQL queries, and Power BI reports, collaborating with federal personnel to ensure data quality, governance, and actionable insights. Onsite five days a week at the customer's facility.

Qualifications

• 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.
• 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
• Proven ability to work in a time-sensitive, deadline-driven environment and to communicate clearly with stakeholders

Responsibilities

• Perform data cleansing and standardization, assessing data quality and identifying trends.
• Plan and execute data migration strategies from legacy systems to modern databases.
• Create database queries using ANSI SQL or other programming languages.
• Create reports and dashboards leveraging Power BI.
• Ensure data integrity and governance across databases.
• Collaborate with federal personnel to develop data models and insights.
• Coordinate with team members to meet milestones and deadlines.

Skills

Data analysis

SQL programming

Communication

Problem solving

Self-motivation

Education

Bachelor’s degree in a relevant discipline

Tools

Tableau

Power BI

Microsoft Power Apps

Microsoft Office Suite

Job description

Description

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

Work Schedule (onsite): Five days onsite at the customer's facility

Position Overview: ZenPoint Solutions is seeking a Data Warehouse Specialist who will be integral in supporting a federal customer's program by collecting, analyzing, and interpreting large and complex datasets to inform policy, improve operations, and support mission‑critical decision‑making. The Data Warehouse Specialist will work closely with federal personnel to develop data models, reports, and visualizations that enhance transparency, compliance, and strategic outcomes. A qualified candidate can analyze data and compare data from different sources and has advanced experience with SQL.

Key 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

Required Qualifications:

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

Compensation: The salary range for the position is $116,000 - $130,000 and will be commensurate with experience.

Company Benefits:

• health, dental, and vision insurance to keep you and your family healthy.
• group and voluntary life insurance for financial security, and short‑term and long‑term disability insurance to provide peace of mind in case of unexpected illness or injury.
• 401(k)-retirement plan with company matching contributions to save for the future.
• flexible spending accounts to help manage medical and dependent care costs on a pre‑tax basis.
• paid leave policy, including federal holidays, to maintain a healthy work‑life balance.
• professional development opportunities and a tuition assistance program.

Commitment to Equality: At ZenPoint Solutions, we value diverse perspectives and are committed to providing equal employment opportunities. We welcome applications from all qualified individuals, regardless of race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, or any other status protected under applicable federal, state, or local laws.