Data Engineer II

We love finance, software, and (believe it or not), taxes - that's why we love what we do! At Avantax, we celebrate our diverse experience and unique contributions and use our combined knowledge to blaze new trails in tax-focused investing. As individuals, we contribute valuable insight from our career history to achieve the Avantax mission. As a team, we work together to make a real impact and have a lot of fun along the way. Our collaborative work features decades of expertise in wealth management.

We bring our unique experiences together to form the heart of Avantax - working in unison toward the goal of creating services that make it easy for clients and professionals to pursue their financial and business goals. At Avantax, we are committed as a company and individuals to the diversity, equity and inclusion of our clients, team members and the communities in which we work.

Are you an innovative problem-solver who's eager to take on new challenges, collaborate with diverse team members and achieve excellence? If so, life at Avantax may be the opportunity for you.

Position Summary

Avantax is seeking a Data Engineer II who relishes working with large volumes of data, enjoys the challenge of highly complex technical contexts, and, above all else, is passionate about data and analytics. He/she is an expert with modern data architectures, data modeling, ETL design, and business intelligence tools and passionately partners with the business to identify strategic opportunities where improvements in data infrastructure create significant business impact. He/she needs to possess exceptional technical expertise in large-scale data warehouses and BI systems.

Essential Duties & Responsibilities

The major responsibilities of the position are listed below. To perform the job successfully, the individual must be able to execute each essential duty satisfactorily.

• Work with the product owner and data stakeholders to understand the business requirements and implement optimal data solutions.

• Design, Develop, implement, and operate stable, scalable, and highly performant ETL and data pipelines that cleanse, structure, and integrate disparate big data sets into a readable and accessible format for end-user analyses and reporting.

• Follow & execute strong and measurable processes, tools, and engineered data management solutions to support all data platforms - such as data warehouses, lakes, visualization tools, master data management, and advanced analytics tools.

• Responsible for designing, building & managing the advanced analytics platform to support data science and business intelligence teams with a mind toward accuracy, scalability, and high performance.

Education & Experience

• Bachelor's Degree in Computer Science or equivalent experience.

• 3+ years of hands-on experience with Data Warehousing design & implementation (preferably with a cloud-based warehouse, Redshift, or Snowflake).

• 3+ years of strong experience with SQL and the ability to write efficient code for high-volume data processing.

• 3+ years of hands-on experience supporting high-performing ETL processes, including data quality and testing processes.

• 2+ years of programming experience with an advanced language (C# and/or Python).

• 2+ years of hands-on experience with AWS Big Data technologies (Kinesis, EMR, AWS Glue, etc.).

• Experience with NoSQL technologies (DynamoDB preferred).

• Knowledge of CI/CD.

• Experience ensuring data quality across multiple datasets used for analytical purposes.

• Knowledge of data transformation preferably using DBT.

• Experience in agile development methodologies.

• Knowledge of statistical concepts and their application in reporting and data mart applications.

• Excellent communication (oral and written) and interpersonal skills.

• Enthusiastic attention to detail.

• Ability to acquire new skills quickly and thrive in a collaborative team environment.

Physical Demand & Work Effort

• Keying/typing, standing, walking.

• Sitting for an extended period.

• Constant mental and/or visual attention; the work is either repetitive or diversified requiring constant alertness in an office environment.

• The job is typically performed under comfortable working conditions; any disagreeable elements are generally absent during the normal performance of the job.

• Compliance with company attendance standards.

Comprehensive Benefits

We offer a competitive salary, and an outstanding benefits package that includes medical, dental, vision, life insurance, paid vacation and sick days, paid holidays, tuition reimbursement, and 401(k) with the company.

#Avantax

At Avantax, we believe our work benefits from the diverse perspectives of our employees. As such, Avantax welcomes and celebrates diversity and inclusion and is committed to equal opportunity employment. At Avantax, you can expect a supportive, open, and inclusive atmosphere and a team that values your contributions.

Avantax and its business lines, Avantax Wealth Management and Avantax Planning Partners are committed to providing an environment of mutual respect where equal employment opportunities are available to all applicants without regard to race, color, religion, sex, national origin, age, physical and mental disability, marital status, sexual orientation, gender identity, veteran status, and any other status protected under federal or state law.

Avantax considers information gathered in the hiring process, including information on this application, confidential, and only shares it on a need-to-know basis or as required by law.

If you need assistance or accommodation due to a disability, you may contact us at , or by calling 972-870-6000 to speak with a member of the HR Talent Acquisition team.