Data Engineer I

At EMC, you'll put your skills to good use as an important member of our team. You can count on gaining valuable experience while contributing to the company's success. EMC strives to hire and retain the best people by engaging, developing and rewarding employees. (This position can be performed remotely for candidates who reside in IA, NE, KS, MN, WI, IL, MO, TN, AR, LA, MS, AL, TX, OK, SD, ND. Candidates who exceed minimum qualifications may be considered for a higher level position.) Summary: Under direct supervision, develops, tests, and maintains pipeline architecture and infrastructure. Collaborates with team on the implementation and support of reporting and analytics infrastructure for internal business customers using AWS services. Partners with team members to develop data objects for business analytics using data modeling techniques. Participates in creating and maintaining documentation. Essential Functions: Partners with senior team members to develop and maintain ETL pipeline architecture using assigned tools and programming languages Assists in development and maintenance of automated ETL monitoring and alarming solutions using assigned languages and services. Collaborates with team on the implementation and support of reporting and analytics infrastructure for internal business customers using AWS services Develops, tests, and deploys code using internal software development toolsets, including the code for deploying infrastructure and solutions for secure data storage, ETL pipelines, data catalogs and data queries Maintains legacy data solutions to ensure business functionality until replaced with new technology Partners with team members to develop data objects for business analytics using data modeling techniques Develops and optimizes data warehouse and landing zone tables using best practices for data definition language (DDL), physical and logical tables, data partitioning, compression and parallelization Participates in creating and maintaining documentation related to the design of applications and interfaces to enterprise and third-party server based applications and other assigned work and systems in accordance with departmental and team standards, including disaster recovery and data center instructions Helps internal business customers develop, troubleshoot, and optimize SQL and ETL solutions to solve reporting, metrics, and analytics problems Education & Experience: Bachelor’s degree, preferably in a computer related field or equivalent relevant experience Prior experience working with unstructured datasets preferred Knowledge, Skills & Abilities: Knowledge of applicable programming languages such as Python preferred Basic knowledge of SQL and relational databases preferred Knowledge of AWS cloud services such as S3, Glue, Athena, Cloudwatch and Lambda preferred Knowledge of Informatica preferred Knowledge of Snowflake preferred Good analytical and problem-solving skills Ability to manipulate, process and extract value from large disconnected datasets Good verbal and written communication skills Strong attention to detail, organizational and multi-tasking skills, with the ability to adapt to changing priorities Ability to maintain confidentiality #DNP Our employment practices are in accord with the laws which 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. All of our locations are tobacco free including in company vehicles. To learn more about why you’re gonna love it here, watch the video below. Why should you choose to apply for a position at EMC? We can give you plenty of reasons why EMC is a great place to work: More than 105 years of financial strength and stability In the top 60 insurance organizations in the U.S. based on net written premium Named a five-star insurance carrier by Insurance Business America Two-time recipient of the Best Practices Award of Excellence from the Independent Agents & Brokers of America Multiple locations recognized as Top Workplaces based solely on team member feedback Corporate culture that engages and empowers team members to achieve their best Outstanding benefits with life, medical, dental, vision and prescription drug coverage Competitive paid time off plan and a full day of volunteer time off annually Financial incentives, including a 401(k) plan match, pension plan, OneEMC bonus plan and recognition and anniversary awards Professional development and growth opportunities, including tuition reimbursement Wellness initiatives to improve team member well-being and reduce health insurance costs Flexibility to dress for your day and opportunities for alternative work arrangements EMC complies with labor law requirements. View the federal and e-verify labor law posters. California Residents - California Consumer Privacy Notice: (EMCC) – California Consumer Privacy Notice (EMCNL) - California Consumer Privacy Notice