Vba Software Developer
December 23 2024
Industries
Consulting services
Categories Data Business Analyst,
Toronto, ON • Full time
Job Description
- (Internal Title: Business System Configuration / Development III)
- Develop full stack VBA software and workflow automation for the Visio railway architecture diagrams
- Develop backend VBA functions for data import/export to Visio diagrams
- Programmatically generate, configure and manage viewpoints for the architecture diagrams
- Collaborate with cross-functional teams to define application features, characteristics, and the GUI
- Develop plugins for the Visio diagrams for integration into corporate applications i.e. Power BI
- Develop Web based access to the architecture diagrams using MS API
- Integrate, develop, and configure the Project Management Information System tools including Primavera Unifier, P6, EcoSys, and Oracle EBS under the supervision of the manager
- Plan for and execute appropriate means and methods in Business Systems Configuration or Development to complete the assigned tasks and duties on medium-sized projects or elements on larger projects or programs from inception through to completion
- Provide timely and daily robust end-user support including logging bugs and errors, and follow up until they are resolved
- Responsible for creating updated content and bug fixes for software applications
- Conduct business analysis at varying levels of detail, appropriate to the project and phases of the project
- Facilitate and document design decisions
- Develop key project deliverables and artifacts such as business requirements, functional design documents, fit or gap analyses, proposed data models, etc.
- Collaborate with the data architecture and technical development team to ensure the creation of an efficient technical solution that meets all functional business needs
- Document the business requirements, perform the requirement elicitation, and work with the development team to identify alternative technology and solutions for implementation
- Perform product testing to ensure quality is maintained and that acceptance criteria of the provided solution are met
- Report functional or operational gaps in the self-service products through competitive analysis, monitoring industry trends, and prioritizing customer requests
- Manage integration solutions that fit the Business Users' specific requirements
- Responsible for day-to-day support and proactive monitoring of assigned applications and interfaces
- Ensure standard Systems Development Life Cycle (SDLC) process is applied to develop EPMIS applications and solutions in response to business requirements
- Liaise with Solution Architects on architecture design and SME on the integration efforts to other systems
- Prepare technical documentation for all development items and support analysis, development, and testing for enterprise solutions
- Review and analyze software programs to gain a detailed understanding of the impact of implementation on underlying business functions
- Follow established Information Technology Infrastructure Library (ITIL) processes in troubleshooting, fixing, configuring, upgrading, testing, implementing, or deploying fixes, patches, or upgrades to enterprise applications
- Evaluate project effectiveness in Business Systems Configuration or Development by consulting with applicable staff
Onsite at Client site: this role's work location is onsite with our client and partners to enable delivery and cultivate our client relationships.
Qualifications
- Minimum of 6 years of experience in PMIS Application, Configuration or Development works
- Minimum of 6 years of experience in Project Management and Business System Development with experience supporting EPC projects or management portfolios
- Minimum of 4 years of relevant experience in VBA software development
- Bachelor's degree in Business Administration, Project Management, Software Engineering, Business Analyst or equivalent
- Holding recognized Project Management certification (PMP)
BONUS POINTS IF YOU HAVE:
- SW handlers for data queries management, filtering, sorting for import/export functions in Visio
- Ability to perform VB statistical analyses
- Should be comfortable working as part of a larger team of designers
- Effective presentation skills to explain the VBA program functionality and to guide users on how to use it
- Demonstrated experience in Data and Digital Management of large capital programs
- Competent in managing multiple concurrent system implementation or integration projects
- In-depth knowledge of prevailing consulting means and methods in Business Systems Configuration or Development
- Expert understanding and experience in Project Costing, Scheduling, Earned Value Performance Metrics, and Construction or Contract Administration
- Fundamental skills in Project Management and Construction, Project Controls, and Contractor Management processes and application
- Advanced skills in Microsoft Office
- Proficient in Primavera Unifier, Primavera P6, and EcoSys
- Thorough understanding of programming skills like DotNet, SQL, development, PL or SQL Packages, Java, and modern languages like Python, R, Web services, REST, SOAP, JSON, and PIF
- Proven capability in leading, coaching, and mentoring a team of technical Business Systems professionals
- Adept functional acumen to support applicable solutions and goals while addressing and maintaining industry best practices
- Ability to arrange priorities and escalate competing risks to meet deadlines with minimum input from leadership
- Keen eye for detail and adept problem-solving abilities
- Must have demonstrated experience relaying and receiving information (written and verbal)
- Expert ability to work collaboratively and independently in a structured, disciplined, technology-driven environment
- Ability to work creatively and analytically in a problem-solving environment by ensuring effective teamwork, promotion of innovation, and overall excellence
Similar offers
Searching...