IT Business Specialist

3 weeks ago


Coppell, United States Barcel USA Full time
Job Details

Job Location
BLU National Offices - Coppell, TX

Position Type
Full Time

Job Shift
Day

Job Category
Information Technology

Description

Barcel USA is looking for a IT Business Specialist to join our growing technology team. The candidate must have professional experience in databases, building complex reports, and making reporting recommendations. This position will serve as the commercial data and system expert. Must be able to bridge data requirements with system requirements. Responsible for supporting commercial systems (40%), validating data (20%), building/maintaining reports (15%), defining database requirements (15%), and data automation processes (10%).

Duties and Responsibilities:
•Building complex databases reports and queries.
Building queries to export data between systems, generate reports and validation to collaborate with different projects.
Build reference queries for data extraction for exports and generate automatic reports from different data sources and ingest to various systems.
•Serve as the commercial data and systems subject matter expert.
Validate Data in Order Management and Demand Management modules against reporting systems. Identify and proactively address variances in data.
Validate and align Catalogs in the ERP system and downstream systems.
Fix and create rules on the forecast.
Analyze and resolve Forecast issues with regards to rules and error reports.
Create and maintain a data system monitoring set of dashboards to give visibility to data delivery among various information pipelines in a timely manner.
•Bridge data requirements with system requirements.
Detection, follow up and documentation of new functional requirements definitions for projects and systems.
Research and define concepts with stake holders, commercial managers, accounting, procurement, supply chain.
Validate final expectations with stake holders and system users for different data models (Sales, Order Logistics, Customer Service, Accounting, Supply Chain, etc.)
Mapping and validation of items numbers, items hierarchy, stores attributes, customer hierarchy, ship to locations, bill to locations, and data attributes across different data bases models.
Validation and maintenance of the Forecast, Warehouse Sales, Customer Sales, Scan Sale Data measures, KPI, and metrics.
Manage incident tickets to correct systems with internal and 3rd party systems.
•Database normalization and process automation.
Establish the dimensions and definitions of new attributes.
•Specify and create process documentation.
Creation and support of VBA Macros and other automation tools for Sales Orders templates, logistics processes, and mappings.
Normalizing data attributes for store types, account level, and other elements via email robots.
Store saturation implementation, analysis and testing between IRI, Spectra, Barcel Master Store List, Scan Sell and Customer Sales Model.
Mapping stores using proximity algorithms.
•Customer support and collaborations.
Training support for Demand Planning, Supply Chain teams and other business system users.
Assist business team members with macro configurations.
Working directly with the external and internal implementation teams to facilitate support and project communication through discovery, information sharing, follow up coordination, and execution of action items.
•High Technical and Business duties.
Automate reports with Power Platform (Canvas, Power Automate, Power BI.)
Lead integration between systems (Salesforce, CRM, Salsify, Oracle, Azure).
Generate SQL script for analysis and data extraction.
Optimize process (OL, OM, DM, Sellin).
Bitam, Order Management, Salesforce, CRM, MM, DM, OTBI, OACS, ARKON, Salsify.
DM MAPE analysis, forecast metrics (booking, shipping, adjusted and seasonality metrics), application of the Bayesian statistical methods and data conversion improvements.
Refresh data history in all the data models (Sellin and Forecast Cube, Power BI, trough SoftLayer).
Run procedures to recalculate metrics.
Develop VBA customs macros to automatize loading process or data feed.
Bilingual translations between teams on Mexico and USA.
•Any other tasks and responsibilities assigned by manager.

Qualifications

