• Business Intelligence Data Engineer, Technology Consulting

    Position ID
    Position Type
    Full Time
    Position Location(s)

    At MNP we pride ourselves on being different – it’s our entrepreneurial drive that sets us apart. It’s the same drive that’s helped us become Canada’s fastest growing national firm. We foster collaboration, value your ideas, promote based on talent, live balanced lifestyles and make time for FUN. We are one firm, one team, collaborating to support you wherever you want to take your career.


    Join the momentum. We are seeking a Business Intelligence Data Engineer to join our Technology Consulting team. Driving business excellence, MNP is a leading national accounting, tax and business consulting firm in Canada. Our Consulting team works with organizations in the public, private and not-for-profit sectors to provide innovative strategies tailored to maximize efficiencies, enhance performance and increase profitability. Specifically, our recognized Technology Consulting team works with clients to translate technology issues and opportunities into meaningful results that meet organizational needs.



    Performance Expectations

    • Work closely with various stakeholders and clients to develop in-depth knowledge of key drivers and success factors, operational processes, information systems and data sources pertaining to a client’s data domains
    • Responsible for data integration, data modeling and the design, development and implementation of data warehouses, reports and dashboards
    • Work with decision makers, data scientists / analysts and other end users to define and document key performance indicators, analytic themes, reports and dashboards
    • Lead projects in the development, implementation and use of data, reporting, analytics and BI software tools and systems
    • Design, develop and implement Extract, Transform and Load (ETL) processes for the BI infrastructure
    • Perform other tasks related to data architecture, database performance, data access and security and data quality management, as required
    • Analyze and document data sources (internal and external) that can be leveraged for BI consumption
    • Analyze user requirements and design functional specifications for reporting, analytics and BI applications and dashboards
    • Design and configure databases, data warehouses and data models to enable self-serve BI opportunities
    • Help guide and implement Data Governance initiatives
    • Troubleshoot reporting, analytics and BI tools, systems and software and performance tune these applications, as necessary
    • Gather and process raw data from a wide variety of sources, including Web Scraping, APIs, JSON feeds, etc.


    • A degree or diploma in computer science or computer programming from an accredited post-secondary educational institution
    • Minimum of three (3) years direct work experience in data integration and Business Intelligence projects
    • Extensive knowledge in advanced SQL writing techniques including troubleshooting performance issues and data profiling
    • Deep understanding of information and data and how it can be leveraged to provide business value
    • Comprehensive database and data warehouse analysis and design experience, with full knowledge of relational databases (Oracle & SQL Server), data warehouse methodologies and data modeling
    • Experience working with data integration tools
    • Experience with data visualization and analytics tools
    • Strong ability to gather, author and analyze business and technical requirements and build applications and integrations according to specifications
    • Strong understanding of relational database structures, theories, principles and practices
    • Full project management and development life cycle experience
    • Ability to lead projects and team members under limited supervision
    • Superior organizational and project management skills
    • Experience working in Agile teams, preferably in a BI project, while leveraging related principles
    • The following skills would be considered an asset:
      • Knowledge of Data Management Tools in areas of Metadata, Master Data Management, Data Quality and Data Security
      • Deep knowledge of the DMBoK (Data Management Book of Knowledge)
      • Attained Data-related certifications such as CDMP, CBIP, etc.
      • Attained Vendor-related Data / Analytics / Reporting certifications (Tableau, IBM, SAAS, Microsoft, Oracle, Teradata, Hadoop, R, Python, etc.)
      • Knowledge in AI, Machine Learning, Data Mining and/or Blockchain
      • Experience as a Senior DBA
      • Experience as a Data Architect
      • Experience as a Data Scientist including Predictive / Statistical Modeling
      • Experience in Cloud BI
      • Experience working with Google Analytics or other web analytics platforms
      • Experience working with SOA and ESBs
      • Experienced in DevOps / DataOps and Continuous Integration / Delivery / Deployment
      • Attained other PM and IT-related certifications such as COBIT, ITIL, CISSP, CGEIT, CRISC, CISA, CISM, PMP, Prince2, etc.)

    Core Competencies and Personal Characteristics

    • Integrity – professional whose honesty, integrity, confidentiality and high ethical standards contributes to effective leadership and optimal business relationships
    • Energy – displays enthusiasm, optimism, drive and passion while maintaining a high level of productivity and a balanced lifestyle
    • Diversity – understands the importance of different backgrounds, perspectives and experiences and is respectful of individual differences
    • Communication – effectively expresses ideas and conveys information in business writing, conversations and interactions with others
    • Client Service Excellence – understands the importance of quality client service by being courteous, responding to client requests in a timely manner and monitoring satisfaction
    • Teamwork & Relationship Development – works collaboratively with team members in order to achieve a common goal and develops, maintains and strengthens relationships with others, both inside and outside the Firm
    • Accountability – takes responsibility for one’s own performance by setting clear goals and tracking progress against those goals; is highly organized and uses personal judgement and decision making
    • Flexibility – effectively manages multiple assignments, adapts to changing priorities and is able to work independently or as part of a team
    • Work Ethic – consistently performs to high quality standards, is dependable and has a constant drive to improve
    • Research & Analysis – questions inconsistencies in information and generates workable solutions by analyzing, gathering and organizing relevant information
    • Stress Management – functions effectively when under pressure and maintains self-control in difficult situations
    • Initiative – highly motivated self-starter who takes initiative with minimal supervision
    • Accuracy – pays close attention to detail and ensures work and information are complete and thorough
    • Willingness to Learn – enthusiastic and eager to meet challenges and assimilate new concepts
    • Technical Expertise – demonstrates in-depth professional and technical knowledge when completing tasks


    MNP encourages a balanced lifestyle and offers benefits that suit the way our team members work and play! In addition to a competitive salary, our MyRewards@MNP package includes paid personal days, wellness program initiatives, health and dental benefits, a group pension plan with matching contribution, firm sponsored social events and professional development assistance.


    MNP proudly serves and responds to the needs of our clients in the public, private and not-for-profit sectors. Through partner-led engagements, we provide a collaborative, cost-effective approach to doing business, with innovative strategies to help organizations succeed across the country and around the world.



    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed

    Connect With Us

    Not ready to apply? Create a profile and connect with us for general consideration.