Business Systems Analyst

Itac Holdings, LLC Birmingham , AL 35202

Posted 2 months ago

ITAC is assisting a respected organization in their search for a Business System Analyst. The BSA will work closely with internal and external business teams to define requirements and needs for technical solutions.
The right candidate will have excellent interpersonal skills as well as strong technical and business acumen.
What youll be doing (duties of this position):

Responsible for determining system needs and translating these needs into business process, system requirements, and solution designs.
Ensures business requirements are comprehensive, cohesive, integrated, and contribute to departmental level efficiencies and improvements.
Identify business needs, determine solutions to business problems, and define solutions that include systems components, and process improvements.
Troubleshooting and maintenance of systems
Utilizes structured analysis to plan system modifications, workflows as well as determine necessary data structures, processing procedures, and appropriate output to meet user needs.
Spearhead integrations between vendor and internal systems.

What youll need to be considered (requirements):
2+ years of experience as a Technical Business Systems Analyst.
Experience with SQL - queries, functions, stored procedures, maintenance plans, reporting, etc.
Highly proficient with Excel, VBA preferred
Crystal Reports
BI tools: Power BI, Power Query, etc.
Understanding of relational databases and data warehouses.

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
BusinessSystems Analyst

Magna International Inc.

Posted 3 weeks ago

