VBA Software Developer
Accenture
Software Engineering
Canada · Toronto, ON, Canada
Posted on Dec 23, 2024
VBA Software Developer
Toronto Job No. 1151
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
Life at Accenture
Work where you're inspired to explore your passions and where your talents are nurtured and cultivated. Innovate with leading-edge technologies on some of the coolest projects you can imagine.
Training and Development
Take time away to learn and learn all the time in our regional learning hubs, connected classrooms, online courses and learning boards.
Work Environment
Be your best every day in a work environment that helps drive innovation in everything you do.
Learn more about Accenture
Our more than 742,000 people in more than 120 countries, combine unmatched experience and specialized skills across more than 40 industries. We embrace the power of change to create value and shared success for our clients, people, shareholders, partners and communities.
Our Expertise
See how we embrace the power of change to create value and shared success for our clients, people, shareholders, partners and communities.
Meet Our People
From entry-level to leadership, across all business and industry segments, get to know our people harnessing technology to make a difference, every day.
Stay connected
Join Our Team
Search open positions that match your skills and interest. We look for passionate, curious, creative and solution-driven team players.
Keep Up to Date
Stay ahead with careers tips, insider perspectives, and industry-leading insights you can put to use today–all from the people who work here.
Job Alert Emails
Personalize your subscription to receive job alerts, latest news and insider tips tailored to your preferences. See what exciting and rewarding opportunities await.