Senior Data warehouse/ETL Developer

| Seattle

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 Avalara’s 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

Qualifications 

  • 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)
  • AWS
  • Snowflake
  • DBA responsibilities
  • Jira and Confluence
  • GitHub
  • Master’s 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 U.S. and overseas in the U.K., Belgium, Brazil, and India. More information at www.avalara.com

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.

Read Full Job Description

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • .NETLanguages
    • C#Languages
    • JavaLanguages
    • JavascriptLanguages
    • PHPLanguages
    • PythonLanguages
    • RubyLanguages
    • SqlLanguages
    • jQueryLibraries
    • jQuery UILibraries
    • ReactLibraries
    • ReduxLibraries
    • Twitter BootstrapLibraries
    • Node.jsFrameworks
    • Microsoft SQL ServerDatabases
    • MongoDBDatabases
    • MySQLDatabases
    • Adobe Target, Adobe AnalyticsAnalytics
    • AxureDesign
    • IllustratorDesign
    • PhotoshopDesign
    • ConfluenceManagement
    • JIRAManagement
    • Adobe Experience ManagerCMS
    • SalesforceCRM
    • SendGridEmail
    • Adobe CampaignLead Gen
    • Oracle EloquaLead Gen

Location

255 S King St, Seattle, WA 98104

What are Avalara Perks + Benefits

Culture
Friends outside of work
Eat lunch together
Open office floor plan
Diversity
Dedicated Diversity/Inclusion Staff
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Pet Insurance
Wellness Programs
Onsite Gym
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Child Care & Parental Leave Benefits
Generous Parental Leave
Flexible Work Schedule
Family Medical Leave
Perks & Discounts
Beer on Tap
Casual Dress
Commuter Benefits
Company Outings
Stocked Kitchen
Happy Hours
More Jobs at Avalara79 open jobs
All Jobs
Finance
Data + Analytics
Dev + Engineer
HR
Internships
Legal
Marketing
Operations
Product
Project Mgmt
Sales
Content
Finance
new
Seattle
Sales
new
Seattle
Developer
new
Seattle
Developer
new
Seattle
Developer
new
Seattle
Developer
new
Seattle
Operations
new
Seattle
Developer
new
Seattle
Developer
new
Seattle
Developer
new
Seattle
Developer
new
Seattle
Developer
new
Seattle
Developer
new
Seattle
Marketing
new
Seattle
Data + Analytics
new
Seattle
Sales
new
Seattle
Developer
new
Seattle
Developer
new
Seattle
Sales
new
Seattle
Marketing
new
Seattle
Developer
new
Seattle
Operations
new
Seattle
Project Mgmt
new
Seattle
Operations
new
Seattle
Sales
new
Seattle
Developer
new
Seattle
Developer
new
Seattle
Developer
new
Seattle
Data + Analytics
new
Seattle
Sales
new
Seattle
Marketing
new
Seattle
Developer
new
Seattle
Operations
new
Seattle
Operations
new
Seattle
Sales
new
Seattle
Project Mgmt
new
Seattle
Product
new
Seattle
HR
new
Seattle
Sales
new
Seattle
Data + Analytics
new
Seattle
Content
new
Seattle
Data + Analytics
new
Seattle
Project Mgmt
new
Seattle
Developer
new
Seattle
Developer
new
Seattle
Developer
new
Seattle
Developer
new
Seattle
Developer
new
Seattle
Developer
new
Seattle
Developer
new
Seattle
Developer
new
Seattle
Developer
new
Seattle
Product
new
Seattle
Sales
new
Seattle
Finance
new
Seattle
Finance
new
Seattle
Project Mgmt
new
Seattle
Finance
new
Seattle
Developer
new
Seattle
Developer
new
Seattle
Internships
new
Seattle