Senior Data Engineer

As a Senior Data Engineer, you’ll play a leading role in developing, researching and implementing strategies that will meet Assent’s strategic and operational business needs. You’ll lead the ongoing design, development, deployment and maintenance of secure, robust, scalable, repeatable and high-performing data platforms and products while proactively communicating with stakeholders regarding business requirements, status and priorities.

You’ll be responsible for driving efficiency and productivity in your data Products team, through system integrations, identifying data driven trends, standardizing key metrics and supporting the creation of real-time dashboards, reports, and KPIs in business critical systems such as Salesforce and/or other business intelligence tools.

Key Requirements and Responsibilities

• Define and uphold data hygiene and data stewardship best practices for Assent.
• Lead in the design, development, and maintenance of complex data pipelines using Fivetran, dbt, Snowflake, and Hightouch.
• Set coding standards and best practices for the data engineering team.
• Conduct code reviews to ensure quality and consistency.
• Solve complex data puzzles through innovative design and architecture.
• Mentor less experienced engineers, providing technical guidance and career development support.
• Lead initiatives to mature existing capabilities and introduce new capabilities into Assent's data practice.
• Conduct reverse ETL processes to push metrics and system elements into operational systems for enhanced context.
• Analyze and interpret complex data sets to inform business decision-making.
• Coordinate and align internal stakeholders, including Sales, Marketing, Product, Finance, and Customer Success, to ensure data accuracy and quality.
• Collect large, complex data sets that meet functional / non-functional business requirements into unified cloud storage where you will reformat, cleanse, model, and embed quality rules making data fit for purpose.
• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
• Develop standards for data processes and automate where possible.
• Train and develop both internal resources as well as Subject Matter Experts in different departments on proper ways to query, analyze and use data.
• Lead/support the creation of functional and technical documentation related to data solutions.
• Support business operations to identify, define and automate key metrics.
• Identify opportunities and work with other departments to ensure common efficiencies and best practices are leveraged organization-wide.
• Make recommendations based on identified insights that improve efficiency.
• Provide technical guidance and mentorship to other team members.

Requirements

• Degree in a related field and 7+ years of data engineering experience.
• Expertise in SQL, Python or R, and AWS.
• Strong project management skills and the ability to communicate complex concepts effectively.
• Mastery in tools such as Fivetran, dbt, Snowflake, Hightouch, Git, R, Python, SQL, SQL Server, and AWS.
• Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
• Demonstrated effectiveness in supporting organizational data analytics solutions.
• Proficient in Data Management and Business Intelligence, coupled with exceptional mathematical acumen and meticulous attention to detail in data collection, reporting, and analysis.
• Adept at conveying complex data insights through a robust understanding of data management systems, warehouse methodologies, data quality standards, data modeling techniques, governance protocols, and advanced analytics.
• Exceptional skills in influence and negotiation, marked by a high level of professionalism and the ability to articulate data insights both visually and verbally to guide business discussions.
• Experience in leading data engineering teams.
• Familiarity with agile work environments and scrum ceremonies.
• Strong business acumen and experience in aligning data initiatives with business objectives.
• Experience in data analysis and visualization tools like Tableau or Power BI.