Top 1 Datawarehouse Systems Analyst Jobs in Washington, DC

ETL Datawarehouse Architect
Donan Consulting —Washington, DC
- SQL
- Bachelor's degree
- Senior level
Quick Apply

Check out these similar jobs

Based on your search for Datawarehouse Systems Analyst jobs.

ETL Datawarehouse Architect
Donan Consulting —Washington, DC
Identify areas for improvement within the EDS organization related to architecture, design, performance optimization, development process, workflows, governance…
Quick Apply

I want to receive the latest job alert for Datawarehouse Systems Analyst in Washington, DC

By signing in to your account, you agree to SimplyHired's Terms of Service and consent to our Cookie and Privacy Policy.

ETL Datawarehouse Architect

Donan Consulting
Washington, DC

Quick Apply

Job Details

Qualifications

Data model design
Commercial use (data warehousing systems)
Data Integration (Data management)
Team supervision
Schema design
SQL
Query management
Project leadership
Dimensional modeling

Full Job Description

THE OVERALL PURPOSE OF POSITION:
•
The purpose of this position is to provide support to the IT department.

SCOPE OF WORK

•
Oversee and review work of team members, as needed or instructed.

•
Partner with scrum masters/ project managers on optimizing scheduling, work allocations, and story assignments.

•
Manage reporting environment including data sources, connections, security, subscriptions and metadata.

•
Lead in initiative towards data access control and integrity across the enterprise.

•
Create data models and schema for reliable and highly performant data marts and data warehouse.

•
Develops complex ETL (extract, transform and load) SQL scripts to gather data from various databases and systems to make data available for enterprise analytics and reporting.

•
Evaluate, test and implement new or upgraded software.

•
Troubleshoot reported problems pertaining to reports and the reporting database environment, working closely with other IT members, especially DBAs, Systems Analysts and Systems Engineers, identifying the cause and designing or developing an approach for resolution.

•
Assess impact of changes and updates to source production systems, planning and implementing resulting changes to reports.

•
Identify areas for improvement within the EDS organization related to architecture, design, performance optimization, development process, workflows, governance, tools/technologies.

•
Conduct end user training on data solutions.

QUALIFICATION AND EXPERIENCE:
•
Bachelor's degree and/or relevant technical training and certifications.

•
Five (5) to Seven (7) years of directly related experience.

•
Three (3) to Four (4) years of operational and/or technical business leadership experience.

•
Five (5) years of experience with OLAP, industry standard databases, structured query language, ETL, reporting.

•
Three (3) years of experience with data warehouse and data mart design, including Star and Snowflake models.

EDUCATION

•
Bachelor's degree with a strong academic record.

LENGTH OF EXPERIENCE

•
The minimum amount of total work-related experience required is five (5+) years, for the position. This means experience in a related area or time spent performing similar work that provides the background for the current position.

Quick Apply

Refine Your Search

Datawarehouse Systems Analyst jobs in Washington, DC

ETL Datawarehouse Architect

Check out these similar jobs

I want to receive the latest job alert for Datawarehouse Systems Analyst in Washington, DC

Job Seeker Tools

Employer Tools

Browse

Stay Connected