Business Intelligence Data Architect

Business Intelligence Data Architect

This job is no longer open
PointClickCare is the leading North American cloud-based healthcare software for the acute and long-term and post-acute care markets. For over 20 years, the company has held the same vision – to help the world care for vulnerable populations. Since its inception, PointClickCare has grown exponentially with over 1,700 employees today all working towards impacting the lives of millions. Recognized by Forbes as one of the Top 100 Private Cloud Companies and acknowledged by Waterstone Human Capital as Canada’s Most Admired Corporate Culture, PointClickCare leads the way in creating cloud-based software. With its recent acquisition of Collective Medical, PointClickCare solidifies its position as a high growth healthcare software provider, serving over 21,000 long-term and post-acute care providers and over 1,300 hospitals. Their shared mission to support vulnerable populations is allowing PointClickCare and Collective Medical to connect disparate points of care at scale faster than anyone else in the market.

For more information on PointClickCare, please connect with us on Glassdoor and LinkedIn.


Position Summary:
Reporting to the Director of Business Intelligence in the Office of the CIO (OCIO), the Business Intelligence Data Architect plays an important role as a leading member of the Enterprise Data & Analytics (EDA) department and the broader employee base of PointClickCare(PCC).

The Business Intelligence Data Architect is responsible for leading, developing and implementing Business Intelligence technology architectures, roadmaps and design patterns. They provide hands-on design and implementation expertise when selecting technology, building our data & analytics platform, operationalizing analytics, mapping business requirements to solutions, as well as evaluating and monitoring nonfunctional attributes such as security, usability, and stability of analytic solutions across PointClickCare. The Business Intelligence Data Architect develops and drives data management and governance strategies by working directly with all levels of management, lines of business and technology to ensure alignment and dedication to the overall strategic objectives of the organization, in coordination with Enterprise Data & Analytics strategies that support business processes and business process improvement initiatives.

Key Responsibilities:
· Leads the team with addressing database architecture, platform performance and optimization solutions/challenges/opportunities.
· Establishes design patterns for application integration, data governance, and analytics development.
· Maintains accurate and complete technical architectural documentation.
· Understands business requirements and applies architectural and engineering concepts to design analytic solutions that meet operational requirements, such as scalability, maintainability, security, reliability, extensibility, flexibility, availability and manageability.
· Ability to comprehend and apply Cloud Data Architecture Standards and integration design patterns.
· Create detailed logical & physical models identifying all the entities, attributes and their relationships along with the characteristics associated with each of those.
· Segregate data models into data lake, ODS , data marts, and reporting layers. Support review, signoff and adoption of data models in collaboration with global businesses, architecture and delivery teams.
· Experience with Master Data Management (Enterprise Customer, Account, Product, Employee Models) and Data Warehouse/Analytics Business Glossary implementation frameworks.
· Accountable for ensuring infrastructure performance and capacity/workload management is implemented and monitored across enterprise data platforms.
· Ensuring that the solutions, patterns & frameworks can be utilized across the enterprise and are technology agnostic.
· Internal expert on industry trends, conducts research and investigation of software, evaluating new products and services to judge their suitability for use. Provides recommendations/solutions and analysis for opportunities of improvement or transformations on data integration methods (data pipelines, event hubs, data streaming, etc)
· Building and implementing data virtualization and business semantic layers for analytics & insight.
· Leads data & analytics platform architecture decisions and design, identifying the technologies to employ based on capabilities, price, performance, service agreements and organization requirements and constraints.
· Leads and owns the development of architectural roadmaps for database, data access and data technology architectures.
· Leads platform implementations including planning, requirements gathering, data mapping, extract specifications, system set-up, integrity testing, training and documentation.
· Develops security and authentication standards for the organization with respect to our data (platform), ensuring they adhere to PCC Corporate Security & Trust standards
· Provides support, guidance and expertise to internal team member and cross-functional team members regarding the overall data eco-system’s engineering best practices, standards, architectural approaches and delivery of complex technical solutions. Owns and establishes an active/on-going community of practice for data & insights platform consumption and transformation within OCIO and the Enterprise.

Required Experience:
· Degree in Computer Science, Computer Engineering or relevant field
· Expert knowledge of core concepts of data management, warehousing, reporting and analytics.
· Strong communication skills and ability to effectively present and discuss with executive leadership.
· Ability to independently speak to greater vision and strategy for EDA and PointClickCare
· Proficient knowledge in data modeling, database design, data integration, data transformation, scripting and automation, data visualization techniques and solutions
· Experience in multidimensional data modeling, such as star schemas, snowflakes, denormalized models, handling “slow-changing” dimensions/attributes. Extensive expertise in data modeling, both logical and physical
· Experience with data management platforms (Azure, Oracle, IBM, GCP, AWS, Teradata, SAP Hana) and both structured and non-structure data platforms (Azure Synapse, MongoDB, Cassandra, CouchDB, Apache HBase, Snowflake, Greenplum). Ability to provide a holistic view of the platforms (Data, Analytics, Reporting)
· Experience with coding languages (Python, C++, Java, Kafka, Splunk, Scala, C#) & integration toolsets (Apache Spark, Talend, Microsoft, Informatica, IBM, Mulesoft)
· Experience with platform performance and optimization. Extensive knowledge on infrastructure to be able to discuss and challenge infrastructure peers (understanding i/o vs memory, versus caching, etc)
· Proficient knowledge of platform performance/capabilities and capacity/workload management for cloud-based and on-prem platforms
· Expert level knowledge of data integration, data transformation and data transportation framework/patterns
· 3+ years experience designing, developing, testing and debugging BI applications and components on the Microsoft stack, Azure and Office 365, Qlik, Birst, Tableau, PowerBI, Thoughspot, SiSense, Salesforce Einstein Analytics)
· Experience in building/leveraging data services, micro services for data acquisition and data publication.
· Experience as a full stack developer, capable of working across from presentation layer to data layer tiers; building solutions that programmatically interface with 3rd party web APIs
· Exposure in Machine Learning and Advance analytics toolsets/capabilities (ML Frameworks, RStudio, Databricks Unified Analytics Platform, Jupyter Notebook)
· Strong communication skills and ability to effectively present and discuss with executive leadership.

It is the policy of PointClickCare to ensure equal employment opportunity without discrimination or harassment on the basis of race, religion, national origin, status, age, sex, sexual orientation, gender identity or expression, marital or domestic/civil partnership status, disability, veteran status, genetic information, or any other basis protected by law. PointClickCare welcomes and encourages applications from people with disabilities. Accommodations are available upon request for candidates taking part in all aspects of the selection process. Please contact should you require any accommodations.

When you apply for a position, your information is processed and stored with Lever, in accordance with Lever’s Privacy Policy. We use this information to evaluate your candidacy for the posted position. We also store this information, and may use it in relation to future positions to which you apply, or which we believe may be relevant to you given your background. When we have no ongoing legitimate business need to process your information, we will either delete or anonymize it.  If you have any questions about how PointClickCare uses or processes your information, or if you would like to ask to access, correct, or delete your information, please contact PointClickCare’s human resources team: 
This job is no longer open
Logos/outerjoin logo full

Outer Join is the premier job board for remote jobs in data science, analytics, and engineering.