Sr./Lead ETL Developer in Manakin, VA at Vaco

Date Posted: 3/10/2020

Job Snapshot

Job Description



Seeking an experienced ETL Developer responsible for delivering solutions that supports the organization's data analytics initiative.


  • Work with innovative technologies to manage and support key projects that provide critical data processing services to internal and customer-facing business applications and services. These database systems are primarily based on SQL Server and Microsoft technologies, specifically Azure, and may extend to other Cloud or Open-Source solutions in the future.
  • The primary responsibility of this role will be to design the data acquisition, data staging, loading, and transformation of data through ETL processes.
  • The role is also expected to have a broad DW background to allow contributions in Database Administration and BI Development when needed.
  • Ideal candidates will have a demonstrated track record of analyzing business needs and delivering high quality solutions in a fast-paced environment with the ability to support and improve current implementations, with minimal supervision. Candidate would also provide technical leadership proactively identifying and pursuing technical and process opportunities for improvements.
  • Clear communication to senior leadership, along with detailed planning and execution is critical to success for this role.

Position Qualifications (Required):
Education & Experience:

  • A Bachelor's Degree in a technology area of study; preferably in Computer Science, MIS or Analytics.
  • 8+ years of previous experience supporting data warehouse implementations
  • 5+ years ETL development experience preferably using Microsoft SQL Server Data Tools/BIDS, with deep and thorough hands-on use of T-SQL.
  • 5+ years of experience in relational and data warehouse database design, optimization and performance; preferably with MS SQL Server.
  • Expertise/working knowledge in Data Warehouse Practices and Azure Data Factory
  • 3+ years of experience with API (Application Program Interface) development.
  • 7+ years in a structured IT organization with a variety of methodologies, and strong technical environment management.
  • Experience with multiple SDLC methodologies - Waterfall and Agile.
  • Extensive experience with data dictionaries, data analysis and relational databases.
  • Proven understanding of SQL optimization (indexing and ability to interpret and act on execution plans).

Knowledge & Skills:

  • Creative problem solver with excellent communication, leadership and collaboration skills.
  • Advanced decision making and problem-solving skills
  • Business acumen, knowledge and professionalism
  • Proactive leadership style and a self-starter and strong attention to detail
  • A clear and familiar understanding of the concepts and best practices of data warehouse ETL design
  • Demonstrated expertise around the Microsoft SQL Server technologies (primarily SSIS).
  • Foundational Database administration skills; Broad DW skills including Semantic Layer, Basic BI Development and basic data modeling & data analysis
  • Methodical and structured approach to design and development.
  • Delivery focused with the ability to prioritize activities.
  • Flexible team player within a small, multi-disciplinary team.

Other Skills (Preferred):

  • Experience with Power BI and other BI tools
  • Microsoft Azure Certification in Data or Cloud Solutions
  • Experience with data extraction from Microsoft CRM/ERP (AX and D365) Cloud solutions
  • Streaming data analytics
  • Data Science knowledge
  • PowerShell experience

Job Requirements

ETL, SQL, Data Warehouse, Azure, Power BI