Data Engineer - Kuvare
Cedar Rapids, IA 52401
About the Job
About Kuvare
Kuvare is on a mission to serve hardworking consumers overwhelmed by the complexities of retirement and is built from the ground up to do so. Our unified financial hub protects the retirement of everyday Americans and the distributors, carriers and investors that serve them. We create life insurance and annuity products that protect consumers’ retirements, and are simplified for distributor partners and financial professionals to sell and service.
Kuvare family of companies:
Retail Annuity and Life Insurance Solutions:
- United Life Insurance Company
- Guaranty Income Life Insurance Company
- Lincoln Benefit Life
Institutional Insurance:
- Kuvare Life Re
Bespoke Insurance Solutions:
- Ignite Partners
About the role
The Kuvare Data Engineer is responsible for the retrieval, storage, and distribution of data across varied platforms and data stores, including modern ETL/ELT pipelines such as Azure Data Factory, as well as modern models such as data mesh and event streaming architectures like Azure Event Hub or Kafka. The individual will rely on broad experience in data modeling, including relational and dimensional models as well as semi-structured and unstructured data forms such as JSON, YAML, and PDF. This role has direct business impact by providing rapid enhancements to the data platform in support of new business relationships, new consumer products, etc.
What you'll do
- Research architectural trends, design methods, and emerging technologies, in adherence to and in support of company standards, helping Kuvare develop and maintain a nimble technology platform for adapting to new business opportunities.
- Work with Business SMEs and end users – including external business partners and vendors – to translate business requirements into technical specifications, including technical designs, data flow diagrams, and other technical artifacts.
- Create data pipelines to ingest, update, or transport data to/from any variety of data stores, from external data files to internal dimensional or relational models; and leveraging a broad toolset including SFTP, Azure Data Factory, Azure Event Hub, SQL Stored Procedures, etc.
- Leverage excellent SQL skills to build structured data repositories: tables, views, indexes, constraints, etc.
- Perform tests and evaluations to ensure reliability, data security, privacy, and integrity.
Other Responsibilities
- Ability and willingness to travel occasionally, such as for monthly meetings in the local office and an annual IT summit at a Kuvare hub office, which might be Baton Rouge, Cedar Rapids, or Chicago.
- Occasional evening and weekend work to meet deadlines.
- Other duties and responsibilities as assigned.
Qualifications
Required
- Bachelor’s degree in computer science, information systems, computer engineering or related field; or an equivalent combination of education and experience.
- Extensive experience with Microsoft SQL Server and the Azure environment.
- Expertise in relational and dimensional database modeling, data development and administration.
- Extensive experience with ETL/ELT pipelines including any combination of modern tools such as SSIS, Azure Data Factory, Function Apps, Logic Apps, etc.
- Analytic and problem-solving skills and experience.
- Excellent written and oral communication skills.
Skills/Competencies:
- Experience with data mesh and event streaming architectures including Azure Event Hub / Kafka.
- Experience with structured, semi-structured, and unstructured data forms such as YAML, and JSON.
- Experience prior to the current Azure stack: SSIS, SSAS, SSRS.
- Experience with Visual Studio, Azure DevOps, Git.
- Experience with data privacy practices and regulations, esp. in a highly regulated industry, is a plus.
Physical Demands:
- Normal office working environment
- Occasional evening and weekend hours to meet deadlines
- Ability to sit for extended periods of time
- Ability to type / perform data entry
- Ability to read from a computer screen and paper reports
- Express ideas and otherwise communicate with the spoken word
- Limited travel (5-10%) may be required
PI256497764