Senior BI Analyst/Data Analyst

6 days ago

Richmond Hill, Canada Onico Solutions Full time

The Senior BI Analyst/Data Analyst will contribute to the design, development and maintenance of strategic, high-profile executive-level dashboards/reports and will play a key role in developing database objects, metrics, dashboards/reports using Microsoft BI technologies (SQL Server 2016 Enterprise, Power BI, SSIS, Excel, etc). They will also assist business in developing business cases and forecasting/planning using data from data warehouses.

• Design, develop and maintain data warehouses to integrate data from the most appropriate data sources to ensure accurate and timely reporting.
• Design, develop and maintain Power BI dashboards/reports.
• Develop data models and schemas to accurately represent structured and unstructured raw data in databases
• Transform raw data into preprocessed data to be used in generating actionable insights
• Proactively seek to understand end-user requirements in order to implement effective data visualizations in dashboards/reports.
• Proactively seek opportunities to automate the most time and resource intensive processes related to data collection validation, transformation, etc. to optimize the production and delivery of dashboards/reports.
• Contribute to the design and implementation of branding (i.e., standardized “look and feel”) for all dashboards/reports.
• Assist in the development of a future state BI architecture and roadmap.
• Help investigate and diagnose issues and ensure problems and defects are resolved in a timely manner.
• Analyze data for trends and building analytical models to determine revenue opportunities, minimize risk and assist business in financial modelling for business cases, compensation plans, sales targets, etc.
• Manage the Planning and forecasting process
• Play lead role in analytics requirements of business.

Qualifications

• 5 years hands-on technical Business Intelligence experience with advanced knowledge in Microsoft BI technologies (SQL Server, Power BI, Power Pivot, Visual Basic).
• Advanced knowledge of Excel and reporting tools, VB, relational database tools such as Access.
• Designing ETL processes, including development of relational data model
• Strong SQL skills, including common table expressions, window functions, joins, complex data types, stored procedures and update scripts
• Experience in building and updating SSIS ETL workflows
• Ability to analyze large data sets
• Developed financial models and analyses relating to Plan and Forecasting, business cases
• Excellent interpersonal, communication and negotiation skills.
• Ability to work effectively in a self-directed manner and also as part of a project team.
• Ability to effectively handle ambiguous, ad hoc tasks and changes in direction and priorities in response to unexpected events and circumstances.
• Experience with other BI tools such as Tableau, MicroStrategy, etc. is an asset
• Experience with Cloud technologies (e.g., Microsoft Azure, AWS) is an asset

This is permanent position located in Toronto. Hybrid position work from home 3-4 days/week.

#J-18808-Ljbffr

  • Senior BI Analyst/Data Analyst

    3 weeks ago

    Richmond Hill, Canada Onico Solutions Full time

    The Senior BI Analyst/Data Analyst will contribute to the design, development and maintenance of strategic, high-profile executive-level dashboards/reports and will play a key role in developing database objects, metrics, dashboards/reports using Microsoft BI technologies (SQL Server 2016 Enterprise, Power BI, SSIS, Excel, etc). They will also assist...

  • Senior BI Analyst/Data Analyst

    2 weeks ago

    Richmond Hill, Canada Onico Solutions Full time

    The Senior BI Analyst/Data Analyst will contribute to the design, development and maintenance of strategic, high-profile executive-level dashboards/reports and will play a key role in developing database objects, metrics, dashboards/reports using Microsoft BI technologies (SQL Server 2016 Enterprise, Power BI, SSIS, Excel, etc). They will also assist...

  • Senior Data Analyst — Power BI

    3 weeks ago

    Richmond Hill, Canada Venterra Realty Full time

    A growing real estate company is seeking a Senior Data Analyst to analyze complex datasets and provide insights that drive business strategy. This hybrid role involves leading the development of data products, mentoring junior analysts, and collaborating across corporate functions. Candidates should have a strong background in analytics, particularly in...

  • Senior Data Analyst — Power BI

    3 weeks ago

    Richmond Hill, Canada Venterra Realty Full time

    A growing real estate company is seeking a Senior Data Analyst to analyze complex datasets and provide insights that drive business strategy. This hybrid role involves leading the development of data products, mentoring junior analysts, and collaborating across corporate functions. Candidates should have a strong background in analytics, particularly in...

  • Senior Data Analyst — Power BI

    4 weeks ago

    Richmond Hill, Canada Venterra Realty Full time

    A growing real estate company is seeking a Senior Data Analyst to analyze complex datasets and provide insights that drive business strategy. This hybrid role involves leading the development of data products, mentoring junior analysts, and collaborating across corporate functions. Candidates should have a strong background in analytics, particularly in...

  • Senior BI Analyst

    3 weeks ago

    Richmond Hill, Canada Onico Solutions Full time

    A leading company in the data analytics field is seeking a Senior BI Analyst/Data Analyst to design and maintain high-profile dashboards and reports using Microsoft BI technologies. This role involves developing data models, automating processes, and conducting business analysis to support forecasting and planning efforts. Join a collaborative and innovative...

  • Senior BI Analyst

    3 weeks ago

    Richmond Hill, Canada Onico Solutions Full time

    A leading company in the data analytics field is seeking a Senior BI Analyst/Data Analyst to design and maintain high-profile dashboards and reports using Microsoft BI technologies. This role involves developing data models, automating processes, and conducting business analysis to support forecasting and planning efforts. Join a collaborative and innovative...

  • Senior BI Analyst

    19 hours ago

    Richmond Hill, Canada Onico Solutions Full time

    A leading company in the data analytics field is seeking a Senior BI Analyst/Data Analyst to design and maintain high-profile dashboards and reports using Microsoft BI technologies. This role involves developing data models, automating processes, and conducting business analysis to support forecasting and planning efforts. Join a collaborative and innovative...

  • Senior Data Analyst

    3 weeks ago

    Richmond Hill, Canada Venterra Realty Full time

    Description ROLE: Senior Data Analyst REPORTS TO: Manager, Analytics and Business Intelligence LOCATION: Hybrid / Corporate Office in Richmond Hill, Ontario Company Overview Venterra Realty is a growing developer, owner, and operator of multifamily apartments with approximately 90 mixed-use and multifamily communities across 21 major US cities. Over 42,000...

  • Senior Data Analyst — Power BI

    4 weeks ago

    Richmond Hill, Canada Venterra Full time

    A leading multifamily property management company is seeking a Senior Data Analyst to uncover insights that drive strategy and performance. The ideal candidate will lead data analysis, define business metrics, and create interactive visualizations in Power BI. Requires at least 5 years in analytics, expertise in SQL and Power BI, and strong leadership...