Business Analyst

Overview

On Site
$85000 - $100000 per annum
Full Time

Skills

Excel
VBA
PowerQuery
PowerBI
SQL
DAX

Job Details



Business Analyst


We are looking for someone with a passion for innovation who will seek, develop, and help implement strategic initiatives for improved efficiency and productivity. This person will help scale and enhance our systems and processes to effectively support our continued growth. From researching systems solutions to evaluating their impacts, the ideal candidate will be a detailed planner, expert communicator, and top-notch analyst. This person should be comfortable wearing many hats and wholly committed to rolling up their sleeves to do what it takes to ensure the success of multiple projects.



Objectives of this role



  • Drive awareness of requirements across business units and identify substandard systems processes through evaluation of real-time data

  • Leads discovery conversations with stakeholders to identify business needs and process gaps and designs systems prototypes that promote increased efficiency and productivity on multiple levels

  • Create and implement precise management plans for every project, with attention to transparent communication at all levels

  • Perform, evaluate, and communicate thorough quality assurance at every stage of systems development

  • Determine and develop user requirements for systems in production, to ensure maximum usability

  • Develop reporting and dashboards that help stakeholders make informed decisions and track KPI's

  • Develop documentation of customized programming and support their maintenance



Responsibilities



  • Partner with stakeholders across business units (ex: sales, finance, operations) to develop analyses and documentation in a collaborative way, communicating effectively and efficiently with production, managerial, and executive teams

  • Evaluate, analyze, and communicate systems requirements on a continuing basis, and maintain systems processes, including the delivery of monthly status reports to all appropriate parties

  • Author and update internal and external documentation, and formally initiate and deliver requirements and documentation

  • Conduct daily systems analytics to maximize effectiveness and troubleshoot problems

  • Establish meaningful and lasting relationships with developers, consultants and stakeholders for optimized systems integration

  • Develops and maintains a knowledge base of best practices for end users

  • Maintains security administration of ERP system and ensures users have proper access levels to the appropriate functionality

  • Manage tasks of 3rd party developers and consultants to ensure completion within timeline of overall projects

  • Work with stakeholders to develop reporting that helps them achieve departmental goals and drive strategic business decisions.

  • Perform tasks as needed to deliver project or task completion, such as but not limited to; engaging in data cleanup, updating access controls, system configuration, system administration, and developing custom fields.

  • Other duties as assigned



Required skills and qualifications



  • Five or more years of experience in analytics and systems development

  • High proficiency with SQL, ability to create views, custom fields, and build queries

  • Experience in generating process documentation and reports

  • Excellent communication skills, with an ability to translate data into actionable insights

  • Proven ability to manage multiple projects and user testing

  • High proficiency in Excel and PowerBI

  • Working knowledge of ERP systems

  • High attention to detail

  • Results Driven



Preferred skills and qualifications



  • Bachelor's degree (or equivalent) in information technology or computer science

  • Experience in a manufacturing environment

  • Experience with data visualization and creating dashboards

  • High proficiency in technical writing

  • Experience with Sage 300 or Accpac

  • Experience developing, interpreting, and maintaining Programming/Scripting using SQL, Python, XML, JSON, API, VBA




All qualified applicants will receive consideration for employment without regard to race, color, national origin, age, ancestry, religion, sex, sexual orientation, gender identity, gender expression, marital status, disability, medical condition, genetic information, pregnancy, or military or veteran status. We consider all qualified applicants, including those with criminal histories, in a manner consistent with state and local laws, including the City of Los Angeles' Fair Chance Initiative for Hiring Ordinance.

About Ledgent Technology