Join us for an exciting career with the leading provider of supplemental benefits!

Our Promise
Through skill-building, leadership development and philanthropic opportunities, we provide opportunities to build communities and grow your career, surrounded by diverse colleagues with high ethical standards.

The Data Engineer contributes to design, implementation, and maintenance enterprise database systems that support large-scale business operations. The team drives innovation, ensures compliance, and maintains high availability of critical data assets.

The Data Engineer contributes the strategic management of reporting database environments, ensuring their scalability, security, and efficiency. This role includes mentoring junior staff, driving database architecture decisions, and leading complex database initiatives.

Competencies:

Functional:   

• Architect and implement enterprise-level database solutions to meet organizational goals.
• Oversee the scalability, performance, and security of the reporting database environments.
• Lead complex migration projects, including upgrades and cloud integrations.
• Establish and enforce database governance policies and best practices.
• Build data pipelines for data ingestion, processing, and transformation in SSIS.
• Work together with data scientists and analysts to understand the needs for data and create effective data workflows.
• Create data flow solutions including Azure Synapse, Azure Data Lake, and Azure Blob Storage.
• Conduct regular capacity planning and performance reviews.

Core:

• Experience with database architecture, design, and implementation at an enterprise scale.
• Advanced knowledge of RDBMS and distributed database technologies.
• Leadership and decision-making skills in high-pressure situations.
• Exceptional problem-solving abilities and attention to detail.
• Experience in database resource management
• Experience in Agile concepts (Kanban boards)
• Advanced understanding of regulatory compliance standards for data management.

Behavioral:

• Collegiality: building strong relationships on company-wide, approachable, and helpful, ability to mentor and support team growth. 
• Initiative: readiness to lead or take action to achieve goals.
• Communicative: ability to relay issues, concepts, and ideas to others easily orally and in writing.
• Member-focused: going above and beyond to make our members feel seen, valued, and appreciated.
• Detail-oriented and thorough: managing and completing details of assignments without too much oversight.
• Flexible and responsive: managing new demands, changes, and situations.
• Critical Thinking: effectively troubleshoot complex issues, problem solve and multi-task.
• Integrity & responsibility: acting with a clear sense of ownership for actions and decisions and to keep information confidential when required.
• Collaborative: ability to represent your own interests while being fair to those representing other or competing ideas in search of a workable solution for all parties.

Minimum Qualifications:

• Bachelor’s degree in computer science, Data Management, Information Systems, or related field. High School Degree or equivalent required.
• 7+ years of experience engineering data architecture solutions in enterprise-level environments.
• Expertise with RDBMS and distributed database technologies.
• Strong experience using T-Sql.
• Experience in database resource management.
• Understand how to manage code performance.
• Experience developing data pipelines for data ingestion, processing, and transformation in SSIS.
• Experience building and managing SSRS portal.
• Experience with SSIS and/or SSRS ETL tools.
• Understand version control (Github, Teraform, CI/CD).
• Experience with cloud services such as AWS and/or Azure.
• Experience designing data flow solutions using Azure Synapse, Azure Data Lake, and Azure Blob Storage.
• Efficient with code automation and building dynamic automated processes.
• Experience with data visualization with Power BI.
• Experience building data models representing enterprise initiatives

FLSA Status: Salary/Exempt

National Salary Range: $81,650 - 159,730

Bonus Eligible: Annual Incentive Plan (AIP)

How to stay safe:

Avesis is aware of fraudulent activity by individuals falsely representing themselves as Avesis recruiters. In some instances, these individuals may even contact applicants with a job offer letter, ask applicants to make purchases  (i.e., a laptop o