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

Beyer Subaru Alexandria

Express Technician Job at Beyer Subaru Alexandria

About UsDon Beyer Sr., a retired U.S. Army Lt. Colonel, founded Don Beyer Auto Group in 1973. His philosophy of doing business was to take excellent care of each and every service and parts customer and new and used car sales would flow from it.The Beyer Automotive...

IQVIA

Patient Support Medical/Biller Claims Processing Representative (Home-Based) Job at IQVIA

**Patient Support Medical Claims Processing Representative**_Contract Remote Role - Location...  ...are looking for a 100% remote (work from home-WFH) contact **Patient Support Medical...  ...in claim processing required+ Medical Billing Certification required+ Coding Certification... 

Stratejic Relationships

Data Entry Clerk Job at Stratejic Relationships

Stratejic Relationships is looking for a detail-oriented Remote Data Entry Clerk to join our team. This position offers the flexibility of working remotely while ensuring the accuracy and efficiency of data management processes critical to our success. Key Responsibilities...

Molina Healthcare

Care Manager RN (Community Well) Job at Molina Healthcare

 ...Population) that is part of the Community Well Services team. This position will have a case...  ...program. We are looking for Registered Nurses who have experience working with manage care...  ...and education as appropriate to non-RN case managers+ Works cases with members who... 

In House Jobs | JDHuntr

In House Counsel Jobs New York | JDHuntr 60084 Corporate Counsel, Investments $200K - $250K, New York, NY Job at In House Jobs | JDHuntr

In House Counsel Jobs New York | JDHuntr 60084 Corporate Counsel, Investments $200K - $250K, New York, NY Apply on JDHuntr.com Post Date: 8.24.2023 *Work closely with the investments team to structure and close transactions and negotiate, draft and manage related loan...