BI Engineer - Principal

Position Summary: Non-Supervisory Job Descriptions

We are looking for an energetic high-performing BI Engineer who will be responsible for both development on BI & Analtyics as well as software application design, development, testing, and problem resolution of software and web applications. The scope of work includes small system enhancements to major system projects. Applications may include custom developed software, commercial packaged software, or open-source software. Software may consist of on premise applications, cloud-based software and services, hybrid configurations, integration tools, or business workflow tools. Create and maintain documentation of all development activity. Act as a key contributor in a complex team environment with multiple departments, vendors and functions. May lead teams or projects while sharing your expertise

Responsibilities:

• Produce intelligence reports (obtain information from internal and external sources, assess the value and provide actionable insight).
• Work on ad-hoc requests and produce the required deliverables as mandated by the requests.
• Responsible for data quality both for the raw data as well as the integrity of the calculations used for Measures
• Analyze and troubleshoot complex data cleansing, data integration, and data warehouse system issues, identify the reasons for problems, failures and malfunctions and develop optimal solutions.
• Monitor data integration and reporting anomalies and make adjustments as required.
• Work on Data conversion projects - from Legacy to Guidewire.
• Work on Cloud Data Projects - using Azure, Guidewire Cloud Data Access, etc.
• Will be responsible for a set of Compliance related reporting from Enterprise Data Warehouse
• Function as an active member of an agile team through consistent development practices (tools, common components, and documentation)
• Conduct integration tests as defined in the test specifications, including event logging and reporting of results
• Perform unit and assembly testing of data software components including the design, implementation, evaluation, and execution of unit and assembly test scripts
• Conduct code reviews and tests of automated build scripts
• Debug data components, identifies, fixes and verifies remediation of code defects

Qualifications:

• Bachelor's degree required in Computer Science, Information Technology or a related field. Valid experience will be considered along with a Bachelor's degree in another discipline.
• 3+ years of database (SQL Server) development experience with excellent query and stored procedure skills (T-SQL). Senior Engineers will have 5+ years of experience
• Should have experience with ETL using SSIS and other ETL tools. Should have excellent knowledge of building and using T-SQL Stored Procedures.
• Experience with Power BI is desirable, If new then will have to learn quickly
• Experience with standard frameworks for reconciliation and traceability of data.
• Strong and effective inter-personal and communication skills and the ability to work well with teams internal to the department as well as other departments
• Must keep up to date with industry best practices and latest trends in BI & Analytics and incorporate them into the methodology at Heritage Insurance.
• Must be willing to work outside the normal scope of business hours
• Read, interpret and apply complex technical publications, manuals and other documentation.
• Working knowledge of system analysis, design, testing, software configuration and troubleshooting techniques.
• This position is based within an assigned region; travel throughout the region is required with occasional travel to locations beyond the assigned region.
• Company paid pre-employment drug test and health screening required.

General Information:

All employees must pass a pre-employment background check. Other checks may be needed based on position: driving history, credit report, etc.

The preceding job description has been designed to indicate the general nature of work performed; the level of knowledge and skills typically required; and usual working conditions of this position. It is not designed to contain, or be interpreted as, a comprehensive listing of all requirements or responsibilities that may be required by employees in this job. Nothing in this job description restricts management's right to assign or reassign duties and responsibilities to this job at any time.

Heritage Insurance Holdings, Inc. is an Equal Opportunity, Affirmative Action Employer. We will not discriminate unlawfully against qualified applicants or employees with respect to any term or condition of employment based on race, color, national origin, ancestry, sex, sexual orientation, age, religion, physical or mental disability, marital status, place of birth, military service status, or other basis protected by law.