Data Architect

Canada
Product Delivery – Product Delivery /
Full-time /
Hybrid
We are 3PILLAR GLOBAL
 
We build breakthrough software products that power digital businesses. We are an innovative product development partner whose solutions drive rapid revenue, market share, and customer growth for industry leaders in Software and SaaS, Media and Publishing, Information Services, and Retail.
 
Our key differentiator is our Product Mindset. Our development teams focus on building for outcomes and all of our team members around the globe are trained on the Product Mindset’s core values – Minimize Time to Value, Solve For Need, and Excel at Change. Our teams apply this mindset to build digital products that are customer-facing and revenue-generating. Our business-minded approach to agile development ensures that we align to client goals from the earliest conceptual stages through market launch and beyond.

Responsibilities

    • Analyze and organize raw data and build data systems and pipelines
    • Enforce data ingestion, integration, and access patterns to support both real-time and batch-based consumer data needs
    • Plan and oversee data migration processes when transitioning to an Informatica environment
    • Display strong thought leadership in pursuit of modern data architecture principles and technology modernization
    • Define and lead technology proof of concepts to ensure feasibility of new data technology solutions
    • Create comprehensive documentation for design, and processes to support ongoing maintenance and knowledge sharing
    • Conduct architectural reviews to ensure the solution addresses customer pain points, business, and technical requirements, and alignment to standards and best practices
    • Conduct complex data analysis and report on results
    • Prepare data for prescriptive and predictive data modelling and data warehousing 
    • Combine raw information from different sources
    • Explore ways to enhance data quality and reliability
    • Collaborate with product owners, SME's and architectsDefine target architecture and get buy in from stakeholders
    • Establish a roadmap to deliver the solution

Requirements

    • Bachelor's or Master's degree in Computer Science or equivalent, with over 10 years of Data Architecture experience, including team leadership
    • Proven expertise in designing data platforms for large-scale data and diverse data architectures, including warehouses,, and integrated data stores
    • 10 years experience in Oracle
    • Hands on experience with generic and complex stored procedures
    • Proficient in addressing data-related challenges through analytical problem-solving and aligning data architecture with organizational business goals and objectives
    • Ability to manage projects effectively, plan tasks, set priorities, and meet deadlines in a fast-paced environment
    • Experience with designing data models and managing database migrations
    • Experience designing data warehouses
    • Experience with Cloud solutions

Nice to have

    • In-depth knowledge of HEDIS (Healthcare Effectiveness Data and Information Set) & US Health Insurance