Senior Data Warehouse Consultant

AllianceIT Inc; Richmond (VA); Remote; USD 80,000 - 110,000; Full time

Job summary

An established industry player is seeking a talented Data Warehouse / BI Developer to join their dynamic team. This role focuses on designing and developing data solutions that empower decision-making in a fast-paced Agile environment. The ideal candidate will have extensive experience in data warehouse design, ETL processes, and cloud data platforms. You'll collaborate closely with stakeholders to translate requirements and ensure data integrity. If you're passionate about leveraging data for impactful insights and thrive in a collaborative atmosphere, this opportunity is perfect for you.

Qualifications

• 3+ years in data warehouse and BI solutions design and support.
• Experience with ETL tools and cloud data platforms is essential.

Responsibilities

• Design and support data solutions in an Agile/Scrum environment.
• Lead the development of scalable data warehouse and BI systems.

Skills

Data warehouse & BI solutions design

ETL/ELT tools (SSIS, Azure Data Factory)

Cloud data platforms (Azure Synapse Analytics)

SQL development

Data modeling with star schemas

Data visualization with Power BI

Data governance principles

Data integration from diverse sources

Source control and DevOps practices

Troubleshooting data anomalies

Strong communication skills

Agile/Scrum experience

Education

Bachelor’s degree in CS, IS, Data Science

Tools

Power BI

Azure Data Factory

SSIS

Azure Synapse Analytics

Job description

4 days ago Be among the first 25 applicants

Get AI-powered advice on this job and more exclusive features.

Direct message the job poster from AllianceIT Inc

Talent Acquisition Specialist & Bench Sales Recruiter @Alliance IT Inc

Job Title: Data Warehouse / BI Developer

Duration: (1 year Extension)

Note: Local to VA and DL is a Must.

Interview Type - In-Person Only

Work Arrangement – Remote

Note: Microsoft certifications such as Azure Data Engineer Associate (DP-203) or SQL Server certification are preferred.

Full Job Description -

This position will work in an Agile/Scrum environment with an existing data and analytics team to design, develop, test, and support data solutions that enable decision-making. The candidate will lead and contribute to designing scalable data warehouse and BI systems, applying data architecture, integration, and analytics principles. Experience with cloud-native data warehousing, ETL development, and enterprise data management is required.

Skills Matrix -

Skill Required / Desired | Experience

• Data warehouse & BI solutions design, support | 3+ Years

• ETL/ELT tools such as SSIS and Azure Data Factory | 3+ Years

• Cloud data platforms like Azure Synapse Analytics or Microsoft Fabric | 3+ Years

• SQL development, complex queries, stored procedures, performance tuning | 3+ Years

• Data modeling with star schemas, fact/dimension tables | 3+ Years

• Data visualization/reporting with Power BI Service | 3+ Years

• Data governance, quality, lineage principles | 3+ Years

• Data integration from diverse sources including relational DBs, flat files, APIs, cloud storage | 3+ Years

• Source control and DevOps practices, CI/CD pipelines | 3+ Years

• Troubleshooting data anomalies, ETL failures, performance issues | 3+ Years

• Collaborating with stakeholders to translate requirements | 3+ Years

• Strong communication skills in documenting data models and workflows | 3+ Years

• Agile/Scrum or DevOps experience | 3+ Years

• Certifications like Azure Data Engineer Associate (DP-203) or SQL Server | 3+ Years

• Bachelor’s degree in CS, IS, Data Science, or related field (highly desirable) | 3+ Years

Seniority level

• Mid-Senior level

Employment type

• Contract

Job function

• Information Technology

Industries

• IT Services and IT Consulting

Referrals increase your chances of interviewing at AllianceIT Inc by 2x

Get notified about new Data Warehouse Consultant jobs in Richmond, VA.