Senior Database Engineer

Washington, DC
Jul 02, 2022
Jul 08, 2022
Full Time
The Senior Database Engineer within the BI and Analytics team will be a major contributor and architect of Avalara's cloud based centralized reporting platform. Hence strong experience in large scale reporting platforms, MPP cloud data technologies, advanced ETL/ELT and data streaming tools and deep understanding of long term benefits and pitfalls of various data structures (NOSQL vs SQL) is an absolute must.A major responsibility for this role is to scale and support our customer facing reporting logic which includes providing end to end data delivery of custom and standard compliance tax logic to thousands of our customers via HTTPS and other secure protocols.Responsibilities :Build a long term 'data analytics stack' for AvalaraWork with the product managers, DBA teams and broader engineering teams build scalable data orchestration, transformation and reporting streams that can capture and prepare billions of transactions per day for customer reportingBuild, implement and monitor a data quality framework with required ci/cd pipeline, code instrumentation and real time monitoring toolsPractice/Implement data security, encryption and masking policies across various data sets and data sourcesDevelop and manage end-to-end project plans and ensure on-time deliveryCommunicate status and big picture to the project team and managementWork with business and engineering teams to identify scope, constraints, dependencies, and risksIdentify risks and opportunities across the business and drive solutionsQualifications:Minimum of 8 years work experience combined in data engineer, object oriented languages (python, C#, or JAVA), DevOps, distributed cloud architecture, high availability production system deployment experienceAdvanced SQL with big data optimization skillsSnowflake experienceETL tools (Airflow, Informatica, etc.)Access controlBachelor's degree in Computer Science or Engineering, or equivalent work experienceExperience managing efforts in distributed systems and/or developing large scale web/ cloud SaaS applicationsProven ability to combine business acumen, technical acumen and process expertise to define client (internal/external) engagement and program executionAbility to communicate effectively with technical and non-technical stakeholders across multiple business unitsPreferred skills:Experience with Google Cloud Platform strongly desiredPythonPrior experience as a Database Administrator (DBA)About Avalara:Avalara helps businesses of all sizes achieve compliance with transactional taxes, including VAT, sales and use, excise, communications, and other tax types. We deliver comprehensive, automated, cloud-based solutions that are fast, accurate, and easy to use.Avalara offers hundreds of pre-built connectors into leading accounting, ERP, ecommerce and other business applications. Each year, the company processes billions of tax transactions for customers and users, files hundreds of thousands of tax compliance documents and tax returns and manages millions of exemption certificates and other compliance related documents.Avalara's headquarters are in Seattle, WA and it has offices across the US and in Brighton and London, England; Brussels, Belgium; and Pune, India. More information at: 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.