Business Intelligence Engineer

Trademark Recruiting/Consulting; Tampa (FL); On-site; USD 90,000 - 110,000; Full time

Job summary

Trademark Recruiting/Consulting is seeking an energetic Data/BI Engineer to design, develop, test and resolve issues across BI and analytics workloads. You will work with on-premise, cloud and hybrid configurations, documenting all development activity and potentially leading teams or projects.

The role emphasizes insurance or healthcare policy/claims experience, with responsibilities spanning data integration, quality, and reporting within an enterprise data warehouse environment.

Qualifications

• Bachelor’s degree required in Computer Science, Information Technology or a related field.
• 3+ years of database (SQL Server) development experience with strong T-SQL skills.
• Experience with ETL using SSIS and other ETL tools; Power BI desirable.
• Experience with data quality, data integration and data warehouse concepts.
• Ability to work in an Agile team and lead projects when needed.

Responsibilities

• Produce intelligence reports from internal and external sources and provide actionable insight.
• Handle ad-hoc requests and deliver required outputs.
• Ensure data quality for raw data and calculation integrity for measures.
• Troubleshoot data cleansing, integration and warehouse issues; propose optimal solutions.
• Monitor data integration and reporting anomalies; adjust as needed.
• Work on data conversion projects from Legacy to Guidewire and on Cloud Data projects with Azure.
• Contribute to compliance reporting from the Enterprise Data Warehouse.
• Participate in agile development with standard tooling and documentation.
• Conduct unit and integration testing of data components and scripts.
• Review code and automated build scripts; fix defects.

Skills

SQL development

Data analysis

Data integration

Data quality

Data warehousing

ETL

T-SQL

Education

Bachelor’s degree in Computer Science / IT or related field

Tools

Power BI

Azure

Guidewire Cloud Data Access

Job description

We are looking for an energetic high-performing Data/BI Engineer who will be responsible for both SQL development on BI & Analytics 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

$90,000.00/yr - $110,000.00/yr

Must have experience with Insurance or Healthcare policy and or Claims experience

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-not a must-can learn Power BI
• 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
• 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.

Seniority level

• Seniority levelMid-Senior level

Employment type

• Employment typeFull-time

Job function

• Job functionInformation Technology
• IndustriesInsurance