•Bachelor's Degree in related software or technical field or comparable education and/or experience
•Understanding the data lifecycle and ETL processes as it relates to data management
•Proven ability to organize and structure business and technical requirements
•Proven experience in building reports with database languages
•Ability to work with limited supervision showing creativity, innovation, motivation initiative, and professionalism
•Excellent verbal and written communication skills and the ability to interact professionally with diverse groups, executives, managers, and subject matter experts
•Bi-Lingual Spanish/English highly preferred.
  • Business Analyst

    2 weeks ago


    Coppell, United States Talascend Full time

    Talascend is currently seeking a Business Analyst for a contract opportunity located in Coppell, TX. Schedule: Hybrid, 4 days in office, 1 remote OVERVIEW: The main function of a business operations specialist is to maintain vendor relationships, acting as a business analyst for non-IT projects or filling organizational roles above an administrative level,...


  • Coppell, Texas, United States Stericycle Full time

    ***Starting pay: $18/hr + OT**About Us:Stericycle is a U.S. based business-to-business services company and leading provider of compliance-based solutions that protects people and brands, promotes health and well-being, and safeguards the environment. Since our founding over 30 years ago, we have grown from a small start-up in medical waste management into a...


  • Coppell, United States Transcend Solutions, LLC Full time

    Logistics Specialist - 12700 Length of Assignment: 12+ Month Location: Coppell, TX Schedule: Hybrid, 4 days onsite, 1 day WFH Must be comfortable with occasional overtime and weekend work Summary: The main function of a logistics specialist is to coordinate and expedite the flow of work and materials within or between departments of an establishment...


  • Coppell, United States PulteGroup Full time

    Works as an integrated, collaborative member of the L&D team to deliver training for new hire, MB 1, business systems and applications, Internet/ Intranet, Customer Service, and any additional projects and/or programs as assigned. Develops and modifi Mortgage, Specialist, Development, Business Systems, Training, Internet, Construction, Business Services


  • Coppell, United States Staffmark Full time

    Staffmark Workforce Solutions offers this exciting contract opportunity at a global leader in electronics, mobile devices, and appliances located in Coppell, TX. Logistics Specialist Position Summary The main function of a logistics specialist is to coordinate and expedite the flow of work and materials within or between departments of an establishment...


  • Coppell, United States Info Image Full time

    Job DescriptionJob DescriptionNotice to applicants:This is a non-sponsorship opportunity; employer will not transfer or sponsor applicants for U.S. work authorizations.Applicants are required to be legally authorized to work in the United States on a full-time basis immediately.Candidates must be able to commute into an office and reside locally.Direct Hires...


  • Coppell, United States Transcend Solutions Full time

    Logistics Specialist - 12700Length of Assignment: 12+ MonthLocation: Coppell, TXSchedule: Hybrid, 4 days onsite, 1 day WFH – Must be comfortable with occasional overtime and weekend workSummary:The main function of a logistics specialist is to coordinate and expedite the flow of work and materials within or between departments of an establishment according...


  • Coppell, United States Yooz Full time

    If you’re intrigued by innovation, love the art of delivering excellence to customers, and are inspired by a work hard / play hard team environment – keep on reading!Software is developed to solve business challenges. While technology providers have rallied to bring more efficiency to most areas of a business, via software, Accounts Payable (AP)...


  • Coppell, United States Yooz Full time

    If you’re intrigued by innovation, love the art of delivering excellence to customers, and are inspired by a work hard / play hard team environment – keep on reading!Software is developed to solve business challenges. While technology providers have rallied to bring more efficiency to most areas of a business, via software, Accounts Payable (AP)...


  • Coppell, United States The Columbia Safety & Supply Family of Companies Full time

    Sales Support SpecialistDepartment: Sales Employment Type: Full Time Location: Coppell, Texas DescriptionTHE COLUMBIA SAFETY FAMILY OF COMPANIES IS HIRING SALES SUPPORT SPECIALISTS! The Columbia Safety team serves clients in the central Missouri area who are looking for fall protection, climbing gear, rescue equipment, tools, footwear, apparel, and personal...


  • Coppell, United States IBM Full time

    Introduction A Technology Sales Specialist role (what we internally call a, 'Brand Sales Specialist') within Automation means working for a leader in AI-Powered products. Envision helping clients create a world with less repetitive work and more innovative decisions. Less unplanned downtime and more proactive insight. And less waiting on systems... So that...


  • Coppell, United States Staffmark Group Full time

    Staffmark Workforce Solutions offers this exciting contract opportunity at a global leader in electronics, mobile devices, and appliances located in Coppell, TX. Logistics Specialist Position Summary The main function of a logistics specialist is to coordinate and expedite the flow of work and materials within or between departments of an establishment...


  • Coppell, United States Aditi Consulting Full time

    Summary: The main function of a logistics specialist is to coordinate and expedite the flow of work and materials within or between departments of an establishment according to production schedule. A typical logistics specialist is responsible for reviewing and distributing production, work and shipment schedules and compiling reports on inventory levels,...


  • Coppell, United States Aditi Consulting Full time

    Summary: The main function of a logistics specialist is to coordinate and expedite the flow of work and materials within or between departments of an establishment according to production schedule. A typical logistics specialist is responsible for reviewing and distributing production, work and shipment schedules and compiling reports on inventory levels,...


  • Coppell, United States Advatix Full time

    Inventory Control Specialist XPDEL is looking for an Inventory Control Specialist (ICS) to join our team. This position works on the warehouse floor, processing orders by picking and filling boxes/containers. They will send and accept shipments while keeping the warehouse clean and safe. As an (ICS), you will play an essential role in monitoring and...


  • Coppell, United States Panther IT Full time

    Integrations/Microservices Architect Job Description Job Title: Integrations/Microservices ArchitectJob Overview:This role will document and architect solutions for integrations with existing systems as well as design new microservices using industry best practices. This will include handling new and existing integration with downstream systems, overall...


  • Coppell, United States Advatix, Inc. Full time

    Job DescriptionJob DescriptionInventory Control Specialist XPDEL is looking for an Inventory Control Specialist (ICS) to join our team. This position works on the warehouse floor, processing orders by picking and filling boxes/containers. They will send and accept shipments while keeping the warehouse clean and safe. As an (ICS), you will play an essential...


  • Coppell, United States Advatix Full time

    Inventory Control Specialist  XPDEL is looking for an Inventory Control Specialist (ICS) to join our team. This position works on the warehouse floor, processing orders by picking and filling boxes/containers. They will send and accept shipments while keeping the warehouse clean and safe. As an (ICS), you will play an essential role in monitoring and...


  • Coppell, Texas, United States Insperity Full time

    Insperity provides the most comprehensive suite of scalable HR solutions available in the marketplace with an optimal blend of premium HR service and technology. With more than 90 locations throughout the U.S., Insperity is currently making a difference for thousands of businesses and communities nationwide.Behind our success is the unshakeable belief in the...


  • Coppell, United States Fulgent Genetics, Inc. Full time

    Job Details Level: Experienced Job Location: IDX Coppell TX Site - Coppell, TX Position Type: Full Time Education Level: 2 Year Degree Salary Range: Undisclosed Description Inform Diagnostics is a leading national pathology laboratory, headquartered in Irving, Texas, with additional state-of-the-art laboratories in Boston, New York City, and Phoenix....