Data Warehouse Developer

Responsiblties:

• Create and maintain reports using multiple Microsoft technologies.
• Develop and implement databases required for business intelligence applications.
• Gather and document business data requirements into data models and database designs.
• Work with project leads in analyzing system requirements and specifications and translating those requirements into database designs.
• Understand business requirements, and perform data analysis, estimation, database programming, testing and implementation.
• Ensure smooth and reliable operation of data systems for fulfilling business objectives and processes.
• Develop and implement databases required for business intelligence applications.
• Gather and document business data requirements into data models and database designs.
• Work with project leads in analyzing system requirements and specifications and translating those requirements into database designs.

Qualifications:

• 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.
• Ability to understand and create complex SQL queries, stored procedures; import, export, data transformation; Experience with batch data processing from upstream systems, troubleshooting issues; using multidimensional SSAS Analysis.

Key Skills:

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