What are the responsibilities and job description for the Data Engineer position at SBLI?
SBLI is seeking a skilled and motivated Data Engineer to join our team. In this role, you will work at the intersection of technology and business to design, develop, and optimize data infrastructure, enabling our organization to leverage data for strategic decision-making. This is an exciting opportunity to be part of a dynamic team, supporting SBLI's mission to deliver innovative life insurance solutions.
Roles and Responsibilities:
• SQL Expertise: Develop and execute SQL queries for data extraction, transformation, and loading; create and maintain views, materialized views, stored procedures, and functions.
• Business Requirements: Collaborate with stakeholders to gather requirements and translate them into functional code.
• Data Modeling: Skilled in designing data models with attributes, metrics, and dates to represent data structures and relationships.
• Data Warehousing: Proficient in star schema, snowflake schema, fact/dimension tables, and data warehouse design.
• ETL Development: Expertise in ETL tools for data extraction, transformation, and loading.
• Unix Scripting: Write and maintain shell scripts for data handling and automation.
• Troubleshooting: Debug and optimize SQL queries and ETL processes to resolve issues and improve performance.
• Communication: Effectively convey technical ideas, progress, and challenges to stakeholders and team members.
• Collaboration: Partner with developers, analysts, and business stakeholders to create integrated and effective data solutions.
Qualifications:
• Bachelor’s degree in computer science, information technology, or a related field
• 4 years developing Database Warehousing, Analytics and ETL Development
• Experienced in software development life cycle (SDLC)
• Experienced in writing SQL queries using PL/SQL
• Experienced in Data modeling
• Experience in using ETL tools like Oracle Data Integrator (ODI) or any other tools
• Experienced in collecting requirements through stakeholder collaboration
• Experienced with Unix scripting
• Experienced working with Oracle and MS SQL Server databases
Key Products/Software:
• SQL Developer/Toad
• Microsoft SQL Server
• Oracle Analytics Cloud (OAC)
• Oracle Data Integrator (ODI)
• Oracle Data Visualizer/Tableau
• Salesforce
• Microsoft Fabric