VIEW JOBS 2/5/2020 12:00:00 AM 2020-05-05T00:00 KAMTEK is a premier Tier 1, automotive manufacturing supplier that specializes in Class "A" Stamping, Assembly and High Pressure Die Casting that produces Body-side and Door Openings, Roofs, Floor Pans, Wheelhouses, Large Welded Assemblies, Doors, Fenders, Hoods, Lift-gates, Aluminum Shock Towers, and Aluminum Rear Rails. Our capabilities include the manufacturing of Class "A" Body Panels along with Medium/Large Stampings, Large Assemblies and Aluminum Stampings and Assemblies, and Aluminum High Pressure Vacuum Die Casting to our Original Equipment Manufacturers (OEMs) such as Mercedes Benz, Volkswagen, Kia, Hyundai, Nissan, BMW and Freightliner. As a local distributor and supplier, Kamtek' s market segmentation to Cosma International, (a division of MAGNA INTERNATIONAL) provides a "state-of-the-art" product that utilizes the most technologically advanced Pressing processes in order to maintain a competitive advantage to other OEM's within the market. Our company's culture of team spirit & mutual respect with a focus on fair treatment helps us to embrace our multi-cultural affiliation with Magna International, and supports our mission through process efficiency and competitive product pricing. Furthermore, the culture at Kamtek focuses on Job Security, with employees being given the opportunity for continuous training, advancement within the skill/trade, and potential for growth within our safe work environment. We offer Employee Equity and Profit Participation programs which increase our employees' ownership within the company. Kamtek, part of Cosma International and a division of Magna International, represents the most diversified automotive supplier in the world. We design, develop and manufacture automotive systems, assemblies, modules and components, and engineer and assemble complete vehicles, primarily for sale to original equipment manufacturers (OEMs) of cars and light trucks in our three geographic segments - North America, Europe, and the Rest of the World (primarily Asia, South America and Africa). Our capabilities include the design, engineering, testing and manufacture of automotive interior systems; seating systems; closure systems; metal body & chassis systems; mirror systems; exterior systems; roof systems; electronic systems; powertrain systems as well as complete vehicle engineering and assembly. We are a leading global automotive supplier with 347 manufacturing operations and 92 product development, engineering and sales centres in 28 countries. We have over 168,000 employees focused on delivering superior value to our customers through innovative processes and World Class Manufacturing. PURPOSE OF POSITION: The Business Analyst role is to ensure current Business Information Systems are aligning with Business requirements, promote all systems utilization, analyze and maintain system documentation, and training information. Become the catalyst for change to keep all systems up to date and informed of best business practices. Sr. Level Position requires advanced technical and functional experience in ERP and EDI Systems, Security administration and knowledge in data integrate RESPONSIBILITY AND AUTHORITY: Responsible for developing and/or supervising development of applications and reports that integrate with CMS and providing custom functions for the Systems Analyst. Responsible for providing CMS user support to all departments. Responsible for managing and working with outside consultants to implement CMS modules, custom reporting, EDI setups, and other external applications linked to CMS. Responsible for troubleshooting and at times reconfiguring and upgrading CMS for changing business needs. Responsible for supporting Cosma unified effort between divisions as it relates to CMS and CMS development integration. Responsible for timely and accurate data collection, effective reporting and integration between data collection system(s), reporting system(s), and ERP system. ESSENTIAL FUNCTIONS OF THE POSITIONS: 1) Follow and enforce all plant safety rules and policies. 2) Understand and promote Magna's philosophies (Magna Operational Principles, Corporate Constitution and Employee's Charter). 3) Assists in installation, configuration and maintenance of AS/400 computer hardware, software, networked devices and AS/400 client-access software, journaling, mirroring software, etc. 4) Assists fellow System Administrators in daily Windows-based server administration as it pertains to AS400 integration. 5) Assists in the daily administration of IBM AS/400 computer hardware and software 6) Loads and tests operating system and application software releases, and fixes in both test, stage, and productions environments and loads application and software patches; runs performance and file tuning utilities 7) For major system changes, incumbent defines need, weighs options, and proposes solutions. Outlined system changes can be made based on own knowledge and experience. It will occasionally be necessary to take quick actions, such as implementing HA during a major system in an emergency that has simultaneous major impact on the functioning of Resort Operations. 8) Documents and implements applications specific security groups and classes. Cross trains other team members in AS/400 administrative skills. 9) Ensures that software licenses, certifications, and subscriptions are properly renewed and do not prematurely expire 10) Ensures that all systems currently in use are backed-up and can be restored within SLO\SLA requirements; 11) Ensures that no changes are made to any system without an approved change request work order; 12) Ensures that policies, procedures, diagrams, and other technical documentation is kept current and accessible; 13) Follows PCI-DSS, SOX, IT Security guidelines to ensure all systems are kept in compliance; 14) Create new/maintain existing EDI mapping and perform regular EDI routine jobs. 15) Develop/Recommend process and methodologies to ensure quality deliverables that meet business needs 16) Maintain Guidelines, training Materials and Documentation for Business Process 17) Manage implementation of ERP modules working hand in hand with various team members across departments 18) Verify accuracy of data from shop floor together with Controls Engineer 19) Work with team members across departments to find business needs and ensure solutions are provided which are in-line with department budgets, Magna/Cosma IT requirements, and abide by any and all legislative requirements 20) Work with customers to ensure data communication needs are met 21) Work with suppliers to streamline receiving processes and communication needs for inventory improvements 22) Facilitates continues improvement projects 23) Continual Improve ERP utilization to ensure a constant increase and investment returns 24) Establish/Perform/Maintain System maintenance activities to ensure the service level expectations for functionality, performance, security and control are fulfilled 25) Acts as first level Support for ERP System Security Administration Activities 26) Acts as first level support for EDI activities 27) Promotes good housekeeping (5S) 28) Provide First/Second Level Computer Desktop Support to Drive Associates 29) 30) Subject matter expert for custom applications based on Kepware and OPC servers. 31) Subject matter expert for custom shop floor applications, label printing, inventory/production reporting. 32) Design, configure, and maintain all label printing application 33) Design, configure, and maintain all inventory reporting applications 34) Design, configure, and maintain all production reporting applications 35) Perform other duties as required. POSITION REQUIREMENTS SKILL (Ability to do the job) * Must possess good interpersonal communication skills, including the ability to communicate technical information to a non-technical audience * Must have an understanding business processes from beginning to end * Must possess strong problem-solving abilities as well as good analytical skills * Must have a background in accounting, purchasing, and materials management * Must possess strong interpersonal skills in order to deal with end users on a daily basis * Must have experience configuring and upgrading ERP systems * Ability to write code in order to retrieve, manipulate, store and report data * Must have demonstrated knowledge of EDI systems * Must possess advanced technical skills, including a strong knowledge of ISeries (IBM AS/400), IBM Power HA, SQL Server, EDI and DB2 PHYSICAL DEMANDS Some of the physical demands for this position include the ability to lift 50 pounds, standing and sitting for prolonged periods of time, and occasional stooping and bending. EQUIPMENT / TOOLS USED Some of the equipment and tools used is a computer with .NET development tools, SQL tools, Kepware development tools, Zebra Programming Language. KNOWLEDGE EDUCATION: High School Diploma or GED required; Bachelor's Degree in Computer Science and/or Information Systems preferred, or equivalent experience. TECHNICAL TRAINING: Kepware \ OPC integration, SQL Server, Microsoft .NET, CMS integration training, ZPL,.NET, Server 2008 R2, Server 2012 R2,ISeries\AS400, DB2 and Microsoft Office OTHER: Computer skills: proficient in Microsoft Office and CMS applications Troubleshooting skills and the ability to manage multiple priorities highly desired. WORK EXPERIENCE WHAT TYPES? .NET development experience, including SQL database integration expertise, Project Management, and CMS\ERP implementation HOW MUCH? Minimum of 3 year * 3+ years experience in the OS support of iSeries (AS400). * 3+ years experience in an Enterprise class environment administering the IBM iSeries AS400 with multiple LPARS/partitions including adds, moves, changes, code migrations, maintaining sub-systems, scheduled jobs, performing upgrades, applying patches, and ensuring overall system health. * 3+ years experience with EDI documents and hands-on mapping experience a plus * Experience with EDI standard formats (ANSI X12) and communication standards + protocols (such as AS2, FTP, Vans, etc.). Knowing OpenText TrustedLink software a plus. WHAT ADDITIONAL SKILLS OR ABILITIES WOULD BE HELPFUL FOR THE JOB? * CMS * SQL * SQL Reporting Services * .NET * ISeries * Knowledge of the automotive manufacturing industry Role Summary Key Responsibilities Key Qualifications/Requirements Additional Information Magna International Inc. Birmingham AL

Business Systems Analyst

Itac Holdings, LLC