Business Intelligence Data Analyst
We are Systematix and we are looking for aBusiness Intelligence Data Analystto fill a six-month+REMOTE contract position with one of our key clientele in Toronto.
ABOUT THE PROJECT
As a Business Intelligence Data Analyst you willplay an integral role in our client's strategic and operational capabilities by querying data repositories and generating ad-hoc reports and identifying data patterns and trends in available information sources. The successful candidate will have exceptional initiative and strong quantitative skills, along with a drive to consistently seek out additional information and ideas to support business. Strong analytical skills, inductive reasoning abilities and initiative and teamwork are rewarded with opportunities for advancement and increased responsibility.
The Customer Solutions BI Data Analyst will work directly with senior leadership in terms of opportunities to engage in business problem solving and provide thought leadership with inputs into strategic decision making for the Customer Solutions team. You will be expected to take chargedriving insightful analytical findings with a problem-solving oriented approach and driving data to usable information for client's Customer Solutions & Analytics team.
ABOUT THE RESPONSIBILITIES
Query database tables to extract business requested data
Create ad-hoc reports (using MS SQL, MS Excel, Power BI Reporting tools) within required timeframes; analyze and validate data to provide assurance of accuracy and validity of critical business information
Provide quantitative analysis, reporting, and trending for key strategic initiatives; provide data sets and metrics to add context and measure potential impact for new projects
Synthesize current business intelligence or trend data to support recommendations for action
Actively engage with internal /external teams to streamline and standardize existing reports by identifying and developing opportunities to increase efficiencies
Analyze, improve, and add to existing dashboards by reengineering existing MS SQL queries
Build reporting tools to assist business operational users to execute day-to-day responsibilities
Analyze data correlations / discrepancies / reconciliations and related impact to business
Track and document post implementation benefits and key objective measurement
Provide data-based solutions to complex problems and offer creative suggestions for alternative designs and methods where applicable
Collect business intelligence data from available industry reports, public information, field reports, or purchased sources to correlate available information with outside sources
Maintain or update business intelligence tools, databases, dashboards, systems, or methods.
Manage timely flow of business intelligence information to users
ABOUT THE REQUIREMENTS
Thorough understanding & hands-on execution knowledge and comfort of relational databases
- Self-starter, results-oriented with proven previous success at prioritizing and managing multiple tasks of varying complexities in the context of operational impact and corporate goals, as well as meeting tight deadlines.
- Proven logical and analytical problem-solving abilities. Comfort with numerical and financial analysis.
- Excellent written and verbal communication skills, must be comfortable to interact independently with managers, supervisors and end users to dissect business issues from a data standpoint
- Self-motivated and able to work with minimal supervision and tight deadlines.
Previous experience working with MS SQL Server including querying, reengineering, and manipulating data is required
Experienced in numerical, statistical, and / or financial analysis
Understanding of MS SSRS for report deployment and code management
Advanced Excel skills, with experience with MS Excel’s analytics tools (Macros, VBA, Pivot Tables, Charts and Graphs)
Working knowledge of Tableau is preferred
Working knowledge of Power BI Reporting tools needed
Prior work experience in similar role that involved heavy lifting of data, and working independently with cross-functional business units to analyze data requirements
Strong Inductive Reasoning skills: The ability to combine pieces of information to form general rules or conclusions (includes finding a relationship among seemingly unrelated events).
Effective at managing multiple projects/tasks of varying complexities, meeting deadlines, and working well under pressure
A Bachelor’s degree in any one of these major fields – Business degree with a focus on Math , Statistics, Economics, Engineering or technical equivalents, along with 3+ years’ work experience in one of these roles is needed: BusinessAnalytics, Business Intelligence (BI), Reporting Analyst , Business Data Analyst or technical equivalent
Alternately, a Masters’ degree in any one of these major fields – Business degree with a focus on Math & Statistics, Economics, Engineering or technical equivalents, along with a minimum 2+ years’ work experience in one of these roles is needed: Business Analytics, Business Intelligence (BI) , Reporting Analyst , Business Data Analysts or technical equivalent
ABOUT THE ROLE
This is a six (6) month REMOTEcontract position with strong opportunity to extend, or turn into fulltime work based on performance. Open to residents of Canada and USA who are able to work Central time zone. (Must be able to work 8:30AM CST through 5:30 PM CST or you can choose9:00 AM to 6:00 PM CSTwindow.)
If you are interested in finding out more, please contact us or submit your resume to email@example.com. Or, if you know someone who meets these qualifications, please forward this assignment opportunity to them.
Systematix is one of Canada’s largest privately-owned National Consulting and Resourcing firms. With offices across North America we provide the highest caliber consulting solutions to a diverse client base that includes all levels of Government and private industry sectors.
Systematix is committed to creating a diverse, inclusive environment and is proud to be anequal opportunity employer.
At Systematix, we bring people and projects together!
Job: Business Intelligence Data Analyst
"*" indicates required fields