Senior Data Engineer

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 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 or gift cards) from a designated vendor, have applicants fill out W-2 forms, or ask that applicants ship or send packages of goods to the company.

Avesis would never make such requests to applicants at any time throughout our job application process. We also would never ask applicants for personal information, such as passport numbers, bank account numbers, or social security numbers, during process. Our recruitment process takes place by phone and via trusted business communication platform (i.e., Zoom, Webex, Microsoft Teams, etc.). Any emails from Avesis recruiters will come from a verified email address ending in @Avesis.com.

We urge all applicants to exercise caution. If something feels off about your interactions, we encourage you to suspend or cease communications. If you are unsure of the legitimacy of a communication you have received, please reach out to [email protected].

To learn more about protecting yourself from fraudulent activity, please refer to this article link (https://consumer.ftc.gov/articles/how-avoid-scam). If you believe you were a victim of fraudulent activity, please contact your local authorities or file a complaint (Link: https://reportfraud.ftc.gov/#/) with the Federal Trade Commission. Avesis is not responsible for any claims, losses, damages, or expenses resulting from unaffiliated individuals of the company or their fraudulent activity.

We Offer

• Meaningful and challenging work opportunities to accelerate innovation in a secure and compliant way.
• Competitive compensation package.
• Excellent medical, dental, supplemental health, life and vision coverage for you and your dependents with no wait period.
• Life and disability insurance.
• A great 401(k) with company match.
• Tuition assistance, paid parental leave and backup family care.
• Dynamic, modern work environments that promote collaboration and creativity to develop and empower talent.
• Flexible time off, dress code, and work location policies to balance your work and life in the ways that suit you best.
• Employee Resource Groups that advocate for inclusion and diversity in all that we do.
• Social responsibility in all aspects of our work. We volunteer within our local communities, create educational alliances with colleges, drive a variety of initiatives in sustainability.

Equal Employment Opportunity

At Avēsis, We See You. We celebrate differences and are building a culture of inclusivity and diversity. We are proud to be an Equal Employment Opportunity employer that considers all qualified applicants and does not discriminate against any person based on ancestry, age, citizenship, color, creed, disability, familial status, gender, gender expression, gender identity, marital status, military or veteran status, national origin, race, religion, sexual orientation, or any other characteristic. At Avēsis, we believe that, to operate at the peak of excellence, our workforce needs to represent a rich mixture of diverse people, all focused on providing a world-class experience for our clients. We focus on recruiting, training and retaining those individuals that share similar goals. Come Dare to be Different at Avēsis, where We See You!

Originally posted on Himalayas