BI Developer
SafeAuto Insurance - Columbus, OH

This job posting is no longer available on sologig. Find similar jobs: Bi Developer jobs - SafeAuto Insurance jobs

Safe Auto Insurance Company

Job Posting Title: Business Intelligence Developer (Full Time - Growing Team - Influence)
Job Level: Sr. Developer
Department: Information Technology
Reports To: Manager, Data Team
FLSA Status: Exempt


SafeAuto’s Data team is at the forefront of enhancing SafeAuto’s data science infrastructure and capabilities. The focus of this team is enabling better business decisions through wide usage of robust data solutions. This includes maintaining our existing data environments while migrating us to new environments and capabilities. The team is responsible for the entire data analysis tool stack, including ETL development, warehouse modeling and development, and structured & unstructured data analysis toolsets. This position will be part of a development data team, not an operational team.

In this role the candidate will assist other SQL Developers and Business Intelligence developers to: design database structures, enforce good database practices, create SQL Server Data Tools deployment packages (DACPAC), create and deploy SSIS packages, create and deploy SSAS cubes, improve monitoring capability error logging and error recovery capability of ETL jobs. Knowledge and experience as or working with operational DBA team will be helpful.

Qualifications §
Good understanding of data warehouse design (Kimball, Inmon). §
Good understanding of OLAP and OLTP systems. §
Good understanding of how a database design is implemented as a physical database. §
Five to 10 years of experience as a Microsoft SQL Server Developer, Data Warehouse Developer or Microsoft SQL Server Database Administrator §
Experience developing and supporting SSIS required. Experience developing SSAS is desired and part of the goal objectives of this position.

Essential Duties and Responsibilities §
Develop database objects such as tables, views, common table expressions, dynamic SQL, foreign key constraints, and stored procedures. §
Designs logical and physical databases (OLAP and OLTP) or reviews description of changes to database design. §
Assist others with SQL performance tuning including index recommendations or hardware configuration considerations. §
Diagnose database issues related to development activities in development and test environments. §
Certification is a plus; MCSA, MCSE: Data Platform, MCSE: BI. §
Other, related duties, as assigned.

Supervisory Responsibilities
This job has no supervisory responsibilities.