Sr. Associate Data Engineer - ETL Developer

What Is the Opportunity? Travelers Data Engineering team constructs pipelines that contextualize and provide easy access to data by the entire enterprise. As a Senior Associate Data Engineer you will help guide growth and transformation of our analytics landscape. You will leverage your ability to design, build and deploy data solutions that capture, explore, transform, and utilize data to support Artificial Intelligence, Machine Learning and business intelligence/insights. What Will You Do? Build and operationalize data solutions, correct problems, apply transformations, and recommend data cleansing/quality solutions. Participate in the design of data solutions. Analyze sources to determine value and recommend data to include in analytical processes. Incorporate core data management competencies including data governance, data security and data quality. Partner and collaborate with team and business users to support delivery and educate end users on data products/analytic environment. Perform data and system analysis, assessment and resolution for defects and incidents of moderate complexity and correct as appropriate. Test data movement, transformation code, and data components. Perform other duties as assigned. What Will Our Ideal Candidate Have? Bachelor’s Degree in STEM related field or equivalent Five years of related experience Developing knowledge of tools, techniques, and manipulation including Cloud platforms, programming languages and software engineering practices. Knowledge of data concepts (Data Warehouse, Data Lake, Data Model, DB Design, Data Mapping) Experience with: ETL tools, primarily Talend or similar (Ab Initio, Informatica) SQL (medium to complex queries) Database (SQL Server, Teradata, or similar) Knowledge of: AWS (s3, IAM, Glue, SNS, SQS, VPC, Athena, EC2, etc.), Process Orchestration Tools (similar to: AutoSys, Control-M, Step Functions ) What is a Must Have? Bachelor’s degree or equivalent training with data tools, techniques, and manipulation. Two years of data engineering or equivalent experience. What Is in It for You? Health Insurance: Employees and their eligible family members – including spouses, domestic partners, and children – are eligible for coverage from the first day of employment. Retirement: Travelers matches your 401(k) contributions dollar-for-dollar up to your first 5% of eligible pay, subject to an annual maximum. If you have student loan debt, you can enroll in the Paying it Forward Savings Program. When you make a payment toward your student loan, Travelers will make an annual contribution into your 401(k) account. You are also eligible for a Pension Plan that is 100% funded by Travelers. Paid Time Off: Start your career at Travelers with a minimum of 20 days Paid Time Off annually, plus nine paid company Holidays. Wellness Program: The Travelers wellness program is comprised of tools and resources that empower you to achieve your wellness goals. In addition, our Life Balance program provides access to professional counseling services, life coaching and other resources to support your daily life needs. Through Life Balance, you’re eligible for five free counseling sessions with a licensed therapist. Volunteer Encouragement: We have a deep commitment to the communities we serve and encourage our employees to get involved. Travelers has a Matching Gift and Volunteer Rewards program that enables you to give back to the charity of your choice. Employment Practices Travelers is an equal opportunity employer. We believe that we can deliver the very best products and services when our workforce reflects the diverse customers and communities we serve. We are committed to recruiting, retaining and developing the diverse talent of all of our employees and fostering an inclusive workplace, where we celebrate differences, promote belonging, and work together to deliver extraordinary results. If you are a candidate and have specific questions regarding the physical requirements of this role, please send us an email so we may assist you. Travelers reserves the right to fill this position at a level above or below the level included in this posting. To learn more about our comprehensive benefit programs please visit #J-18808-Ljbffr