What are the responsibilities and job description for the Senior Data Engineer position at Curi?
Title
Senior Data Engineer
Location
Remote
About Us
Curi is a full-service advisory firm comprised of three distinct business units-Curi Advisory, Curi RMB Capital, and Curi Insurance-each with an unwavering commitment to serve clients. As fierce physician advocates, smart business leaders, and thoughtful partners, Curi offers unmatched access and exudes a deep understanding of specific client circumstances. Dedicated, approachable, and authentic, Curi goes the extra mile and delivers proven, actionable, and meaningful outcomes-in medicine, business, and life.
The Role
We are looking for a skilled and experienced self-starter to work on our Data Engineering Team as a Senior Data Engineer. Reporting to our Manager, Data Engineering, you 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 querying and analysis produced by the Business Intelligence, Actuary, and Data Science teams.
Key Result Areas
Develop and maintain enterprise data warehousing platform
- Work with business users and the Data Architect(s) to establish data warehousing and data lake requirements
- Develop and maintain ETL to support the Data and Analytics reporting platform
- Develop SQL procedures, triggers, views, functions, and reports to support enhancement to critical SQL based business systems for existing systems
- Support existing Data Warehouse (Oracle and MS SQL Server)
- Lead 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:
- 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
- Experience with Data Lake and/or Lakehouse concepts
- Experience with Cloud Database Management Systems (Databricks strongly preferred)
- Proven ability to design and develop ETL processes for Kimball star schema data warehouse and reporting platform (Oracle and MS SQL Server 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
- At least eight 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.
Built On...
SERVICE COMMITMENT: We demonstrate an unwavering commitment to our clients, business partners, teammates, and communities.
Compensation
The base salary will be commensurate with an individual's work experience and educational background.
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.