Financial Data Engineer

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 is a remote position that is eligible to work anywhere in the United States** Essential Functions: Develops, tests, and maintains pipeline architecture and infrastructure: Develops and maintains moderately complex automated ETL pipeline architecture using assigned tools and programming languages Develops and maintains moderately complex automated ETL monitoring and alarming solutions using assigned languages and services Implements and supports 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 Data analysis: Leads small projects or supports larger initiatives as part of a team Partners with users to understand business requirements Collaborates with team on conceptualizing and developing new data solutions to meet the business requirements Researches, performs analysis and proposes effective solutions related to systems development and enhancements Reviews potential adjustments or modifications for impacts on other programs Data modeling: Develops 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 Education & Experience: Bachelor’s degree, preferably in a computer related field or equivalent relevant experience Two years of data integration development experience, or related experience Knowledge, Skills & Abilities: Knowledge of Informatica preferred Knowledge of Snowflake preferred Good SQL knowledge and experience working with relational databases Good analytic skills to work with unstructured datasets Good knowledge of applicable programming languages Working knowledge of AWS cloud services such as S3, Glue, Athena, Cloudwatch and Lambda preferred Strong ability to build processes supporting data transformation, data structures, metadata, dependency and workload management Good ability to manipulate, process and extract value from large disconnected datasets Strong verbal and written communication skills Strong attention to detail, organizational and multi-tasking skills required with the ability to adapt to changing priorities Ability to maintain confidentiality Per the Colorado Equal Pay for Equal Work Act, the hiring range for this position for Colorado-based team members is $74,059 - $95,108 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

Salary : $74,059 - $95,108