Data Warehouse Architect - 4 Year Contract - Dmv/Va/Al - Active Top Secret Clearance Required

Zachary Piper Solutions is currently seeking a Top-Secret cleared Data Warehouse Architect to support the FAA. The Top-Secret cleared Data Warehouse Architect will be supporting the data warehouse team, full-time based Washington D.C, Chantilly VA, Quantico VA, or Huntsville AL. Top-Secret clearance or higher is required. On-site 5 days a week.

Responsibilities for the Data Warehouse Architect Include:

• Lead the creation and implementation of improved and/or new data solutions across the company

• Make sure data development initiatives satisfying end user needs as well as company need and objective

• Analyze the data, spot any issues, and provide the right advice

• Analyzing client operations, application, and programming; talking with the customers about goals; and assessing present systems will help you identify database architecture needs

Qualifications for the Data Warehouse Architect Include:

• 4+ years of experience working with data warehouse architecture tools

• Strong understanding of relational databases, ETL processes, data modeling, data design, and data migration

• Experience working with Azure and/or AWS (AWS is preferred, will consider someone with AWS knowledge and minimal hands on experience

• Experience with migrating on-prem to AWS cloud

• Active Top-Secret clearance

Compensation for the Data Warehouse Architect includes:

• Salary Range: $140,000-$165,000/year depending on experience

• Full Benefits: Cigna Medical, Dental, and Vision, 401K w/ 6% match, Tuition reimbursement, and PTO

Keywords: data lake, delta lake, data mart, data warehouse, data Lakehouse, data mesh, data governance, data landscape, data analytics, data analytic, business analyst, internetofthings, internet of things, iot, rationalization, application rationalization, clinger-cohen, clingercohen, clinger-cohen act, cloud migration, Data analyst, powerbi, tableau, business objects, visualization, data analysis, power bi, data admin, data administrator, data administration, data task, data task lead, portfolio management, data integration, data management, data tools, data gathering, interface, system information, gap analysis, business case analysis, implementation plans, technology plans, analytics, dashboards, datamanagement, application rationalization, action officer, staffing, qlik, BOBJ, query, query development, data troubleshooting, interface, interface troubleshooting, ad-hoc, report creation, greenbelt, green belt, blackbelt, black belt, pmp, pmp certified, pmp certification, msoffice, microsoft, microsoft office, microsoftoffice, excel, powerpoint, ms project, ms access, usairforce, air force logistics, data scientist, data, data statistician, data architect, data engineer, Cleared, clearable, dod cleared, dod secret, dod clearance, secret clearance, ts, tssci, ts/sci, top secret clearance, top secret, secretclearance, secret, secret dod, dos secret, secret dos, top secret sci, top secret with sci, federally cleared, ts sci, active ts, active secret, active clearance, clearance active, sci eligible, sci eligibility, active top secret, dod clearance, active dod, active security, security clearance, veterans, reserve, reserves, reserve member, civilian, marine corp, marines, marine corps, active duty, retired military, military, army, navy, air force, us army, us navy, us air force, usmc, untied states service member, department of defense, dod, department of state, federal agency, federal contract, public sector, long term contracts, Permanent position, direct placement, direct hire, direct work, dp, Remote, remote work, remotework, hybrid, off-site, wfh, work from home, hybrid schedule, hybrid work, Air force, us air force, USAF, united states air force, washington dc, district, the district, d.c., washington d.c., virginia, dmv, maryland, dc maryland virginia, andrews afb, andrews air force base, andrews base, u.s. air force, air force logistics, business analyst, business task lead, air force installations, air force headquarters, usmc, united states marine corps, united states navy, veterans, officer, military, joint base, joing base andrews, pg county, prince george's county, maryland, camp springs air base, air force, andrews afb, afb, aafb, business analytics, military officer, HQ, headquarters, ms power bi, ms office power user, six sigma, sixsigma, 6sigma, office of management, budget exhibit, general officer, budget analyst, business analyst, budget compliance, budgeting compliance, acquisition, PPBE, dod, department of defense, dod agency, dod cleared, bachelors, bachelor's, degree, resource integration, migrating, migration, data migration, data systems, data ingestion, data acquisition, migration of data, facilitating, data facilitation, migration facilitation, cloud migration

#LI-AA1 #LI-HYBRID