Job Description:
The Data Conversion Analyst has the primary responsibility of analyzing the legacy Warehouse Management System (WMS) data source and mapping conversion data into the target WMS to support a successful WMS conversion. The data mining, mapping and conversion process will include transformation, data staging, validation and loading processes primarily utilizing SQL SSIS/SSMS/Stored Procedures and other utilities as needed. The Data Conversion Analyst will join an existing data conversion team and collaborate with business stakeholders and cross functional teams to ensure a successful, on-time WMS conversion.
As a company, Lineage Logistics leverages state-of-the-art technology to meet our customer’s needs, assist in our international growth, and create an infrastructure that enables Lineage to lead the industry.
As the ideal candidate for this position, you will exhibit the technical expertise, business acumen and flexibility required to successfully work with all levels of Lineage’s organization.
ESSENTIAL JOB FUNCTIONS:
- Mine source data from legacy WMS including master, inventory, and transactional data.
- Map and transform legacy WMS source data for use within target WMS and associated databases.
- Partner with other team members to validate data transformation and load into target WMS system
- Identifies data sources, provides data flow diagrams, and documents source to target mapping and process.
- Collaborate with the WMS conversion team to recommend enhanced data models for data collection, transformation, validation, and ingestion processes.
- Analyze existing data transformation and validation tools and identify opportunities for increased efficiency and standardization
- Assist the WMS conversion team to meet project deliverables and deadlines
- Communicate status and obstacles to Project Manager and overall WMS conversion team
- Collaborate within a diverse team of talent and personalities to achieve a successful WMS conversion
Requirements:
- 5+ years of data analysis and transformation experience
- 5+ years importing/transforming/exporting data between different sources using SSIS/SSMS and Stored Procedures.
- Deep understanding of relational database design concepts, SSIS and SQL programming
- Requires strong analytical, conceptual, and problem-solving abilities.
- Experience with JIRA and Confluence.
- Strong written and verbal communication skills including the ability to communicate with both technical and non-technical customers.
- Proven ability to meet deadlines.
Competencies:
- Business Acumen (Analyzing Information, Demonstrates Global Perspective, Making Decisions, Problem Solving, Strategic Thinking, Using Sound Judgment)
- Conviction (Adapting to Change, Resolving Conflicts, Showing Creativity)
- Personal Integrity (Behaving with Integrity, Sensitivity to Others)
- Results Driven (Prioritizing, Taking Initiative, Taking Ownership)
Education and/or Experience:
- Bachelor’s degree in Computer Science or equivalent experience in the related field.
Preferred Skills:
- Previous experience with system conversion projects
- Supply Chain or Logistics industry experience strongly preferred
- Experience with JavaScript, React JS, CSS and Bitbucket.
Why Lineage?
This is an excellent position to begin your career path within Lineage! Success in this role enables greater responsibilities and promotions! A career at Lineage starts with learning about our business and how each team member plays a part each and every day to satisfy our customers’ requirements. Beyond that, you’ll help us grow and learn on our journey to be the very best employer in our industry. We’ll ask you for your opinion and ensure we do our part to keep you developing and engaged as we grow our business. Working at Lineage is energizing and enjoyable. We value respect and care about our team members.
Lineage is an Equal Employment Opportunity Employer and is committed to compliance with all federal, state, and local laws that prohibit workplace discrimination and unlawful harassment and retaliation. Lineage will not discriminate against any applicant on the basis of race, color, age, national origin, religion, physical or mental disability or any other protected status under federal, state and local law.
Benefits
Lineage provides safe, stable, reliable work environments, medical, dental, and basic life and disability insurance benefits, 401k retirement plan, paid time off, annual bonus eligibility, and a minimum of 7 holidays throughout the calendar year.
