Data Warehouse Architect

** Data Warehouse Architect****Job Category****:** Data Governance **Requisition Number****:** DATAW001917 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**