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

eDFSVTNqU2hKbmhvZUY2Z2xBbE54SHVJK3c9PQ==
  • 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

Lensa

Product Photographer Job at Lensa

 ...Gear along with a handful of other lines and various accessory products. Become a vital member of our team and our growth. Basic...  ...outside team members. Maintain our in-house studio and all photography, video, lighting, and related computer equipment. Partner with... 

HarveStaff

Mid-Level Biologist Job at HarveStaff

 ...Specific experience in AAV (adeno-associated virus) vector manufacturing and testing Experience with sterile techniques, plant pathology, or nematology (preferred) Strong attention to detail, organization, and teamwork Self-motivated, adaptable, and reliable... 

CenterWell

Senior Specialty Consultative Pharmacist Job at CenterWell

 ...first**The Senior Specialty Consultative Pharmacist integrates clinical programs to improve...  ...Senior Specialty Consultative Pharmacist work assignments involve moderately complex to...  ...schedule**Work Style** : Remote**Work at Home/Remote Requirements**To ensure Hybrid... 

Fair Oaks Farms Management LLC

Graphic Production Design Job at Fair Oaks Farms Management LLC

Graphic Production Design Location Fair Oaks, IN : Select Milk Producers is one of the nation's largest and most progressive dairy cooperatives...  ...and advanced experience within the Adobe Creative Suite, photography/video platforms, with ability to cross platform within MAC... 

Mead & Hunt

CAD/BIM Designer Job at Mead & Hunt

 ...at least six (6) years of relevant experience The ideal candidate will have all of the following: Experience with Revit, AutoCAD, Navisworks and related CAD software for design projects Experience with wastewater treatment facilities, HVAC, and piping systems...