Data Engineer II

<strong>At Emergent Holdings, we&rsquo;re creating an innovative environment where our employees belong authentically, contribute meaningfully, and thrive intentionally &mdash; both personally and professionally.</strong>

Chicago, USA

Emergent Holdings

<p class="p1"><strong>Emergent Holdings is driven by a singular goal &mdash; improving the health and safety of our customers and our communities. How do we do that? We create innovative insurance products, technology solutions, and services to support our key stakeholders &mdash; individuals, employers, providers, and strategic partners &mdash; improving the health and safety of the people and places we serve.</strong></p>

keywords: job description,work environment,data,create,technical,education,experience,knowledge


Competitive Compensation and Benefits Package

Overview: <br />Collects, organizes, analyzes, interprets, and ensures accuracy of data in support of Data Science, Actuarial, and enterprise data needs. Serves as a liaison between Data Science, Actuarial, IT, and other business units. Provides data to support actuarial analysis including pricing, reserving, and regulatory reporting. Acquires, cleanses, and models Big Data in support of data scientists. Supports Actuarial and Data Science environments, monitoring the health and hygiene of databases. Architects and participates in the development of analytics applications.&nbsp;<br /><br /> <p><strong>WORKING CONDITIONS:</strong></p> <p>Work is performed in a home/office setting with no unusual hazards. Minimal travel.</p>
Responsibilities: <br /> <ul> <li>Query data using SQL</li> <li>Assist with the creation, implementation of new databases</li> <li>Assist with monitoring ADS environments</li> <li>Create technical documentation for code</li> <li>Advanced querying of data using SQL</li> <li>Creation and automation of business-facing reports and dashboards</li> <li>Independently create and implement databases and database structures</li> <li>Preparation of Big Data in support of data scientists</li> <li>Assist with the creation and support of analytics applications</li> <li>Monitor ETL processes</li> <li>Peer review code of coworkers</li> <li>Present results to executive audiences</li> <li>Assist with the creation of department strategy</li> <li>Providing support to the data and systems used by our Data Analysts and Data Scientists</li> <li>Working in an agile development team to iteratively deliver system updates and product releases</li> <li>Ensuring code quality through code reviews, thorough unit tests, and collaboration with QA.</li> <li>Creating elegant, well-tested solutions to complex problems.</li> </ul>
Requirements: <br /><br /><strong>EDUCATION OR EQUIVALENT EXPERIENCE:&nbsp;<br /><br /></strong> <ul> <li>Bachelor&rsquo;s degree in computer science, actuarial science, statistics, mathematics, or related field.</li> <li>Additional training/education in computer applications.</li> <li>An equivalent combination of education and experience may be considered in lieu of degree.&nbsp;</li> <li>Completion of or progress toward Azure Data Engineer Certification, Microsoft Certified Solutions Associate, SQL Database Development Certification, iCAS CSPA designation, or similar certifications is highly preferred.</li> </ul> <br /> <p><strong>EXPERIENCE:&nbsp;</strong></p> <ul> <li>Two years of experience working with data and/or development required.</li> </ul> <br /> <p><strong>SKILLS/KNOWLEDGE/ABILITIES (SKA) REQUIRED:&nbsp;</strong></p> <ul> <li>Advanced&nbsp;knowledge of SQL</li> <li>Advanced knowledge of relational database systems (Oracle or SQL)</li> <li>Strong working knowledge of ETL tools and processes</li> <li>Familiarity with advanced statistical concepts</li> <li>Familiarity with DevOps fundamentals (build, release, test, monitor)</li> <li>Strong understanding of database structure and data modeling</li> <li>Working knowledge of R, Python, and SSRS</li> <li>Working knowledge of Big Data platforms such as Hadoop and DataBricks</li> <li>Familiarity or exposure to Java and .net preferred</li> <li>Insurance and/or actuarial knowledge strongly preferred</li> <li>Medicare and/or actuarial knowledge strongly preferred</li> </ul>