This site uses cookies. To find out more, see our Cookies Policy

ETL Architect in Philadelphia, PA at Vaco

Date Posted: 4/30/2018

Job Snapshot

Job Description

Job Description: ETL Architect

Sponsorship is not available.


  • Own and make strong contributions in architecting, designing and planning BI / AI solutions, configuring services, aggregating data from multiple sources into a data repository
  • Establish best practices for BI, AI, & analytics solutions to ensure they are being effectively applied to all efforts
  • Guide technology teams in creating and deploying solutions that cater to various business needs.
  • Perform architectural reviews of BI / AI & analytics solutions
  • Apply architectural and engineering concepts to design solutions that meet operational requirements such as scalability, security, reliability, flexibility, availability and manageability
  • Define and implement business transformation rules and logic
  • Identify, establish, communicate, and manage data quality and integrity standards
  • Participate in and direct data architecture design activities within development teams
  • Ability to take strategic direction from Executive management and other technical leaders


  • Experience with database analysis, database modeling, design, and implementation especially for data lakes / marts / warehouses
  • Experience with the design of scalable ETL / ELT solutions with multiple data sources
  • Hands-on development experience with ETL / ELT tools and resources
  • Data transformation support and management through MS SQL SSIS / DTS, Informatica, or similar technology
  • Experience in SQL development focused on MS SQL 2008 / 2014
  • Strong knowledge in MS SQL and PL/SQL-based development
  • Experience in working across multiple production and development environments
  • Solid verbal, written, and presentation communications skills