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.
...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...
...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...
...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...
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...
...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...