• Senior Data warehouse / ETL Developer Jobs in United States Of America - 25311125

  • Avalara
  • United States Of America, Usa
  • Save Job
  • 9 - 12 Years
  • Posted : above 1 month

Job Description:

Senior Data warehouse/ETL Developer Engineering | Seattle, WA, United States

We are looking for a Sr Data warehouse/ETL Developer with strong technical proficiency in SQL development to build an ETL pipeline for enterprise data warehouse The Data Services team is fundamentally tasked with the operation of our data warehouse infrastructure components with a focus on collection, storage, processing, and analyzing of large sets of data The primary focus will be to evaluate and optimize packaged solutions (Talend, MS SQL Server, SSIS, other ETL frameworks) for these purposes, then implementing, maintaining and monitoring them You will also be responsible for integrating them with the architecture used across the company

The successful candidate will be a well-rounded data warehouse developer with vast experience in ETL tools, SQL development and query performance tuning Experience in database design, data modeling, data warehousing and effectively communicating with others is a must Program management skills are great to have Domain knowledge of sales and marketing, CRM, SaaS, and the billing/financial ERP space would be a huge advantage

Job Duties

Design, implement, test, and roll-out of facts, dimensions and data marts including development of proof-of-concepts
Selecting and integrating ETL tools and data warehouse solutions required to satisfy business needs
Experience in enterprise data warehouse ETL design and development as well as migration of ETL stack from one tool to another
Consolidate and help standardize data integration efforts across multiple data sources and destinations
Implementing ETL processes which drive Avalaras data pipeline
Write extensive T-SQL code to build facts and dimensions, and maintain them
Monitor daily ETL processes; Will be part of team on-call weekend rotation schedule
Develop ETL specifications, source to target mappings and other documentation required for ETL development
Develop, enforce and maintain appropriate change control procedures
Generate high-quality design, requirements and technical documentation
Provide technical escalation and be on call via pager during designated periods
Agile work environment experience including working from a ticket system like Jira or similar, and collaborating through a distributed version control system like Github or similar
Lead and manage backlog with a globally distributed team
Work independently and as a team player to deliver world class data services on behalf of the company


9 years of experience in T-SQL extensive coding, preferably in an OLAP/BI environment
9 years of experience designing and developing Extraction, Transform and Load (ETL) processes
The ideal candidate must possess deep expertise in data warehousing, dimensional modeling, and the ability to bring best practices with regard to master data management, ETL, and data governance
Strong knowledge of ETL techniques and frameworks
Experience with integration of data from multiple data sources
Strong experience with ETL tooling such as SSIS, Talend, Wherescape or similar
Extensive experience using SQL including complex stored procedures, common table expressions, analytic functions, query optimization, and indexing
Strong proficiency in SQL Server, both development, performance tuning & optimization
Proficiency in data modeling and profiling
Proven experience with and strong interest in scripted ETL, including API integrations, preferably in Python, or experience with other languages (PowerShell, NET, Java, Javascript, or Perl)
Awareness of the landscape of database-agnostic ETL tools and frameworks like Streamsets, Sqoop, Flume, Trifacta or Datameer
A strong work ethic and ability to self-start
Strong organizational and multi-tasking skills
Excellent verbal and written communication skills, ability to communicate and interact effectively at both technical and business level
Strong problem-solving and analytical skills
Experience in SQL server 2012 and later versions

Preferred Qualifications

Big Data (Hadoop, Spark, Hive, Pig, Presto)
DBA responsibilities
Jira and Confluence
Masters degree in computer science, engineering, or information management
MPP data warehouses solution and cloud-based services

About Avalara

Avalara helps businesses of all sizes achieve compliance with transaction taxes, including sales and use, VAT, excise, communications, and other tax types The company delivers comprehensive, automated, cloud-based solutions designed to be fast, accurate, and easy to use The Avalara Compliance Cloud platform helps customers manage complicated and burdensome tax compliance obligations imposed by state, local, and other taxing authorities throughout the world

Avalara offers more than 600 pre-built connectors into leading accounting, ERP, ecommerce and other business applications, making the integration of tax and compliance solutions easy for customers Each year, the company processes billions of indirect tax transactions for customers and users, files more than a million tax returns, and manages millions of tax exemption certificates and other compliance documents

Headquartered in Seattle, Avalara has offices across the US and overseas in the UK, Belgium, Brazil, and India More information at wwwavalaracom

Avalara is an Equal Opportunity Employer All qualified candidates will receive consideration for employment without regard to race, color, creed, religion, age, gender, national orientation, disability, sexual orientation, US Veteran status, or any other factor protected by law

Avalara is an Equal Opportunity Employer All qualified candidates will receive consideration for employment without regard to race, color, creed, religion, age, gender, national orientation, disability, sexual orientation, US Veteran status, or any other factor protected by law


Profile Summary:

Employment Type : Full Time
Eligibility : Any Graduate
Industry : IT-Hardware/Networking, Telecom
Functional Area : IT Software : Software Products & Services
Role : Software Engineer
Salary : As per Industry Standards
Deadline : 03rd Jun 2020

Key Skills:

Why not try out our free online tutorials and gain an edge?

People who search this job also searched for the following Keywords

Salary trends based on over 1 crore profiles

View Salaries

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status