SQL DW/ETL Engineer

| Seattle

We are looking for a senior data warehouse/ETL engineer with the technical proficiency to lead our SQL/DW and ETL developers and build an 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 engineer 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

  • Assume leadership role in design, implementation, testing, and roll-out of enterprise data warehouse and data marts including development of proof-of-concepts
  • Selecting and integrating ETL tools and data warehouse solutions required to satisfy business needs
  • Lead the Enterprise Data Warehouse ETL design, development, deployment, and monitoring
  • Create, upgrade, consolidate and help standardize data integration efforts across multiple data sources and destinations
  • Implementing ETL processes which drive Avalara’s data pipeline
  • Act as a key Data Warehouse expert within the data services team to drive successful adoption of best practice, standardization of data provision to the data warehouse, and proactive management of data refresh and accuracy
  • Develop ETL specifications, source to target mappings and other documentation required for ETL development
  • Monitoring daily ETL and data warehouse processes
  • Grow and maintain expert-level knowledge in database design, architecture, warehousing, and implementation of best practices
  • Develop, enforce and maintain appropriate change control procedures 
  • Generate high-quality design, requirements and technical documentation 
  • Candidate will be leading a group of developers located globally and hence will require to work during off business hours as required
  • Provide technical escalation and be on call via pager during designated periods
  • Ensure appropriate documentation is generated, maintained, and stored centrally.
  • Provide analysis and estimates of effort for integration with would-be data partners
  • Drive prioritization and manage expectations with business stakeholders
  • 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 (absolute must haves walking in the door)

  • 9+ years of experience in database design, data warehousing
  • 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
  • Strong knowledge/experience in solution architecture within the data integration space
  • Experience with integration of data from multiple data sources
  • Strong experience with ETL tooling such as SSIS, DataStage, Informatica 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 Talend, Streamsets, Sqoop, Flume, Trifacta or Datameer
  • A strong work ethic and ability to self-start
  • A strong team player mentality with proven ability to work effectively cross-functionally
  • 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

 

Preferred Qualifications (great to have but not absolutely necessary)

  • Big Data (Hadoop, Spark, Hive, Pig, Presto)
  • AWS
  • DBA responsibilities
  • Jira and Confluence
  • GitHub
  • Master’s degree in computer science, math, science, engineering, information management or business administration
  • 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 Avalara70 open jobs
All Jobs
Finance
Data + Analytics
Design + UX
Dev + Engineer
HR
Internships
Marketing
Operations
Product
Project Mgmt
Sales
Marketing
new
Seattle
Developer
new
Seattle
Developer
new
Seattle
Design + UX
new
Seattle
Project Mgmt
new
Seattle
Developer
new
Seattle
Operations
new
Seattle
Operations
new
Seattle
Sales
new
Seattle
Marketing
new
Seattle
Finance
new
Seattle
Developer
new
Seattle
Data + Analytics
new
Seattle
Finance
new
Seattle
Developer
new
Seattle
Data + Analytics
new
Seattle
Developer
new
Seattle
Developer
new
Seattle
Developer
new
Seattle
Developer
new
Seattle
Project Mgmt
new
Seattle
Developer
new
Seattle
Internships
new
Seattle
Developer
new
Seattle
Developer
new
Seattle
Developer
new
Seattle
Developer
new
Seattle
Project Mgmt
new
Seattle
Developer
new
Seattle
Project Mgmt
new
Seattle
Finance
new
Seattle
HR
new
Seattle
Developer
new
Seattle
Sales
new
Seattle
Design + UX
new
Seattle
Developer
new
Seattle
Operations
new
Seattle
Operations
new
Seattle
Project Mgmt
new
Seattle
Developer
new
Seattle
Developer
new
Seattle
Project Mgmt
new
Seattle
Finance
new
Seattle
Finance
new
Seattle