SRM Digital LLC · 1 day ago
Senior Data Modeler/Architect
SRM Digital LLC is seeking a highly experienced Sr Data Modeler/Architect to design and deliver a world-class data architecture for a large, complex enterprise environment. The ideal candidate will establish robust data governance and enforce enterprise-wide data standards, particularly within the financial services domain.
Responsibilities
Lead the design and delivery of enterprise-scale data architecture, ensuring strong data governance, best practices, policies, and procedures across cloud and on-premise environments
Design and optimize highly performant Operational Data Stores (ODS) and near real-time Data Warehouses, leveraging industry-standard Kimball and Inmon methodologies
Create and maintain Conceptual, Logical, Physical, and ER data models for enterprise systems, with extensive hands-on experience using Erwin or similar data modeling tools
Drive data and model reuse across the organization, defining standards that enforce and preserve a single version of truth
Facilitate and lead data modeling and design workshops with cross-functional stakeholders including Business, Engineering, BI teams, and System of Record (SOR) SMEs
Design and implement event-driven and event-streaming data architectures, including event-based data warehousing approaches
Apply modern data design principles including Domain-Driven Design (DDD), Microservices-based architectures, Bounded Contexts, and Data Mesh to enable scalability, agility, and autonomy
Perform advanced data analysis and profiling within financial services domains such as accounts, cards, payments, and digital processing
Develop and optimize complex SQL for high-performance databases including Oracle Exadata and MongoDB, ensuring efficient physical data models
Lead hands-on development and performance tuning in Snowflake, including pipeline development, stored procedures, and secure data sharing
Design executive-level presentations and dashboards using PowerPoint and Power BI to communicate complex data insights
Perform advanced data analysis using Excel and Splunk, including creation of complex macros to accelerate analytical workflows
Conduct reverse and forward engineering for complex data flows; develop detailed source-to-target mappings and process documentation
Build automation and monitoring solutions using Python for data ingestion, alerts, interfaces, and data governance enforcement
Build and maintain an enterprise data catalog with end-to-end metadata management and lineage; experience with Alation, Collibra, or similar tools is preferred
Design and develop data pipelines using tools such as Matillion, SnapLogic, or dbt across cloud and on-premise platforms
Leverage industry reference models and frameworks such as BIAN, IBM Banking & Financial Markets Model, and ISO 20022 where applicable
Coach, mentor, and guide junior architects and data professionals
Qualification
Required
15+ years of hands-on experience in enterprise data architecture, data modeling, and data warehousing
10+ years of data analysis and profiling experience within the financial services industry
Deep expertise in data modeling tools (preferably Erwin) and enterprise-scale data architecture
Strong proficiency in SQL, Python, Snowflake, Oracle, and modern data platforms
Excellent verbal, written, and interpersonal communication skills with the ability to simplify complex concepts
Proven ability to work effectively in fast-paced, highly complex, matrixed environments
Strong analytical and problem-solving skills with the ability to exercise independent judgment
Demonstrated organizational skills with experience managing multiple priorities and meeting business SLAs
Preferred
Strong preference for financial services domain expertise
Solid understanding of risk, controls, and regulatory considerations within financial services
Company
SRM Digital LLC
We at SRM Digital are focused towards connecting businesses with top talent across various industries.
Funding
Current Stage
Early StageCompany data provided by crunchbase