Data Analyst III at LanceSoft Wichita, KS

Downtown Boulder Partnership; Wichita (KS); On-site; USD 31,822 - 45,323; Part time

Job summary

Downtown Boulder Partnership in Wichita, KS is seeking a Data Analyst III to extract and analyze data from SAP S/4HANA and Excel. This role includes developing macros, conducting data analyses, and collaborating with cross-functional teams.

The ideal candidate will have a Bachelor's degree in Information Technologies and 1-3 years of experience in data migration, with a strong proficiency in Excel and data cleansing skills.

Qualifications

• 1-3 years of experience in data migration.
• Proficiency in advanced Excel features.
• Familiarity with AI or natural language processing tools.

Responsibilities

• Extract data from SAP S/4HANA and export to Excel.
• Create and manage Excel macros for data analysis.
• Analyze technical and business challenges.

Skills

Data extraction from SAP S/4HANA

Excel macros and pivot tables

Data cleansing and deduplication

Collaborative skills

Analytical and problem-solving

Education

Bachelor's degree in Information Technologies or related field

Tools

SAP S/4HANA

Excel

Job description

Title: Data Analyst III

Location: Wichita KS

Duration: 30 - 45 days.

Shift: 1st Shift

Pay Rate: $28.00.00/Hour

Job Duties

• Extract data from SAP S/4HANA and export to Excel for further processing.
• Create and manage Excel macros and pivot tables to sort, compare, and analyze data outputs.
• Gather datasets from Excel and filter for duplications using the description fields.
• Utilize AI programs to sort and filter outputs based on similar descriptions using natural language interpretation.
• Contribute to the development and requirement definition of technologies, products, systems, and services.
• Analyze technical and business challenges, develop hypotheses, evaluate alternatives, and recommend solutions.
• Set up and configure simulation, testing, and prototyping environments.
• Program and develop specialized software tools used within the team or organization.
• Conduct simulations or data analyses and validate results for accuracy and effectiveness.
• Document and report results using appropriate data visualization methods.
• Collaborate with customers, business experts, product management, and other stakeholders.
• Provide guidance and assistance to less experienced colleagues as needed.
• Support continuous improvement by identifying optimization opportunities in tools and processes.

Qualifications

• Bachelor's degree in Information Technologies, Database Management, or a related field required.
• 1-3 years of experience in data migration.
• Hands-on experience with SAP S/4HANA, particularly with the following modules:
  • MM (Materials Management) - Procurement
  • LE (Logistics Execution)
• Experience in Master Data Migration processes.
• Proficiency in Excel, including advanced features like macros and pivot tables.
• Experience with data cleansing, deduplication, and standardization.
• Familiarity with AI or natural language processing tools for description matching is a plus.
• Strong analytical, problem‑solving, and communication skills.
• Ability to work independently and in collaboration with cross‑functional teams.
• Entry‑level professionals with foundational knowledge in technical fields are welcome.
• Certification in specific SAP modules or data migration tools is a plus.

© LanceSoft