Kemper is seeking a Data Engineer 4 to design, develop, and optimize enterprise data solutions that enable robust analytics, reporting, and business insights.
Requirements
- SQL development and query tuning
- Informatica and IICS for ETL and data integration
- Snowflake data warehouse architecture and development
- Oracle database systems
- Power BI for data visualization and reporting enablement
- Data modeling, normalization, and relational design
- Handling and transforming XML and JSON data structures
Responsibilities
- Design and Develop Data Solutions: Build, maintain, and optimize data pipelines and workflows that support reporting, analytics, and business applications using SQL, Informatica, IICS, and Snowflake.
- Data Processing and Preparation: Develop and manage data preparation routines for extracts, transformations, and reporting datasets, ensuring reliability and performance.
- Data Modeling and Optimization: Create and maintain logical and physical data models following normalization principles and best practices. Tune queries for optimal performance across Snowflake and Oracle environments.
- Integration and Automation: Work with various structured and semi-structured data formats (XML, JSON) and leverage AWS cloud frameworks for scalable data integration and processing.
- Data Security and Quality: Ensure compliance with data security policies and implement best practices for data protection, integrity, and confidentiality.
- Collaboration and Leadership: Partner with data analysts, developers, and business stakeholders to define data requirements, streamline processes, and improve data accessibility for reporting tools such as Power BI.
- Continuous Improvement: Recommend and implement improvements to data architecture, workflows, and governance processes. Serve as a mentor to junior team members and promote a culture of curiosity and continuous learning.
Other
- Bachelor’s degree in Computer Science, Information Systems, or a related field; equivalent work experience considered.
- 5+ years of experience in data engineering or database development.
- Strong problem-solving abilities and the capacity to work independently on complex technical challenges.
- High degree of self-motivation, intellectual curiosity, and commitment to continuous improvement.
- Sponsorship is not accepted for this opportunity.
