Data Warehouse/BI Developer Job at vTech Solution, Washington DC

Tyt4Q1hEVUUydEdLa015UldhdGR6SXFCUFE9PQ==
  • vTech Solution
  • Washington DC

Job Description

Job Summary:


This role involves designing, developing, testing, and supporting data-driven solutions within an Agile/Scrum environment. The successful candidate will lead and contribute to the implementation of scalable data warehouse and business intelligence systems, leveraging expertise in data architecture, integration, and analytics on cloud-native platforms. The position requires strong communication and collaboration skills to translate business needs into technical specifications and data pipelines.

Location: Washington, District of Columbia, Virginia, United States

Responsibilities:

- Design, develop, test, and support enterprise data warehouse and business intelligence solutions.
- Lead and contribute to the implementation of scalable data warehouse and BI systems.
- Develop and maintain star schema data models, fact and dimension tables, and metadata documentation.
- Build and maintain ETL/ELT processes using tools such as SQL Server Integration Services (SSIS) and Azure Data Factory.
- Develop and optimize complex SQL queries, stored procedures, and views for large datasets.
- Utilize data visualization and reporting tools, particularly Power BI Service.
- Integrate data from diverse sources (relational databases, flat files, APIs, cloud storage).
- Implement data governance, quality, and lineage principles.
- Collaborate with business stakeholders to gather requirements and translate them into technical specifications.
- Implement CI/CD pipelines for data integration workflows.
- Troubleshoot data anomalies, ETL failures, and performance bottlenecks.
- Document data models, workflows, and data contracts.
- Work within Agile/Scrum or DevOps environments.


Required Skills & Certifications:

- At least 3 years of hands-on experience designing, developing, and supporting enterprise data warehouse and business intelligence solutions.
- Strong proficiency with ETL/ELT tools (SSIS and Azure Data Factory).
- Experience with cloud-based data platforms (Azure Synapse Analytics or Microsoft Fabric).
- Proficiency in SQL development (complex queries, stored procedures, views, performance optimization).
- Experience building and maintaining star schema data models.
- Experience with data visualization and reporting tools (Power BI Service).
- Strong understanding of data governance, quality, and lineage principles.
- Experience integrating data from diverse structured and semi-structured sources.
- Familiarity with source control and DevOps practices, including CI/CD pipelines.
- Strong analytical and troubleshooting skills.
- Demonstrated ability to collaborate with business stakeholders.
- Strong written and verbal communication skills.
- Experience working in Agile/Scrum or DevOps environments.


Preferred Skills & Certifications:

- Microsoft certifications (Azure Data Engineer Associate or SQL Server certifications).
- Bachelor's degree in Computer Science, Information Systems, Data Science, or a related field.

Special Considerations:


- Commonwealth of Virginia security policies prohibit the use of offshore IT contractors; candidate must physically reside within the US for the duration of the assignment.

Scheduling:

- Not specified in provided text.

Job Tags

For contractors, Offshore,

Similar Jobs

Cliff Berry, Inc.

CDL Class A Driver Job at Cliff Berry, Inc.

 ...for YOU! Cliff Berry, Inc. is hiring a CDL Class A Driver . The new driver must...  ...days of hire and have at least 1 year of experience. Subject to working nights, weekends and...  ...Insurance ~401k ~ Life Insurance ~ Paid Time Off ~ Employee Assistant Program... 

FDR Financial Group

Data Analyst Internship Job at FDR Financial Group

 ...Description We are looking for a Data Analyst Intern to join FDR Financial Group, a leading financial services company. As a Data Analyst Intern, you will play a crucial role in analyzing and interpreting complex data sets to help drive business decisions and strategies... 

Magnus Technology Solutions

Software Developer Job at Magnus Technology Solutions

Job Title: Software Developer - Fresher Location: [Your City, State] | On-site/Remote/Hybrid Job Type: Full-time | Entry-levelAbout the Role: We are looking for enthusiastic and driven fresh graduates to join our development team as Software Developers. This is a great... 

UMMS

Rapid Response Team Registered Nurse part time Job at UMMS

Registered Nurse (RN) - Rapid Response Team | UMMC Downtown Part Time | Rotating Shifts Available: 7p-7a, 11a-11p, 7a-7p Come elevate your skills and experience by working with a world-class, Magnet designated Academic Medical Center! We are looking for candidates... 

PIA HOYT

Senior Paralegal Job at PIA HOYT

 ...levels of trial and appeal. Role Description This is a full-time, in office for a Senior Paralegal at PIA HOYT. Our office is downtown Salt Lake City at 170 S. Main Street (on the corner). As a Senior Paralegal, you will be responsible for legal document...