Qureos Mentor

EMC Insurance

<div><div><b>At EMC, we&rsquo;re all about working together to make an impact. As part of our team, you&rsquo;ll have the opportunity to grow, contribute, and gain experience that matters. We strive to be caring leaders, close partners, and responsive experts&mdash;always supporting each other to do our best work. Join us, and let&rsquo;s improve lives together.</b></div><div></div><div><b><br>
**This position is eligible to work a hybrid schedule within the Des Moines, Iowa Metro Area**</b></div><div></div><div><b>
E</b><b>ssential Functions:</b></div><div></div><div>
Develops, test, and maintains prioritized engineering (design/build/test) work as a member of a data analytics product pipeline architecture and infrastructure team:</div><ul><li>
Ensures delivery of solutions for organization of data, such as transformation, conformation, integration, and aggregation of data</li><li>
Partners with the Data Platform Operations (DPOs), Information Security, Network, and Operations teams to design and implement new data pipelines for new business initiatives as related to data and analytics</li><li>
Serves as a technical expert for the Data Engineering team</li><li>
Ensures best practices and internal processes are followed when solutions are designed and implemented</li><li>
Ensures the delivery of solutions for acquisition of data, such as landing, staging, rapid ingestion, and historical data extraction</li><li>
Creates processes framework, design and implementation of large-scale data conversion and data ingestion on various cloud and on-premise platforms using most optimal processing and programming techniques</li><li>
Investigates and analyzes feasibility of data integration prototypes and program requirements</li><li>
Develops specifications and plans the full range of programming actions to produce data integration components</li><li>
Develops and maintains highly complex automated ETL/ELT pipeline architecture that cleans, transforms, and aggregates data from disparate sources using architecturally approved tools, programming languages, and services to deliver a data mesh approach</li><li>
Develops and maintains highly complex automated ETL/ELT monitoring and alarming solutions using architecturally approved languages and services</li><li>
Monitors, troubleshoots, and optimizes data pipelines for quality, performance, and reliability creating a single source of truth providing business customers with highly reliable and quality data</li><li>
Builds highly complex unit tests to enable test driven development and automation to drive code reliability</li><li>
Develops, maintains, tests, and deploys code with architecturally approved toolsets using Dev Ops practices, ETL/ELT pipelines, data catalogs and data queries</li><li>
Serves as a technical resource and supports team members on EMC&rsquo;s data integration projects and helps them learn new technologies</li><li>
Leads evaluation of new technologies including performing POCs and presenting results to others, with a goal of providing technical recommendations</li><li>
Balances and designs data analytics product solutions based on cost and performance to meet business requirements</li><li>
Guides business customers to develop, troubleshoot, and optimize complex SQL and ETL/ELT solutions to solve reporting, metrics, and analytics problems.</li></ul><div></div><div>
Data analysis: Collaborates with cross-functional teams to understand data requirements for data analytics products and translate them into scalable and efficient data solutions:</div><ul><li>
Leads complex projects and provides subject matter expertise, support and advice to other projects being handled by the team</li><li>
Partners with users and stakeholders to understand data needs and business requirements</li><li>
Leads the team on conceptualizing and developing new data solutions to meet the business data needs and requirements</li><li>
Researches, performs analysis, and proposes effective solutions related to system developments and enhancements through collaboration with Data Architecture</li><li>
Analyzes and reviews potential adjustments or modifications for impacts on other programs</li><li>
Drives best practices in data governance, data security, and privacy principles to support data lineage and reference data needs.</li><li>
Collaborates with cross-functional teams to understand business and downstream application (BI reporting, Data Science, Data Governance, other System integrations) and consumer requirements to deliver data-driven solutions that implement best practices for data management, security, and governance</li></ul><div></div><div>
Data modeling:</div><ul><li>
Develops highly complex data objects for business analytics using data modeling techniques</li><li>
Models front-end and back-end data sources to help draw a more comprehensive picture of user flows throughout the system and to enable powerful data analysis</li><li>
Works with stakeholders to understand highly complex business needs and translates them into a conceptual data model, defining entities, attributes, and relationships</li><li>
Builds highly complex detailed logical models based on the conceptual model, specifying data types, constraints, and keys to ensure data integrity</li><li>
Implements highly complex logical models into appropriate database management system, considering database features, storage optimization, and performance considerations</li><li>
Designs highly complex data pipelines to extract data from source systems, transform it as needed based on the data model, and load it into the target database</li></ul><div></div><div>
Documentation:</div><ul><li>
Participates in creating and maintaining documentation related to the design of applications and interfaces to enterprise and third-party systems in accordance with departmental and team standards</li><li>
Collaborates with data governance on ensuring what is being produced in data analytics products enables data governance to publish a data asset</li><li>
Collaborates with data governance to develop and maintain data analytic products, artifacts and user documentation for business customers</li><li>
Works with business customers and software development teams to gather and document requirements for data publishing and data consumption via data mesh architecture.</li><li>
Maintains systems documentation</li></ul><div></div><div><b>
Education &amp; Experience:</b></div><ul><li>
Bachelor&rsquo;s degree, preferably in a computer related field or equivalent relevant experience</li><li>
Eight years of data integration development experience, or related experience</li></ul><div></div><div><b>
Knowledge, Skills, &amp; Abilties:</b></div><ul><li>
Excellent SQL Knowledge and experience working with relational databases</li><li>
Excellent analytics skills to work with unstructured datasets preferred</li><li>
Excellent knowledge of applicable programming languages such as Python</li><li>
Strong knowledge of cloud services such as RDS, S3, SNS, CloudWatch and Lambda</li><li>
Advanced knowledge of DBT/Informatica or other ETL/ELT tools preferred</li><li>
Excellent knowledge of Snowflake</li><li>
Excellent knowledge of data modeling</li><li>
Excellent ability to build processes supporting data transformation, data structures, metadata, dependency and workload management</li><li>
Excellent knowledge of orchestration or scheduling tools</li><li>
Excellent ability to manipulate, process and extract value from large, disconnected datasets</li><li>
Advanced knowledge of DevOps and/or DataOps practices, CI/CD pipelines, and containerization technologies preferred</li><li>
Excellent verbal and written communication skills</li><li>
Strong attention to detail, organizational and multi-tasking skills required with the ability to adapt to changing priorities</li><li>
Ability to maintain confidentiality</li></ul><div></div><div><b>
The hiring salary range for this position will vary based on geographic location, falling within either of the following:</b></div>
$103,954 - $149,372 or $114,895 - $164,309<div><b>
A hiring range represents a subset of the full salary range. The actual salary will depend on several factors, </b><b>including relevant</b><b> education, skills, and experience of an applicant, geographic location, and business needs.</b></div><div></div><div><b><br>
For information relating to the benefits EMC Team Members receive as part of a comprehensive rewards package, please visit </b><div><b>www.emcins.com/careers</b></div><b>.</b></div><div></div><div><i>
Our employment practices are in accordance with the laws that prohibit discrimination due to race, color, creed, sex, sexual orientation, gender identity, genetic information, religion, age, national origin or ancestry, physical or mental disability, medical condition, veteran status, active military status, citizenship status, marital status or any other consideration made unlawful by federal, state, or local laws.</i></div><div></div><div><b><i>
All of our locations are tobacco free including in company vehicles.</i></b></div></div><div></div>

