SQL/BI Engineer

T

Trademark Recruiting

SQL/BI Engineer

Tampa, FL
Full Time
Paid
  • Responsibilities

    Hybrid Data Engineer position (T-SQL/SSIS/Power BI)

    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

    Team of 7

    This position will be doing mostly T-SQL work (60%).  The other 40% will be split between SSIS and Power BI work)

    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.