Data Architect, Technology Solutions

Join the 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.

ROLE @ MNP

Responsibilities

  • Works closely with clients and other resources to effectively communicate, design, plan, and implement capabilities that provide value to customers
    Architect 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 Azure
  • Ensure delivered solutions fit within the overall project plan and schedule
  • Provide feedback to customers and creates structured documentation, including specifications and weekly status reports
  • Advise clients on configuration and implementation options based on best practices
  • Participates in the business requirements gathering process for client customizations
  • Leads/Supports solution implementation, customization, testing, and deployment, including preparation of test scenarios.
  • Acts as a subject matter expert in transferring solution-critical knowledge
  • Collaborates with client team participants
  • Ensures that all implementation methodology deliverables are complete and on time
  • Generates project status, time, and expense reports as requested by management
  • Highly motivated, creative, and self-sufficient with the ability to work successfully under pressure
  • Work closely with clients and Firm stakeholders 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
  • Work with decision-makers, data scientists/analysts and other end-users to define and document key performance indicators, analytic themes, reports and dashboards
  • Perform other tasks related to data architecture, database performance, data access and security and data quality management, as required
  • Help guide and implement Data Governance initiatives
  • Troubleshoot reporting, analytics and BI tools, systems and software and performance tune these applications, as necessary

Skills And Experience

  • 5+ years of experience with Azure Data Lake solutions
  • 2+ years experience Databricks solutions
  • 2+ years experience deploying solutions using Azure Data Factory
  • Exposure to or experience with Microsoft Synapse
  • Experience designing and implementing CI/CD pipelines
  • Experienced in the DevOps process design and implementation
  • 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 modelling
  • 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
  • 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 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.)
  • A degree or diploma in computer science or computer programming from an accredited post-secondary educational institution
  • Previous success working in a customer-facing, consultative role
  • Experience working with different SDLC methods including Agile, Scrum, XP, RUP, and Kanban
  • The ability to work as part of a close-knit delivery team
  • Time management skills in a dynamic delivery environment
  • Field consulting or professional services delivery experience
  • Ability to travel to client locations