Manager of Data Engineering

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

The Data Engineering Manager leads the Avantax Data Engineering Team for integration development activities needed in order to leverage data to meet Avantax's long term goals.

A servant leader to the team, the manager will inspire and enable their direct reports to perform at their best. As part of the Avantax leadership team this role requires communication skills that allow for clear, concise, and respectful promotion of goals, ideas, and direction. The manager will work at both the strategic level with organizational design and resource planning, and at the tactical level with hands-on guidance on articulating the vision.

The manager's mission is to ensure a delivery of high-quality data products to stakeholders supporting both operational (OLTP) and analytical (Data Warehouse) data needs. This will include team building and recruiting efforts, team member development, mentoring, and goal setting, as well as regular measuring and communicating of team achievements, project status and maintenance of standard development KPI's and metrics.

This position requires drawing upon substantial data engineering experience in both tactical and strategic efforts as well as administrative and people management experience. Proficiency with building and managing ETL/ELT data pipelines and their environments across a diverse on-prem and cloud hosted data ecosystem containing distributed file systems, a variety of SQL and NoSQL data stores, MPP Datawarehouse architecture, and leveraging a variety of data/API integration tooling and techniques.

Essential Duties & Responsibilities

• Lead and manage a team of data engineers, setting priorities and ensuring all team members are aligned with company goals and objectives.
• Collaborate with the product owner and data stakeholders to understand the business data requirements and implement optimal data solutions to ensure the team's output meets their needs.
• Warrant that the team's development efforts follow best practices for data quality, security, and governance.
• Ensure that our practices coalesce around concurrent goals of high performance, operational excellence, accuracy, reliability, predictability, resiliency, and scalability.
• Establish processes and practices that enable team members to meet goals associated with the creation data documentation and metadata, data lineage and dictionary and validate that the information stays current throughout.
• Mentor team to correctly establish a data-driven culture, promoting the adoption of monitoring tools.
• Develop realistic timelines, evaluate, and communicate risks and progress to the agile team and data leadership.
• Show a passion for teamwork, innovation, excellence, mutual respect, and collaboration.
• Stay current on industry best practices and emerging data focused technologies.
• Goal setting and monitoring
• Administrative tasks that pertain to team staffing and HR requirements

Education & Experience

• Managing high performance ELT/ ETL (Data Integration) development teams
• Building and managing agile dev practices by ensuring processes are created and followed across team members.
• Creating and implementing on-prem and cloud development best practices and standards
• Managing workload, project velocity, capacity across agile workstreams
• Collaboration across teams with project management, application development, data architecture as well as other technical and non-technical teams to ensure consistent and predictable and successful data delivery.
• Enabling and ensuring team members have the necessary skillsets, tooling/ technology, and processes in place to deliver top quality data driven features and solutions.
• Experience in data development for OLTP (application database development) as well as for OLAP (Star Schema - Data Warehouse)
• Experience creating and managing support and monitoring roles, SLAs, and processes to ensure 24x7 uptime.
• Experience creating and leveraging development metrics and KPI's to create transparency and aid in strategic and tactical planning.
• Experience leading data integration efforts and team members in migration of people, processes, and technology from on-prem to cloud hosted ecosystems.
• At least 10 years in progressive growth in Data Integration/ ETL Development roles
• At least 7 years in management role, leading delivery via people and process management
• At least 5 years in senior level technical data development roles leveraging various technologies to perform ETL/ ELT data integration (AWS Glue, Boomi, Python, and DBT preferred)
• At least 5 years development and management experience leveraging cloud databases and data integration/ data storage systems (AWS Aurora, S3, Dynamo DB, and Snowflake preferred)
• At least 2 years development experience leveraging SQL Server/ SSIS based database technologies.
• At least 2 years development experience leveraging distributed systems (HDFS/ EMR, Data Lake, Big Data Systems)

• Bachelor's degree in Computer Science, Information Systems, or a related field.
• Strong understanding of data governance, security, and privacy best practices.
• Excellent communication and interpersonal skills, with the ability to work effectively with both technical and non-technical stakeholders.
• Ability to think strategically and plan long-term initiatives that align with the company's goals and objectives.
• Strong problem-solving skills and a willingness to take ownership of complex technical issues.
• Working knowledge of CI/CD pipelines and automation techniques
• Experience ensuring data quality across multiple datasets used for analytical purposes.
• Knowledge of data transformation preferably using DBT
• Knowledge in concepts and/ or utilization of streaming data technology and data integration techniques
• Experience in agile development methodologies.

Physical Demands & 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 normal performance of the job.
• Compliance with company attendance standards.

Benefits

We offer a competitive salary, 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 [email protected], or by calling 972-870-6000 to speak with a member of the HR Talent Acquisition team.