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.Jointhe momentum. We are seeking a Data Architect to join our Technology Solutions 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 ExpectationsWorks closely with clients and other resources to effectively communicate, design, plan, and implement capabilities that provide value to customersArchitect comprehensive data solutions that enable clients to appropriately capture, make sense of and action data.Demonstrate value to clients through software demonstrations and prototypes; software installations/evaluations; assessment of business problems; and identification of solutions using the Microsoft Data Platform stack -on premise and hosted on AzureEnsure delivered solutions fit within overall project plan and scheduleProvide feedback to customers and creates structured documentation, including specifications and weekly status reportsAdvise clients on configuration and implementation options based on best practicesParticipates in the business requirements gathering process for client customizationsLeads/Supports solution implementation, customization, testing, and deployment, including preparation of test scenarios. Acts as a subject matter expert in transferring solution-critical knowledgeCollaborates with client team participantsEnsures that all implementation methodology deliverables are complete and on timeGenerates project status, time, and expense reports as requested by managementHighly motivated, creative, and self-sufficient with the ability to work successfully under pressureWork closely with clients and Firm stakeholder to develop in-depth knowledge of key drivers and success factors, operational processes, information systems and data sources pertaining to a client’s data domainsWork with decision makers, data scientists / analysts and other end users to define and document key performance indicators, analytic themes, reports and dashboardsPerform other tasks related to data architecture, database performance, data access and security and data quality management, as requiredHelp guide and implement Data Governance initiativesTroubleshoot reporting, analytics and BI tools, systems and software and performance tune these applications, as necessaryCredentials5+ years of experience with Azure Data Lake solutions2+ yearsexperience Databricks solutions2+ years experience deploying solutions using Azure Data FactoryExperience designing and implementing CI/CD pipelinesExperienced in the DevOps process design and implementationDeep understanding of information and data and how it can be leveraged to provide business valueComprehensive database and data warehouse analysis and design experience, with full knowledge of relational databases (Oracle & SQL Server), data warehouse methodologies and data modelingExperience working with data integration toolsExperience with data visualization and analytics toolsStrong ability to gather, author and analyze business and technical requirements and build applications and integrations according to specificationsStrong understanding of relational database structures, theories, principles and practicesFull project management and development life cycle experienceAbility to lead projects and team members under limited supervisionSuperior organizational and project management skillsThe following skills would be considered an asset:Knowledge of Data Management Tools in areas of Metadata, Master Data Management, Data Quality and Data SecurityDeep 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 BlockchainExperience as a Data Scientist including Predictive / Statistical ModelingExperience in Cloud BIExperience working with Google Analytics or other web analytics platformsExperience working with SOA and ESBsExperienced in DevOps / DataOps and Continuous Integration / Delivery / DeploymentAttained other PM and IT-related certifications such as COBIT, ITIL, CISSP, CGEIT, CRISC, CISA, CISM, PMP, Prince2, etc.)A degree or diploma in computer science or computer programming from an accredited post-secondary educational institutionPrevious success working in a customer-facing, consultative roleExperience working with different SDLC methods including Agile, Scrum, XP, RUP, and KanbanThe ability to work as part of a close-knit delivery team Time management skills in a dynamic delivery environmentField consulting or professional services delivery experienceAbility to travel to client locationsCore Competencies and Personal CharacteristicsIntegrity – professional whose honesty, integrity, confidentiality and high ethical standards contributes to effective leadership and optimal business relationshipsEnergy – displays enthusiasm, optimism, drive and passion while maintaining a high level of productivity and a balanced lifestyleDiversity – understands the importance of different backgrounds, perspectives and experiences and is respectful of individual differencesCommunication – effectively expresses ideas and conveys information in business writing, conversations and interactions with othersClient Service Excellence – understands the importance of quality client service by being courteous, responding to client requests in a timely manner and monitoring satisfactionTeamwork & 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 FirmAccountability – 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 makingFlexibility – effectively manages multiple assignments, adapts to changing priorities and is able to work independently or as part of a teamWork Ethic – consistently performs to high quality standards, is dependable and has a constant drive to improveResearch & Analysis – questions inconsistencies in information and generates workable solutions by analyzing, gathering and organizing relevant informationStress Management – functions effectively when under pressure and maintains self-control in difficult situationsInitiative – highly motivated self-starter who takes initiative with minimal supervision Accuracy – pays close attention to detail and ensures work and information are complete and thoroughWillingness to Learn – enthusiastic and eager to meet challenges and assimilate new conceptsTechnical Expertise – demonstrates in-depth professional and technical knowledge when completing tasksMore than a paycheque, MNP delivers. You’ll be empowered to share your ideas, take on new challenges and advance your career. Join a diverse firm committed to maintaining its unique culture and fostering a balanced lifestyle. MNP offers benefits that allow you to thrive at work and outside the office! You can expect: generous paid time off including 4 personal days, firm sponsored FUN social events, a group pension plan with 4% matching contribution, client and team member referral bonuses, a wellness subsidy, health and dental benefits, work-life flexibility, exclusive access to a variety of perks and discounts, professional development assistance, learning opportunities through MNP University, a flexible dress for your day environment and more!