Business Systems Analyst BI

Our client is searching for a skilled Business Systems Analyst responsible for planning, designing, developing, and launching efficient business, financial, and operations systems supporting core organizational functions and business processes. This includes gathering and analyzing data in support of business cases, proposed projects, and systems requirements. The BSA&BI is also responsible for generating and compiling reports based on the findings, with probable causes and possible solutions to systems issues. 

• Meet with decision-makers, systems owners, and end-users to define business, financial, and operations requirements and systems goals, and identify and resolve systems issues.
• Lead design sessions in prototyping new systems for the purpose of enhancing business processes, operations, and information process flow.
• Review and analyze the effectiveness and efficiency of existing systems and develop strategies for improving or further leveraging these systems.
• Identify and establish the scope and parameters of systems analysis to define outcome criteria and measure-taking actions.
• Collaborate in the planning, designing, developing, and deploying of new applications and enhancements to existing ones.
• Research software products to justify recommendations and support purchasing efforts.
• Design and development of database objects, tables, stored procedures, views, triggers, SSRS and SSIS packages.
• Translation of business requirements into ETL and report specifications.
• Develop and implement ETL processes, reports and queries to support business analytics.
• Design and development of database objects, tables, stored procedures, views, triggers and SSIS packages.
• Design and development of enterprise business intelligence, data warehousing and reporting solutions.
• Working with business users to establish reporting and analytic requirements.
• Understanding key performance indicators that drive company measurement, reporting and analytics across key data sources and functions.
• Proven experience overseeing software solutions, systems, product design, development, and implementation.
• Working knowledge of network and PC operating systems, including Windows 10\11 and Server 2016 or newer.
• Extensive practical knowledge in importing data in report software, graphs, and flow charts.
• Extensive experience with core software applications, including ERP (Eclipse). Microsoft Power BI, Microsoft SQL, Microsoft Access, and Excel (Advanced)
• Demonstrated project management skills.
• Excellent understanding of the organization’s goals and objectives.

• Experience with basic accounting and financial reporting, including but not limited to General accounting principles, Balance Sheet and Operating Statement principles, and General Ledger/Sub-Ledger associations.
• Experience with core business processes including but not limited to Accounts Payable, Accounts Receivable, and the reconciliation of General Ledger/Sub-Ledger administration.
• Five years of IS-related experience in Microsoft PowerBI, PowerApps, SQL Development, and system integration.
• Experience with the Explorer Contract Manager.
• Post-secondary education in Computer Science or Information Systems, or related discipline or related experience/education.
• Proficient in database management & integration technologies.
• Skill in promptly detecting, analyzing, and resolving computer software and network problems, sometimes with little time or data.
• Ability to provide useful advice or facilitate discussion with client departments regarding future needs or changes.
• Exceptional interpersonal and customer service skills, including excellent verbal and written communication abilities.
• Must demonstrate active listening and strong facilitation.
• Must possess strong organizational and analytical skills and attention to detail.
• Experience with construction industry accounting.