Data Warehouse Architect & BI Developer for ADG TECH, USA

We are a Software Development Company located in Northern Virginia, USA.

We sponsor H1B Visa.
We currently seek a Senior Data Warehouse Architect with Business Intelligence development experience. 

Qualifying Candidates Should Possess:

• Demonstrated expertise with database technologies including evidence of proficiency in relational database programming using SQL Server and Database Design.
• Must have experience in Leading Projects and contribute expertise in the areas of architecture, application performance / scalability, design patterns / methods and hands-on development of solutions.
• The ideal candidate must also have a deep understanding of how businesses leverage data in core functional areas, specifically in the areas of Sales, Manufacturing, and Finance

Job Duties:

•  Experience in designing and building data warehouse solutions to support BI & Reporting projects using Microsoft SQL Server
• Lead in the implementation of architecture design, ETL, data modeling, and data validation
• Provide hands-on development of solutions.
• Provide frequent phone and email communication with customers and internal resources.
• Define technical requirements, technical and data architectures for the data warehouse.
• Recommend supplemental data warehouse technologies if needed.
• Direct the analysis and discovery processes.
• Translate user requirements into technical architecture vision and implementation plan.
• Define policies, procedures, and governance for the data warehouse that is aligned with the overall BI strategy.
• Solve critical business needs by modeling the business intelligence database environments. Logically and physically model source system and business intelligence databases and ensure the overall health and performance of the business intelligence database environment, conducting facilitated sessions, and working with developers to create database views as necessary.
• Serve as Subject Matter Expert in data modeling concepts is highly preferred.
• Coordinate new data development, ensuring consistency and integration with existing data warehouse structure. Develop processes for capturing and maintaining metadata from all data warehousing components. Implement dimensional models, including aggregation and indexing strategies. Recommend strategy for database security.
• Conduct ETL process design and sizing estimates for large scale data warehousing projects. Develop, test, and implement extraction, transformation, and load (ETL) processes. Responsible for prototyping solutions, preparing test scripts, and conducting tests and for data replication, extraction, transformation, loading, cleansing, and data modeling for data warehouses.


Recruiter Name:Omer Syed
Email Address:osyed@adgtech.net