Data Warehouse Architect - Miami, United States - American Auto Shield

Description

** Data Warehouse Architect**

**Job Category****:** Data Governance **Requisition Number****:** DATAW001913 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 Architect that will work in the Data Governance and Strategy team and assist with related projects in Data Warehouse, BI and Azure environment. This role requires the expertise of Data Integration, Data Modeling, Business Process Optimization, Master Data Management, Analysis Cubes, 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

Handling large amount of data with seamless processes

Develop the sustainable data integration processes across the systems in on-premises and cloud environments

Design the analysis cubes as a Data Mart from the Enterprise Data Warehouse

Equip the knowledge and experience in the Insurance or Auto Warranty Service industries

Work closely with Director of DGS to develop the strategy of end-to-end business processes

Demonstrate the solution development expertise in Database and Data Warehouse

Provide the standardized guidelines for the solution design and development

6-7 years experience required

Strong SQL Server Database knowledge and experience

Strong knowledge and experience on MS BI stacks (SSIS, SSAS, and SSRS)

Experience of MS MDS (Master Data Services)

Experience of Azure cloud environment (ADF, ADLS, Analysis Services, and Azure SQL)

Experience of BI Tools (Power BI, Tableau, Looker)

Experience of OLAP Cubes (Multi-Dimensional, TABULAR and Azure Analysis Services)

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

Self-motivated and Detail-Oriented

Excellent time/project management skills and 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

SSAS

SSIS

SQL Service

Azure Data

Competitive compensation package ranging from $90,000-110,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

**Qualifications**

**Skills**

**Behaviors**

**:**

**Motivations**

**:**

**Education**

**Experience**

**Licenses & Certifications**