Data Architect - R01548571

About Brillio:
Brillio is one of the fastest growing digital technology service providers and a partner of choice for many Fortune 1000 companies seeking to turn disruption into a competitive advantage through innovative digital adoption. Brillio, renowned for its world-class professionals, referred to as "Brillians", distinguishes itself through their capacity to seamlessly integrate cutting-edge digital and design thinking skills with an unwavering dedication to client satisfaction. Brillio takes pride in its status as an employer of choice, consistently attracting the most exceptional and talented individuals due to its unwavering emphasis on contemporary, groundbreaking technologies, and exclusive digital projects. Brillio's relentless commitment to providing an exceptional experience to its Brillians and nurturing their full potential consistently garners them the Great Place to Work® certification year after year.
Architect

Primary Skills

• SQL Server, Stream Analytics, CosmosDB, ETL Fundamentals, Purview, SQL, Event Hub, SQL (Basic + Advanced), Python, Data Warehousing, ADLS G2, AZure Monitoring, Synapse, Data Factory, Logic App, Modern Data Platform Fundamentals, Databricks, Data Explorer, Data Modelling Fundamentals, PLSQL, T-SQL, Stored Procedures, Blob

Job requirements

Job Title: Data Architect / Senior Data Modeler – Transaction Hub InitiativeLocation: Remote (U.S. preferred) Start Date: Immediate About the OpportunitySeeking a highly skilled and hands-on Data Architect / Senior Data Modeler to lead the design and implementation of a Transaction Hub – a centralized, real-time operational data store that tracks end-to-end transaction workflows across various systems. This is a strategic and high-visibility initiative, with direct engagement from executive stakeholders including the CTO, CIO, and Head of Data. This role requires a unique blend of deep data modeling expertise, real-time architecture design, and strong stakeholder communication skills. You will be instrumental in shaping the foundation of a scalable and future-ready data platform that supports mission-critical business functions such as payment processing, loan servicing, and customer lifecycle tracking. Key Responsibilities• Partner with business and technical stakeholders (Payments, Servicing, Data Teams) to understand transaction lifecycle workflows and data requirements.• Design and implement a centralized transaction data model that captures real-time status changes across payment processors (e.g., Stripe, FIS) and internal systems.• Build a scalable, modular, and future-proof architecture that can evolve with changing data sources and business processes.• Collaborate with engineering teams to ensure real-time data ingestion, processing, and persistence in appropriate operational data stores (e.g., Azure SQL, MongoDB, Synapse, Databricks).• Lead data modeling efforts, including conceptual, logical, and physical model development and documentation.Design, develop, and maintain conceptual, logical, and physical data models for structured and semi-structured data.Implement data modeling tools and techniques such as ER/Studio, ERwin, PowerDesigner, or equivalent.• Evaluate and recommend optimal data storage and architecture patterns that support both current and future-state requirements.• Interface with executive leadership to communicate architectural decisions, roadmap alignment, and progress updates.• Support adjacent data initiatives such as Customer Hub (operational MDM) and Dealer Hub (legacy sunset and Salesforce integration). Ideal Candidate Profile • 8+ years of experience in data architecture and enterprise data modeling, with a strong understanding of real-time operational systems.• Proven track record in designing transactional data models for complex, event-driven workflows.• Expertise in both relational (Azure SQL, SQL Server) and non-relational (MongoDB, etc.) database technologies.• Familiarity with cloud-based data platforms such as Azure Synapse, Databricks, and Azure Data Factory.• Solid experience with event-driven architectures and real-time data ingestion mechanisms.• Strong understanding of data lifecycle management and source system transitions (e.g., from legacy to Salesforce).• Excellent communication and presentation skills with the ability to engage senior business and technical leaders.• Experience working in high-velocity environments with shifting priorities and evolving requirements.  Know what it’s like to work and grow at Brillio: https://www.brillio.com/join-us/ Equal Employment Opportunity DeclarationBrillio is an equal opportunity employer to all, regardless of age, ancestry, colour, disability (mental and physical), exercising the right to family care and medical leave, gender, gender expression, gender identity, genetic information, marital status, medical condition, military or veteran status, national origin, political affiliation, race, religious creed, sex (includes pregnancy, childbirth, breastfeeding, and related medical conditions), and sexual orientation.
• #LI-AS1 

 Know what it’s like to work and grow at Brillio: Click here