Data Engineer

Title

Data Engineer

Location

Remote near Edina, MN or Raleigh, NC

About Us

A full-service advisory firm, Curi is comprised of three distinct businesses: Curi Insurance, its flagship medical malpractice liability insurer; Curi Advisory, its consulting arm; and Curi Capital, a registered investment advisor (RIA). What we all have in common is an unwavering commitment to serving clients. As fierce healthcare advocates, business leaders, and thoughtful partners, Curi offers unmatched access and exudes a deep understanding of specific client circumstances. With exceptional accessibility and dedication, Curi's trusted expertise, ability to form deep relationships, and holistic approach deliver outcomes that are proven, actionable, and meaningful-in medicine, business, and life.

The Role

We are looking for a collaborative self-starter to work on our Data Services team as a Data Engineer. In this role, you will report to our Manager, Data Engineering and will be involved in data Lakehouse development including requirements gathering, database modeling, ETL and dashboard/report development activities. You will frequently conduct data analysis, write advanced database queries, and optimize data storage needed by business and/or executive operations. You will enable daily business activities by providing the foundation of all federated querying and analysis produced by the BI, Actuarial, and Data Science teams.

Key Result Areas

Develop and maintain enterprise data warehousing platform

• Work with business users to establish data warehousing and data lake requirements
• Develop and maintain ETL to support the Data and Analytics reporting platform
• Development of SQL procedures, triggers, views, functions, and reports to support enhancement to critical SQL based business systems for existing systems
• Support legacy Enterprise Data Warehouse (Oracle)
• Participate in peer code reviews, unit testing and documentation of code developed

Maintain data Lakehouse, ETL, and reporting environments

• Participate in design, coding, testing, implementation, and documentation of solutions
• Contribute to, enforce, and document database policies, procedures and standards
• Provide technical and business knowledge support to the team
• Participate in data governance
• Perform tests and evaluations regularly to ensure data security, privacy and integrity

Detect and resolve production performance issues

• Participate in performance tuning and database optimization
• Provide ongoing maintenance support through query tuning and optimization
• Analyze troubleshoot and remediate data integrity issues

Key Skills

• Strong working knowledge of:
  • PL-SQL (including complex querying)
  • Python
• Must be a self-starter who requires minimal supervision, with excellent problem-solving skills with a focus on data quality and performance optimization
• Familiarity with Data Lake and/or Lakehouse concepts
• Exposure to Cloud Database Management Systems
• Proven ability to design and develop ETL processes for Kimball star schema data warehouse and reporting platform (Oracle preferred)
• Solid understanding of relational database theory, principles, and best practices
• Excellent analytical skills with the ability to identify patterns and insights from large datasets
• Strong collaboration skills to work effectively with cross-functional teams and stakeholders

Key Qualifications

• 2-4 years of data engineering experience
• Property and casualty insurance data experience preferred

Our Vision: To be the trusted partner in medicine, business, and life.

Our Mission: By providing valued advice and support, we help strengthen care, mitigate risk, and build financial futures to enhance the lives of those we serve.

Our Values:

ACCOUNTABILITY: We are driven to act, work with integrity, and deliver results.

CURIOSITY: We ask and listen, stay curious, and are eager to learn.
TEAMWORK: We build strong relationships, celebrate success, and partner for greater impact.
INCLUSION: We respect, recognize, and encourage the differences that make us stronger-we are better together.
SERVICE COMMITMENT: We demonstrate an unwavering commitment to our clients, business partners, teammates, and communities.

Our Benefits

Curi offers eligible team members and their dependents comprehensive health benefits, including medical, dental, vision, and life insurance.Other benefits for eligible team members include education assistance, annual bonus opportunity, 401(k) and employer match, short-term disability, long-term disability, flexible time off, and 13 paid holidays annually.

#LI-JG-1

#LI-remote