Logo
Navtech

URGENT NEED - Data Warehouse Architect" _ Washington, DC - HYBRID

Navtech, Washington, District of Columbia, us, 20022


I have an opportunity for

"Data Warehouse Architect" _ Washington, DC - HYBRID

"

and I am looking for a candidate who can join Immediately if you are interested, reply to me with your updated resume or if you could refer someone I would really appreciate it.

Position : Data Warehouse Architect

Location : Washington DC - HYBRID

Duration : 6 to 12 months

Job Duties:Oversee and review work of team members, as needed or instructed.• Partner with scrum masters/ project managers on optimizing scheduling, work allocations, and storyassignments.• Manage reporting environment including data sources, connections, security, subscriptions andmetadata.• Lead in initiative towards data access control and integrity across the enterprise.• Create data models and schema for reliable and highly performant data marts and data warehouses.• Develops complex ETL (extract, transform and load) SQL scripts to gather data from various databasesand systems to make data available for enterprise analytics and reporting.• Evaluate, test and implement new or upgraded software.• Troubleshoot reported problems pertaining to reports and the reporting database environment,working closely with other IT members, especially DBAs, Systems Analysts and Systems Engineers,identifying the cause and designing or developing an approach for resolution.• Assess impact of changes and updates to source production systems, planning and implementingresulting changes to reports.• Identify areas for improvement within the EDS organization related to architecture, design,performance optimization, development process, workflows, governance, tools/technologies

Education:Bachelor Degree and/or relevant technical training and certifications.• Five (5) to Seven (7) years of directly related experience.• Three (3) to Four (4) years of operational and/or technical business leadership experience.• Five (5) years of experience with OLAP, industry standard databases, structured query language, ETL,reporting.• Three (3) years of experience with data warehouse and data mart design, including Star and Snowflakemodels.

Required Skills:The candidate should have overall 12+ yrs experience.1) Must have 6+ years working as a developer using Pentaho (PDI, Kettle), HP-Vertica and Tableau.2) 4+ years with data modeling, creating logical, physical and conceptual data models.3) 4+ years' experience with Data architecture -designing data marts, creating source - target mappingdocuments etc.

Regards

Alex . K

NAVTECH INC

1600 Golf Road. Suite 1200, Rolling Meadows, IL 60008

Ph:

(224) 348-1340 ||

Email:

alex@navtechusa.com || www.navtechusa.com

E-Verified Company