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!
Other IT / Software / Systems JobsSenior 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 |