We invite you to be part of our team of trailblazers dedicated to helping people discover and enjoy the outside. Come join us. Because on the inside we're all outsiders. And if it's outside, we're all in.Position purpose:If you enjoy working with data and databases, are very experienced with SQL (DB2 a plus) and associated other tools, this could be the opportunity you are looking for. Enterprise Data Warehouse DB2 LUW is home to over 30tB of data. This team is skilled with how we store and retrieve our data and services about 600+ people in many capacities. In this role, you will become the data expert for a variety of data subjects and types, help determine how upstream changes might impact our processing, and collaborate with other IS and business teams for changes, modifications, and testing. You will be involved in project work, security standards, supportexisting processing and perform a significant amount of analysis. Understanding EDW processing, various types of data storage and retrieval, and how to align requirements with databases are all important. You will design, develop, configure, test, debug, and document small to complex work that meets requirements. Projects will include interfacing with many technologies and methods, evaluating and analyzing business requirements for new applications and application changes.The ability to work with a team of diverse individuals is critical.We offer:Extraordinary employee experienceFlexible scheduleWorking from homeFitness subsidyEducation subsidy3 paid days to enjoy outdoor activities5 Personal/sick daysL.L.Bean employee discountAsociación solidaristaLife and medical insuranceCompany doctorAbout you:Education Level: 4-Year Bachelors Degree in Computer ScienceYears of Experience in the field:5+English level: C1 Skills and Qualifications:Required to apply:Complex SQL: Able to analyze, modify, create, and test complex SQL statements, along with general understanding and use of complex functions.LINUX: Familiar with environment to ensure effectiveness with DB2.DB2 LUW (DPF): A minimum of 3+ years of platform experience (a big plus).Build respect and credibility within their team, IS and the business.Ability to influence others at multiple levels within LL Bean and with vendors.Can effectively communicate with all levels of the business and IT from end-users and developers to managers.Highly collaborative. Effectively works with business and IS staff in the adoption, utilization, and support of software.Excellent English language skills and comprehension.Ability to see the big picture and understand how this role impacts the broader IS department and business. Understands the Company's and Business Unit's goals and objectives.Continually looks within and beyond their job, anticipating business needs and opportunities.Works within tight technical and business constraints.System integration skills: installation, deployment, customization, and integration.Must have experience in Linux, DB2, advanced SQL coding.Experienced/familiar with Control-M, MS SQL Server (a plus), Kornshell, Git, Perl, Toad for DB2, Toad for SQL Server, PuTTY.Experienced with testing at all levels (unit, integration, system, performance), testing tools (including automated testing) and debugging tools.Experienced working with structured data of many subject areas, including sensitive financial data.Experience with data strategies is a plus.About the role:Emphasis on design. High-level analytical skills required to translate business requirements into possible solutions.Work independently and collaboratively with team; provide regular updates to leader.Prepare detailed specifications and/or mapping documents to ensure business rules are captured. Manage data within different environments.Understand how to address performance issues in code.Support Production data updates on team rotation.Work with business area customers, other IT teams, and vendors to identify business requirements, test strategies, and test execution.Participate in project planning and development or assume responsibility for a project of limited scope which may include technical leadership.Provide options for and estimates of possible solutions.May be responsible for the completion of small projects or project phases, depending on the level of complexity.May review training strategy, materials, and Standard Operating Procedures.Collaborate with technical partners to ensure Service Levels are met.Provide technical expertise for project and baseline support teams.Provide On Call support for both daytime and after-hours periods.Adhere to security standards in support of PCI compliance.Adhere to development standards and contribute to the enhancement of such standards.If you care about the outdoors, joining L.L.Bean is a great way to feel good about what you do. Our benefits package makes a good thing even better, with programs and perks designed to support your health and financial goals. Plus, maintaining a healthy work-life balance and re-charging outside are all part of the plan. Because, when it comes to the outside—we're all in. Visit to learn more.Being outside brings out the best in us, no matter where we come from or what we believe. At L.L.Bean, we value individual differences and encourage our co-workers to be themselves – because the uniqueness of each individual makes L.L.Bean better.
