Lead Data Warehouse Developer

Data Warehouse Lead

The Data Warehouse Lead will play an integral role in defining and building a data warehouse platform that drives innovation, growth, and data-driven change.

If that grabbed your attention, come grow with us!

Introductions first!

You-

• Are results-oriented and not afraid to jump into the deep end.
• Thrive working in a collaborative environment and enjoy helping others.
• Enjoy thinking outside the box to drive changes that will impact our industry.
• You love what you do, and it shows every day.

Us-

• We’re 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. You’ll join an incredible team filled with smart, fun, passionate people who love making an impact.
• We believe in creative environments, progressive ideas and excellence in operational effectiveness.
• We love what we do.

What will you do in this role?

You will…

• Be responsible for driving next-generation data & analytics solution development using Azure Cloud.
• Define modern data warehouse project strategy, architecture, design, and processes.
• Lead the activities of the team to build modern, cloud optimized, data analytics solution that is scalable, robust, and extensible.
• Analyze problems and figure out the most suitable technical solutions.
• Maintain extensive documentation - user guide, process & data flow charts, ER diagrams and workflows using PowerPoint and MS Visio.
• Define standards and best practices for data ingestion, data cleansing, modeling, queries, and data quality.
• Lead day-to-day implementation work and escalate issues as they arise to management and provide status updates.
• Collaborate with other teams across the company as necessary to ensure user needs are met.
• Cross train team members to build additional capacity to support and enhance data warehouse and data integration processes
• Stay current on cloud tech trends and recommend products and services to meet business needs
• Perform other duties and responsibilities as assigned.

 What will you need to bring to the table in order to be successful in this role?

• Bachelor’s degree in Computer Science, Data Analytics, Business Information System, Mathematics, Statistics, or equivalent suitable experience.
• Bachelor’s level degree in a related field plus 10 years of experience
• Proficient in Microsoft Stack (SQL Server, SSIS, SSAS), Azure SQL Database, Azure Data Factory & Pipelines, SSIS-Integration Runtime, Azure Data Lake, SSIS Add-On Solutions (KingswaySoft, Task Factory), and MS Master Data Services
• Must understand Power BI Desktop/Service and DAX
• Must understand Azure Analysis Services or SSAS Tabular Model
• Experience in end-to-end implementation of Data Warehouse projects
• Experience and knowledge on data integration with Salesforce
• Hands-on experience of T-SQL to write simple to complex queries, to create Views and Stored Procedures
• Excellent Project Management with ADO (Azure DevOps)
• Well-developed skills in prioritizing, organization, decision making, time management, and verbal/written communication skills
• Creativity and alternative thinking to develop new ideas for and answers to work-related problems.
• Knowledge of business and management principles involved in strategic planning.
• The ability to generate ideas that create value and improve processes.

Why work for us? We are excited to provide:

• Competitive compensation package ranging from $120,000-$130,000/annually
• Comprehensive benefits package
  • Medical
  • Dental
  • Vision
  • Short/Long Term Disability
  • Life Insurance
  • Flex Spending Account
• 401 (k) – company matches 4%
• Paid Time Off
• Floating Holidays
• Employee Assistance Program
• Voluntary Benefits
  • Pet Insurance
  • Life Insurance
• Wellness program
• Employee recognition program.
• Satisfaction of work with a highly skilled team that makes a big impact company-wide.
• 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
• Florida
• Indiana
• Kansas 
• Kentucky
• Michigan
• Missouri
• Ohio
• Oklahoma
• Tennessee
• Texas
• Virginia

Salary : $120,000 - $130,000