Data Warehouse III

assuranceamerica; United States; On-site; USD 110,000 - 140,000; Full time

Job summary

AssuranceAmerica is seeking a senior SQL/Data Warehouse Developer to help replace legacy data warehouse systems with modern Azure/Cloud-based solutions. You will design and implement ETL processes, build SSAS OLAP cubes, and collaborate with business representatives to gather requirements and review progress.

The role requires 7+ years of SQL/Data Warehouse experience, strong SQL tuning, and familiarity with SSRS/SSAS in a SQL Server environment.

Qualifications

• 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 of and experience with SQL (candidates will be tested), creating performance tuned stored procedures and functions, SSRS (or equivalent).
• Experience with ETL development strongly preferred; able to design, develop, tune, and maintain OLAP cubes using Microsoft SSAS strongly preferred.

Responsibilities

• Assist with research, recommendations, and implementation of Azure/Cloud technologies to replace legacy data warehouse systems.
• Develop ETL packages for translation and movement of data between vendor systems and the Data Warehouse.
• Build, extend and maintain SSAS OLAP cubes.
• Proactively communicate with business representatives to extract requirements and review progress.

Skills

SQL

SSAS

ETL development

Data warehousing

Auto insurance knowledge

Communication skills

Team player

Education

Bachelor's degree

Tools

SQL Server

SSRS

Job description

About the ROLE

• Assist with research, recommendations, and implementation of newer Azure / Cloud based technologies to replace legacy data warehouse systems and processes
• Develop ETL packages for translation and movement of data between vendor systems and the Data Warehouse.
• Build, extend and maintain SSAS OLAP cubes.
• Proactively communicate directly with business representatives to extract requirements and review work in progress.
• Assist in monitoring production jobs, correcting failures, troubleshooting and solving problems
• Manage break/fix events and drive solutions to correct and prevent recurring issues
• Monitor and improve overall health of the data warehouse environment
• Communicate data warehouse related issues, changes and outages to department manager and end-user community
• Recommend standards, procedures, and policies that help both the internal group as well as other operations and customer groups
• Organize work schedule to achieve timely processing of all responsibilities
• Identify opportunities to improve the Business
• Demonstrate a proactive and self-motivated approach to learning new technologies and techniques to enhance development skills.

Job Qualifications

Formal Education & Certification

Requires a 4 year degree in a related technical area or equivalent experience

Knowledge & Experience

• 7+ years of experience as a SQL / Data Warehouse Developer in a SQL Server or equivalent environment
• Strong knowledge of and experience with SQL (candidates will be tested), creating performance tuned stored procedures and functions, SSRS (or equivalent)
• Experience with ETL development strongly preferred. Ability to design, develop, tune, and maintain OLAP cubes using Microsoft SSAS strongly preferred.

Skills & Competencies

• Ability to work in a fast-paced automated production environment.
• Auto insurance experience preferred.
• Good oral and written communications skills.
• Well-developed critical thinking skills.
• Works as a team player throughout the company.
• Must be professional and maintain an acceptable level of integrity and professionalism.