BI Engineer

Client located in South Tampa is looking for a BI Engineer. This role will be on-site everyday for the first 90 days and then move to 1-2 days remote (hybrid).

Summary: The BI Engineer will be responsible for both development of BI & Analytics design, development, testing, and problem resolution of software and web applications. Scope of work includes small system enhancements to major system projects. Applications may include custom-developed software, commercial packaged software, or open-source software.

NEED: experience with SQL Stored Procedure/Proc
Preference: experience in Insurance industry (Propety & Casualty OR Health)

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


• Conduct integration tests as defined in the test specifications, including event logging and reporting of results


• 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.