What are the responsibilities and job description for the BI Engineer position at Vaco by Highspring?
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.
Salary : $90,000
