Senior Data Architect And Modeler

Job Title

Pay Range $55hr - $60hr

• 15+ years of experience in designing data assets for extremely performant Operational Data Stores and near real time Data Warehouses.
• Well versed with industry standard Kimball and Inmon practices.
• Expertise in creating ER (Entity Relationship), Logical, Physical, and Conceptual data models for an enterprise.
• At least 15 years hands on experience with Data Modeling tool such as Erwin.
• Data Modeling experience in financial industry is highly preferred.
• Solid communication skills and ability to facilitate / lead Data Modeling sessions with partners including Business, IT (engineers and developers), BI (Business Intelligence), System of Record (SOR) SMEs etc.
• Experience in event streaming and event-based data warehousing methodologies.
• Experience in modern data design methodologies such as DDD (Domain Driven Design), Microservices Based Architecture, Bounded Contexts, and Data Mesh building data warehouses for agility, scalability, and autonomy.
• 10+ years of data analysis and profiling experience in financial services development, including account, card, payment, or digital processing.
• Expert SQL development, analysis, design, and performance skills in technologies such as MongoDB, Oracle EXADATA, Hadoop, Spark.
• Expert hands-on development, and performance tuning experience in Snowflake including writing pipelines, coding stored procedures, and establishing data share.
• Well versed in Power Point and able to design complex dashboards in Power BI.
• Expert in Excel and Splunk with experience in writing complex macros to expedite data analysis.
• Experience in reverse/forward engineering analysis for complex data flows and able to develop source-to-target and process mappings.
• Strong scripting experience in Python to create alerts and monitoring, build ingestion and interfaces to move data between systems and automate data governance.
• Experience in building and maintaining an evergreen Data Catalogue for an enterprise with robust metadata and end to end lineage.
• Experience with Alation, Collibra etc. is nice to have.
• Experience in tools such as Matillion, Snap Logic, or DBT is nice to have.
• Experience with industry reference frameworks such as BIAN (Banking Industry Architecture Network), IBM Banking & Financial Markets Model, ISO
  20022 is a plus.

• Deliver a world class data architecture to an enterprise that establishes robust data governance and enforces best practices, policies, and procedures across the entire data landscape on cloud or premises.
• Drive reuse of data and data models at all levels and establish standards to enforce and preserve single version of truth across the data landscape.

• Excellent interpersonal, written, and verbal communication skills.
• Comfortable working in a fast paced, highly complex, matrixed environment and capable of handling multiple tasks concurrently.
• Ability to understand current data landscape, interpret results of analysis, identify trends and issues, and develop data standards to support business objectives.
• Ability to exercise independent judgment and creative problem-solving techniques for data solutions in a large and complex environment.
• Strong organizational skills with demonstrated ability to work with partners to meet business SLAs and plan and deliver work to expectations.
• Functional knowledge of the Financial Services industry with experience promoting a robust risk & control environment is preferred.
• Ability to coach, train, and mentor junior staff.