Data Warehouse III

🔥 0 minutes ago

🤠 Texas – Remote

🤠 Texas – Remote

⏰ Full Time

🟠 Senior

🔴 Lead

🚰 Data Engineer

🦅 H1B Visa Sponsor

This company has sponsored H1B visas in the past.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

AssuranceAmerica

WebsiteLinkedInAll Job Openings

201 - 500 employees

Founded 1999

💼 Consulting

🏥 Healthcare

🛡️ Insurance

Consulting • Healthcare • Insurance

AssuranceAmerica is an insurance company dedicated to providing affordable insurance policies while giving back to the community. With a commitment to social responsibility, they donate 5% of their profits to support those in need. The company offers a variety of payment options and features a user-friendly mobile app for customer convenience, enabling clients to manage policies easily and connect with agents across the United States.

📋 Description

• Research, recommend, and implement newer Azure/cloud-based technologies to replace legacy data warehouse systems and processes • Develop ETL packages to translate and move data between vendor systems and the Data Warehouse • Build, extend, and maintain SSAS OLAP cubes • Communicate directly with business representatives to extract requirements and review work in progress • Monitor production jobs, correct failures, troubleshoot, and solve problems • Manage break/fix events and drive solutions to correct and prevent recurring issues • Monitor and improve the overall health of the data warehouse environment • Communicate data warehouse-related issues, changes, and outages to the department manager and end-user community • Recommend standards, procedures, and policies for internal, operations, and customer groups • Organize work schedules to achieve timely processing of responsibilities • Identify opportunities to improve the business • Learn new technologies and techniques to enhance development skills

🎯 Requirements

• Requires a 4 year degree in a related technical area or equivalent experience • 7+ years of experience as a SQL / Data Warehouse Developer in a SQL Server or equivalent environment • Strong knowledge and experience with SQL; candidates will be tested • Experience creating performance-tuned stored procedures and functions • Experience with SSRS or equivalent • Experience with ETL development strongly preferred • Ability to design, develop, tune, and maintain OLAP cubes using Microsoft SSAS strongly preferred • Ability to work in a fast-paced automated production environment • Auto insurance experience preferred • Good oral and written communication skills • Well-developed critical thinking skills • Ability to work as a team player throughout the company • Must be professional and maintain an acceptable level of integrity and professionalism

🏖️ Benefits

• Opportunity to learn and grow • Employer directs 5% of earnings to fight homelessness