Data Engineer
Data Ideology, LLC
CloudETLJavaPythonSDLCSQLVault
Data Engineer
Curi
full-time
Posted on:
Origin: • 🇺🇸 United States • North Carolina
Visit company websiteSalary
💰 $80,000 - $110,000 per year
Job Level
JuniorMid-Level
Tech Stack
CloudETLOraclePythonSQL
About the role
- 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
- Develop SQL procedures, triggers, views, functions, and reports to support enhancements to critical SQL based business 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
Requirements
- 2-4 years of data engineering experience
- Strong working knowledge of PL-SQL (including complex querying)
- Proficiency in Python
- Proven ability to design and develop ETL processes for Kimball star schema data warehouse and reporting platform (Oracle preferred)
- Familiarity with Data Lake and/or Lakehouse concepts
- Exposure to Cloud Database Management Systems
- Solid understanding of relational database theory, principles, and best practices
- Experience with database modeling, ETL, and dashboard/report development
- Ability to write advanced database queries and optimize data storage
- Experience with performance tuning and database optimization
- 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
- Must be a self-starter who requires minimal supervision, with excellent problem-solving skills with a focus on data quality and performance optimization
- Property and casualty insurance data experience preferred
