Data Engineer - ETL/BI Developer (R7746)

Designs, builds and oversees the deployment and operation of technology architecture, solutions and software to capture, manage, store and utilize structured and unstructured data from internal and external sources. Establishes and builds processes and structures based on business and technical requirements to channel data from multiple inputs, route appropriately and store using any combination of distributed (cloud) structures, local databases, and other applicable storage forms as required. Develops technical tools and programming that leverage artificial intelligence, machine learning and big-data techniques to cleanse, organize and transform data and to maintain, defend and update data structures and integrity on an automated basis. Creates and establishes design standards and assurance processes for software, systems and applications development to ensure compatibility and operability of data connections, flows and storage requirements. Reviews internal and external business and product requirements for data operations and activity and suggests changes and upgrades to systems and storage to accommodate ongoing needs.

Essential Duties and Responsibilities:

• Translate business requirements into specifications that will be used to drive data store/data warehouse/data mart design & configuration.
• Use ETL tools to load data stores/data warehouse
• Provide support as required to ensure the viability & performance of enterprise data and BI environments to both internal & external users.
• Ensure proper configuration management and change controls are implemented.
• Must be able to perform duties with moderate to low supervision.
• Design & Implement technology best practices, guidelines and repeatable processes
• Maintain JIRA, Wiki and project documentation as needed.

Technical Skills:

• 5 years of relevant experience in data management, ETL, data warehousing and BI Reporting.
• Minimum of 2 years' experience with data pipelines (ETL / ELT)
• Demonstrated understanding of the Data Lifecycle
• Knowledge of data modeling, data ingestion and ETL design.
• Advanced SQL proficiency
• Experience in Talend Data Integration tool.
• Experience with Data Visualization tools (Tableau and Power BI a plus)
• Exposure to Source Control, CI / CD, and DevOps
• Knowledge of AWS technologies (EC2, S3, RDS, Redshift...etc.)
• Working knowledge of Agile frameworks and Jira
• Knowledge of integration with systems like Salesforce, Relational Databases, REST API, FTP/SFTP...etc.
• Knowledge SSRS is a plus.
• Ability to learn and use new technologies quickly & effectively.
• Proven ability to communicate effectively with technical and non-technical stakeholders across multiple business units
• Excellent analytical and problem-solving skills

Preferred Qualifications:

• Advanced SQL proficiency
• Functional experience with Talend or DBT
• Advanced experience with Data Visualization tools (Tableau and Power BI)
• Experience with AWS and Snowflake

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.