Data Warehouse Specialist — Power BI & SQL (Federal)

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

Benefits offered by this job

Health, dental, and vision insurance

Life insurance

Disability insurance

401(k) with company matching

Flexible spending accounts

Paid leave

Professional development

Tuition assistance

Job summary

ZenPoint Solutions LLC is a rapidly expanding IT services company in the federal sector. We are seeking a Data Warehouse Specialist to analyze large datasets, develop data models, and create reports and visualizations that drive policy and operational improvements.

The role requires strong SQL skills, experience with Power BI, and the ability to work closely with federal personnel to ensure data quality, governance, and timely decision support. Onsite work in Arlington, VA is expected.

Qualifications

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

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.

Skills

Data analysis

SQL

Communication

Problem solving

Self-starter

Education

Bachelor’s degree

Tools

Tableau

Power BI

Microsoft Power Apps

Microsoft Office Suite

Job description

ZenPoint Solutions LLC is a rapidly expanding IT services company in the federal sector. We are seeking a Data Warehouse Specialist to analyze large datasets, develop data models, and create reports and visualizations that drive policy and operational improvements.

The role requires strong SQL skills, experience with Power BI, and the ability to work closely with federal personnel to ensure data quality, governance, and timely decision support. Onsite work in Arlington, VA is expected.