Sr. ETL Developer

Location: Richmond, VA
Date Posted: 07-30-2018
Position: Sr. ETL Developer 
Location: Richmond, VA
Terms: Full Time Direct Hire
Compensation: Competitive

Seneca Resources is seeking an experienced Sr. ETL Developer for a direct hire position in Richmond, VA.  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.
Responsibilities:
  • Designs and develops ETL/ELT solutions using data warehouse design best practices specifically Azure Data Factory ETL/ELT solutions.
  • Analyze data requirements, complex source data, and the data model, and determine the best methods in extracting, transforming and loading the data into the data staging, warehouse and other system integration projects.
  • Provides senior technical leadership to design, architecture, integration and support of the entire data sourcing platform with a focus on high availability, performance, scalability and maintainability.
  • Updates job knowledge by participating in educational opportunities; reading professional publications; maintaining personal networks; participating in professional organizations.
  • Conducting training for development team and end users as needed
Desired Qualification: 
  • 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 Vault, 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.
  • 2+ years of ETL and data warehouse concepts with Data Vault 2.0 methodology.
  • 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).
About Seneca Resources:
Seneca Resources is client driven provider of strategic Information Technology consulting services and Workforce Solutions to government and industry.  Seneca Resources is a leading IT services provider with offices in Virginia, Alabama, & Dallas that service clients throughout the United States.  The key to our success lies within our strong corporate culture which drives our business.  We challenge our staff through engaging work, and we reward our staff through competitive compensation, extensive professional training, and excellent opportunities for career advancement.  In turn, we look for only the best and brightest to join our team.
We are an Equal Opportunity Employer and value the benefits of diversity in our workplace.
or
this job portal is powered by CATS