Senior Data Engineer

Job Type

Full-time

Description

Overview

Founded in 2002, American Auto Shield (AAS) specializes in 3rd party home and vehicle service contract claims administration. AAS has a headquarters in Lakewood, Colorado, and we operate a satellite office in St. Peters, Missouri. For more than two decades, American Auto Shield has experienced tremendous growth, which equates to fantastic career opportunities for our employees.

The Senior Data Engineer is a full time, onsite position in our Lakewood, CO office. This position is responsible for database design, data analysis, ETL processes associated with daily business processes, integration and maintenance of enterprise applications. The Senior Data Engineer will also be responsible for general administration and support of application databases and database servers. This Senior Data Engineer will also have the opportunity to work with Entity framework to convert stored procedures to .NET C entity framework modules.

Job Location

Lakewood, CO

Salary

The Senior Data Engineer earns competitive compensation from $100,000-$140,000.

What You Will Do in This Role

• Database design and modeling
• Development of ETL processes, in Microsoft Azure, related to the development and integration of enterprise applications
• Maintain the SQL Database DDL, DML, and permissions in a Visual Studio Database Project
• Setup, administration and operation of databases and database servers
• Develop stored procedures, views, and functions to support application functionality and reporting needs
• Maintain and Extend Entity framework ORM from existing SQL stored procedures.
• Collaborate as a member of the application development team
• Participate in business process analysis and requirements definition
• Provide database support and direction to other teams and team members
• Create and maintain data documentation and knowledge base articles
• Diagnose and troubleshoot database performance and scalability issues
• Evaluate and recommend automation based improvements
• Evaluate and make change recommendations of current Active Directory Roles and Users related to Azure DB's
• Other duties as assigned

Supervisory Responsibilities

This job has no supervisory responsibilities.

Requirements

What You Need to Join Our Team

Required Experience, Skills & Abilities

• 10+ years of IT and business/industry work experience
• 10+ years of database development experience
• Advanced knowledge of Microsoft SQL Server
• Advanced DDL and DML experience
• Advanced knowledge of data backup, recovery, security, integrity
• Experience migrating logic from Stored Procedures to C using Entity Framework
• Proficiency with database design and modeling
• Excellent analytical and communication skills
• Strong troubleshooting skills
• Ability to interface with internal customers at all levels of the organization

Preferred skills

• Setup, administration and operation of databases and database servers
• Ad Hoc report development
• Azure certifications
• Application development experience
• Application integration experience
• Experience deploying Azure SQL database changes via dacpac using Azure DevOps

Why work for us?

We are excited to provide

• Competitive compensation from $100,000-$140,000.
• Comprehensive benefits package
  • Medical
  • Dental
  • Vision
  • Short/Long Term Disability
  • Life Insurance
  • Flex Spending Account
• 401 (k)
• PTO
• Paid Sick/Wellbeing Time Off
• Employee Assistance Program
• Voluntary Benefits
  • Pet Insurance
  • Life Insurance
• Wellness Program
• Satisfaction of work with a highly skilled team to make a company-wide impact

Individual compensation packages are based on various factors unique to each candidate, including skill set, experience, qualifications, and other job-related aspects.

Eligible for 401 (k) the first of the month after the 1st 90 days.

Company Core Values

Our company core values are integrity, respect, accountability, collaboration, and innovation. These values serve as cultural cornerstones and the foundation of behaviors that drive our organization to excellence.