Senior Data Engineer

<div><div><b>At EMC, we&rsquo;re all about working together to make an impact. As part of our team, you&rsquo;ll have the opportunity to grow, contribute, and gain experience that matters. We strive to be caring leaders, close partners, and responsive experts&mdash;always supporting each other to do our best work. Join us, and let&rsquo;s improve lives together.</b></div><div></div><div><div><b><br>
**Ideal candidate will be located in or near the Des Moines metro area**</b></div></div><div></div><div><b>
Essential Functions:</b></div><ul><li><div>
Investigates and evaluates minor to moderately complex physical damage claims and losses</div></li><li><div>
Reviews the loss notice and policy to verify coverage, deductibles, loss payee/mortgagees and confirms that the loss occurred within the coverage period</div></li><li><div>
Evaluates repair shop and independent appraiser estimates to determine accuracy</div></li><li><div>
Evaluates photos to determine if damages are consistent with loss or prior unrelated damages</div></li><li><div>
Evaluates vehicle values and repair costs to establish repair ability versus total loss</div></li><li><div>
Resolves questions of coverage, liability and the value of claims</div></li><li><div>
Negotiates, settles and/or resolves minor to moderately complex claims and losses</div></li><li><div>
Sets adequate reserves to cover exposure</div></li><li><div>
Prepares damage estimates using Mitchell estimating software</div></li><li><div>
Negotiates claim settlement with insureds, claimants and attorneys</div></li><li><div>
Negotiates agreed repair price with repair facility</div></li><li><div>
Issues payments within check authority</div></li><li><div>
Responds to questions from the insureds, claimants and agents</div></li></ul><div></div><div><b>
Education &amp; Experience:</b></div><ul><li><div>
High school diploma or equivalency</div></li><li><div>
Two years auto repair and/or property claims experience or related experience</div></li><li><div><b>
Multiple state insurance adjuster and appraiser licenses required within 6 months of hire</b></div></li></ul><div></div><div><b>
Knowledge, Skills &amp; Abilities:</b></div><ul><li><div>
Current technical knowledge of auto collision repair techniques and standards</div></li><li><div>
Strong knowledge of state statutes</div></li><li><div>
Strong interpersonal skills, conflict resolution, and negotiation abilities</div></li><li><div>
Good knowledge of personal computers, electronic estimatics software, and the use of reference manuals relevant to this field of work</div></li><li><div>
Excellent customer service skills</div></li><li><div>
Strong organizational and written and verbal communication skills</div></li></ul><div></div><div><b>
The hiring salary range for this position will vary based on geographic location, falling within either of the following:</b></div>
$51,201 - $70,730 or $56,581 - $77,796<div><b>
A hiring range represents a subset of the full salary range. The actual salary will depend on several factors, </b><b>including relevant</b><b> education, skills, and experience of an applicant, geographic location, and business needs.</b></div><div></div><div><b><br>
For information relating to the benefits EMC Team Members receive as part of a comprehensive rewards package, please visit </b><div><b>www.emcins.com/careers</b></div><b>.</b></div><div></div><div><i>
Our employment practices are in accordance with the laws that prohibit discrimination due to race, color, creed, sex, sexual orientation, gender identity, genetic information, religion, age, national origin or ancestry, physical or mental disability, medical condition, veteran status, active military status, citizenship status, marital status or any other consideration made unlawful by federal, state, or local laws.</i></div><div></div><div><b><i>
All of our locations are tobacco free including in company vehicles.</i></b></div></div><div></div>

Physical Damage Appraiser I

Join EMC Insurance and explore 2   exciting career opportunities. They're hiring for various roles with options for remote or on-site work. Apply today and become part of their innovative team.

EMC Insurance

About Company

Senior Data Engineer

Physical Damage Appraiser I