Business Analyst

Dick's Lumber

23d•Onsite

About The Position

Dick's Lumber is hiring for a Business Analyst. We offer an exceptional working environment on a supportive and dynamic team. We encourage innovation and creativity with rewards and opportunity. Reporting to the Controller this position will be responsible for becoming an expert with internal and external systems. The Business Intelligence Analyst will be responsible for developing and maintaining reports and applications required to improve business effectiveness, including executing key tech projects. Over time the position will be a business systems functional expert and will work with a high degree of independence, to continuously identify and pursue productivity and technology-related process improvement opportunities involving new or existing technologies.

Requirements

Advanced analytical & financial modeling skills.
Advanced abilities in Microsoft Office programs
Excellent verbal and written communication skills.
Detail-oriented with strong organization skills & ability to keep track of multiple information sources
Ability to handle multiple priorities in an efficient manner.
High degree of curiosity, discovery, and willingness to work through complex scenarios with multiple systems.
Experience with relational databases;
Knowledge and experience with Python, Visual Basic a must
Experience in writing high level SQL Server queries, knowledge of CTE, Window Functions, Pivoting, creating and maintaining Triggers, SQL Agent Jobs, Stored Procedures, Functions, etc.
Experience working with Apache Airflow, Data pipeline and Data warehousing is a must.
Knowledge and experience with SharePoint, Power Automate, Power Apps a must
Experience creating reports using Crystal, SSRS, Power BI

Nice To Haves

Project Management Training / experience considered an asset
Working knowledge of manufacturing operations, accounting principles, internal controls, purchasing, inventory an asset.
Knowledge of Auto Hotkey is an asset.
Experience working with Linux is an asset.
Knowledge of API, HTTP Post and Get requests, Postman Services, Microsoft Graph API is an asset.
Experience with M/Dax, Powershell, HTML, CSS, Javascript considered an asset
Experience with bisTrack, Mitek and Dynamics GP would be an asset

Responsibilities

Develop reports and applications for a broad range of needs and business units / divisions
Prepare & consolidate reporting packages including, key performance indicators, forecasts & variance analysis.
Accountable to project execution, timelines and success.
Assist in the development of best business practices and process standardization.
Work closely with corporate departments and senior management to develop reports and tools
Work closely with the Continuous Improvement team to ensure standards are being followed and improvement requests/projects are being properly assessed.
Continuously monitor, recommend, and implement process improvement initiatives to increases effectiveness and productivity.
Troubleshoot, and support software for end users and assist them in making effective and efficient use of applications