RichmondVARecruiter Since 2001
the smart solution for Richmond jobs

ETL Developer - $90-100k - Richmond, VA

Company: Vaco Technology
Location: Richmond
Posted on: January 12, 2021

Job Description:

Position 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.* Analyze business requirements and outline solutions.* Provide technical assistance in identifying, evaluating, and developing systems and procedures.* Document all ETL and data warehouse processes and flows.* Create or update technical documentation for transition to support teams.* Develop automated data audit and validation processes.* Develop and deploy ETL job workflow with reliable error/exception handling and rollback.* Manage foundational data administration tasks such as scheduling jobs, troubleshooting job errors, identifying issues with job windows, assisting with Database backups and performance tuning.* Design, Develop, Test, Adapt ETL code & jobs to accommodate changes in source data and new business requirements.* 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* Manage automation of file processing as well as all ETL processes within a job workflow.* Develop, Contribute and adhere to the development of standards and sound procedural practices.* Proactively communicate innovative ideas, solutions, and capabilities over and above the specific task request* Effectively communicate status, workloads, offers to assist other areas.* Collaboratively work with a team and independently. Continuously strive for high performing business solutions* Perform and coordinate unit and system integration testing.* Participate in design review sessions and ensure all solutions are aligned to pre-defined architectural specifications.* Ensure data quality throughout entire ETL process, including audits and feedback loops to sources of truth.Organizational Relationship:This position reports to the IT Data Team Lead.Position Qualifications (Required)Education & Experience:* A Bachelor's Degree in a technology area of study; preferably in Computer Science, MIS or Analytics.* 10+ years equivalent work experience in Information Technology.* 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.Job Requirements:ETL Developer, ETL, Azure, SQL, Power BI, SSIS Job Requirements8+ years of previous experience supporting data warehouse implementations 5+ years ETL development experience preferably using Microsoft SQL Server Data Tools/BIDS

Keywords: Vaco Technology, Richmond , ETL Developer - $90-100k - Richmond, VA, IT / Software / Systems , Richmond, Virginia

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Other IT / Software / Systems Jobs


Senior Software Engineer (JavaScript)
Description: A healthcare product shop--in DC is searching for a Senior Software Engineer--to join their fast growing organization. They are
Company: Motion Recruitment
Location: Washington
Posted on: 01/21/2021

Developer
Description: If you are a Appian Developer with 5 yrs experience, please read on Based in College Park, MD hiring for our Colombia location , we've been providing management consulting services within both the Government (more...)
Company: CyberCoders
Location: College Park
Posted on: 01/21/2021

Senior Software Engineer
Description: Location: 100 REMOTE Salary: Up to 160k base plus benefits Needs: Python, Cloud, Elastic, Containers Docker/Kube NOTE: Citizenship required and must be eligible to obtain a DoD clearance, however you (more...)
Company: Optello
Location: Washington
Posted on: 01/21/2021


Senior Java Software Engineer
Description: Company DescriptionAt Fannie Mae, futures are made. The inspiring work we do makes an affordable home a reality and a difference in the lives of Americans. Every day offers compelling opportunities to (more...)
Company: Fannie Mae
Location: Washington
Posted on: 01/21/2021

Information Technology Specialist
Description: Job Description As our IT Information Technology Specialist, you will be the leader of our IT infrastructure and development platforms. You will manage Office365, office networking, VPN, laptop provisioning, (more...)
Company: Strider Technologies
Location: Washington
Posted on: 01/21/2021

Provisioning and Billing System Administrator/VSIT (Government)
Description: AT T Global Public Sector is a trusted provider of secure, IP enabled, cloud-based, network/telephony solutions and professional services to the Federal Government. We are dedicated to recruiting, developing (more...)
Company: AT&T
Location: Springfield
Posted on: 01/21/2021

Senior JavaScript Engineer
Description: A globally boutique fitness software company, located in Washington DC, is seeking a Senior JavaScript Engineer to join their team of professionals. This team is looking for an engineer who is excited (more...)
Company: Motion Recruitment
Location: Washington
Posted on: 01/21/2021

Peraton: Systems Administrator- (Active Directory/Account Management)
Description: Job DescriptionThis
Company: Peraton
Location: Springfield
Posted on: 01/21/2021

Web Application Architect
Description: Redefine How Washington Works When government is at its best, diverse ideas are at work. The same is true of Bloomberg Industry Group and our BGov team. Our ability to innovate and serve our clients (more...)
Company: Bloomberg Industry Group
Location: Washington
Posted on: 01/21/2021

Sales Executive Mobility
Description: As a Sales Executive 1 --- Mobility, you---ll work with AT T's cutting-edge business products and services focusing on our mobility solutions. You---ll focus on generating new sales revenue within a module (more...)
Company: AT&T
Location: Oakton
Posted on: 01/21/2021

Log In or Create An Account

Get the latest Virginia jobs by following @recnetVA on Twitter!

Richmond RSS job feeds