Data Warehouse Developer - Denver, United States - American Auto Shield
Description
** Data Warehouse Developer**
**Job Category****:** Data Governance **Requisition Number****:** DATAW001712 Showing 1 location **Job Details**
**Description**
**BI. Azure. SQL. SSIS**
If this grabbed your attention, come grow with us
American Auto Shield (AAS) specializes in vehicle and home service contract development and superior claims administration. We are looking for a DW Developer that will work in the Data Governance and Strategy team and assist with related projects in the companys Data Warehouse environment. This role requires the expertise of Data Integration, Business Process Optimization, and Data Quality Assurance.
Introductions first
**You-**
Have a strong background in data modeling
Have excellent research, data gathering and communication skills.
Are creative, and think outside the box to solve problems.
Love what you do, and it shows every day
**Us-**
We are leading our industry into the future by creating and shaping the future of Service Contracts and Claims Administration. We're developing systems from the ground up and will give you the opportunity to be a part of our quest for greatness.
We offer the ability to pursue your fullest potential and never settle for second place in your quest to grow your career. Youll join an incredible team filled with smart, fun, passionate people who love making an impact.
We believe in providing a creative environment, encouraging progressive ideas and rewarding excellence in operational effectiveness.
We love what we do
***You will***
Identify, analyze, and interpret the requirements from Business Departments as an architectural process, and data modeling
Optimize current processes with effectiveness in system resources and performance
Develop the sustainable data integration processes across the systems in on-premises and cloud environments
Equip the knowledge and experience in the Insurance or Auto Warranty Service industries
Work closely with Data Warehouse Architect to generate the reports
Demonstrate the solution development expertise in Database and Data Warehouse
**Supervisory Responsibilities**
This job has no supervisory responsibilities.
4-5 years of experience required
Strong SQL Server Database knowledge and experience
Strong knowledge and experience on MS Business Intelligence stacks (SSIS, SSAS, and SSRS)
Experience of Azure cloud environment (ADF, ADLS, Analysis Services, and Azure SQL)
Experience of BI Tools (Power BI, Tableau, Looker)
Strong knowledge of ADO (Azure DevOps) and Project Management (Agile and Waterfall)
Advanced Excel skills (Power Query, Power Pivot)
Strong data analytical skills to handle significant amounts of information with details and accuracy
Strong communication skills, both written and verbal, with documentation
S elf-motivated and Detail-Oriented
Excellent time/project management skills
Creative problem-solving abilities
**One or more of the following certifications are preferred:**
Bachelors degree in Computer Science, Data Analytics, Business Information System, Mathematics, Statistics or equivalent suitable experience.
Tableau Data Model/Cloud
SSIS
SSAS
SQL Service
Azure Data
Competitive compensation package ranging from $75,000-90,000 per year
Comprehensive benefits package
PTO/Floating Holidays
Satisfaction of work with a highly skilled team that makes a big impact
100% Remote work environment
**Job Location**
This role is 100% remote; however American Auto Shield is only set up to hire employees in certain states. To be considered for this role, you will need to have permanent residence in one of the following states:
Arizona
Colorado
Missouri
Oklahoma
Texas
Ohio
Kentucky
Indiana
Tennessee
Virginia
Florida
American Auto Shield was founded in 2002 in Lakewood, Colorado, where we are still headquartered today. We specialize in third-party administration of vehicle and home service contracts and related automotive and home claims administration. Our expertise complemented by our strategic partnerships allow us to develop and deliver products that provide superior coverage and service. We have experienced tremendous growth which creates great opportunities for our employees. Within the past 12 months we have earned more than a 400% increase in new contract volume. Today, we have grown to more than 700 full-time employees across multiple locations that include our Denver metropolitan HQ and other locations across the country.
**Skills**
**Education**
**Experience**