MARKS IT Solutions ยท 3 hours ago
Senior Enterprise Data Architect & Modeler
Berkeley Heights, NJ
Contract
Onsite
Senior Level, Lead/Staff
15+ years expMARKS IT Solutions is seeking a Senior Enterprise Data Architect & Modeler to design and deliver enterprise data architecture within a complex financial services environment. The role involves creating and maintaining data models, driving data governance, and collaborating with various teams to ensure data standards and best practices are followed.
Information Technology & Services
Hiring Manager
Imtiaz mahammad
Responsibilities
Design enterprise-wide data architecture enforcing governance, standards, and best practices
Create and maintain ER, conceptual, logical, and physical data models
Lead data modeling and design sessions with business users and technical teams
Drive data reuse and standardization across the enterprise
Perform data analysis, profiling, and reverse/forward engineering
Develop source-to-target mappings and end-to-end process documentation
Build and optimize high-performance physical data models
Develop and tune SQL, stored procedures, pipelines, and data shares in Snowflake
Implement event-based and near real-time data warehousing solutions
Create dashboards and presentations using Power BI, PowerPoint, and Excel
Use Python scripting and Splunk for monitoring, alerts, ingestion, and reporting automation
Maintain an evergreen enterprise data catalog with full metadata and lineage
Collaborate on data pipeline development using Matillion, SnapLogic, or dbt (nice to have)
Apply industry reference models such as BIAN, IBM Banking & Financial Markets Model, and ISO 20022
Coach, mentor, and support junior data modeling and analytics resources
Qualification
Required
15+ years of hands-on experience designing enterprise-scale data assets
Proven expertise in highly performant Operational Data Stores (ODS) and near real-time Data Warehouses
Strong knowledge of industry-standard data modeling methodologies including Kimball and Inmon
Extensive experience creating Conceptual, Logical, Physical, and ER data models
Hands-on expertise with data modeling tools such as Erwin
Strong financial services domain experience including accounts, cards, payments, and digital processing
Expert-level SQL development, data analysis, and performance tuning
Strong experience with Oracle Exadata, MongoDB, and Snowflake
Hands-on experience building and optimizing Snowflake solutions
Experience developing pipelines, stored procedures, data sharing, and tuning performance in Snowflake
Experience with event streaming and event-driven data warehousing architectures
Strong experience driving data reuse and enforcing enterprise data standards
Proven ability to establish and maintain a single version of truth across the data landscape
Proficiency in Python scripting for data ingestion, monitoring, alerts, and governance automation
Experience building and maintaining enterprise data catalogs with metadata and lineage
Excellent communication skills with experience leading data modeling workshops
Strong collaboration skills across Business, Engineering, BI, and System-of-Record teams
Design enterprise-wide data architecture enforcing governance, standards, and best practices
Create and maintain ER, conceptual, logical, and physical data models
Lead data modeling and design sessions with business users and technical teams
Drive data reuse and standardization across the enterprise
Perform data analysis, profiling, and reverse/forward engineering
Develop source-to-target mappings and end-to-end process documentation
Build and optimize high-performance physical data models
Develop and tune SQL, stored procedures, pipelines, and data shares in Snowflake
Implement event-based and near real-time data warehousing solutions
Create dashboards and presentations using Power BI, PowerPoint, and Excel
Use Python scripting and Splunk for monitoring, alerts, ingestion, and reporting automation
Maintain an evergreen enterprise data catalog with full metadata and lineage
Coach, mentor, and support junior data modeling and analytics resources
Excellent verbal and written communication skills
Strong organizational and time-management capabilities
Ability to work effectively in a fast-paced, matrixed environment
Proven ability to analyze complex data landscapes and define data standards
Strong independent judgment and creative problem-solving skills
Ability to manage multiple priorities and meet business SLAs
Preferred
Familiarity with tools such as Alation or Collibra
Financial services experience with a focus on risk and controls
Collaboration on data pipeline development using Matillion, SnapLogic, or dbt
Apply industry reference models such as BIAN, IBM Banking & Financial Markets Model, and ISO 20022
Company
MARKS IT Solutions
MARKS IT Solutions is a trusted partner in delivering agile and scalable workforce solutions across Technology and Business domains.
2-10 employees
Funding
Current Stage
Early StageCompany data provided by crunchbase