Data Warehouse Developer

Qualifications:

• Bachelor’s Degree in Computer Science.
• 1+ years of Insurance and/or Commercial Auto  Insurance experience preferred.
• 2+ years of experience in Microsoft SQL Server development, Microsoft SSAS, SSRS, and SSIS development.
• Data warehouse development, implementation and operation of Star schema, Relational and Dimensional model, Cube development and Analytics; Experience building and maintaining reports - SSRS, Excel-based, Power BI.

Responsiblties:

• Develop and maintain Oracle PL/SQL packages and scripts to maintain daily operation of data loading from servers and ETL process.
• Develop and maintain reports and daily data feeds to other city agencies.
• Monitor and maintain real-time and overnight data processing schedules.
• Understanding existing ETL Workflows. Modifying/re-architect ETL workflows.
• Develop data models and ER diagrams for existing and new databases.
• Design, develop, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities.
• Work with the business users and internal teams in designing and delivering correct, high-quality data.
• Provide technical support and production support to all the data warehouse projects.

Key Skills:

• Data Marts.
• Cubes.
• ETL.
• Quality Assurance/Quality Control.
• Software Development Lifecycle Management.
• Unit Testing.
• Debugging.
• Data Flow Diagramming.