Senior Data Architect

October 25

Apply Now

Receive Emails with Similar Jobs

Marsh McLennan

WebsiteLinkedInAll Job Openings

Insurance Broking • Risk advisory services • HR and related consulting • outsourcing and investments services • Management consulting

10,000+

Description

• Establish consistent data standards, reference architectures, patterns, and practices across the organization for both OLTP and OLAP (Data warehouse, Data Lake house) MDM and AI/ML technologies. • Define reference data architecture and work with agile teams to ensure the documented best practices are used in data platform development. • Create strategies and design solutions for a wide variety of use cases like Data Migration (end-to-end ETL process), database optimization, and data architectural solutions for Analytics Data Projects. • Design, develop, and troubleshoot highly complex technical problems in OLAP/OLTP/DW, Analytics, and provide solutions for Enterprise-level Applications utilizing Azure Data Platform.

Requirements

• 10+ or more years of experience in Information Technology. • 5 to 10 years of experience in Enterprise data architecture, Data, Modelling, Data management and Data strategy • 5 to 7 years of experience in Cloud database technologies. • 7 to 10 years of experience as a data architect • Solid understanding of databases and the strengths and weaknesses of platforms and products, with the ability to provide a trusted voice at the decision-making table • Expertise in creating ER (Entity Relationship), Logical, Physical, and Conceptual data models for an enterprise • Experience in data modeling, streaming skills, and data architecture for operational and analytical datastores • Proficiency in the design of batch and streaming data ingestion • Knowledge in designing solutions with Data Quality, Data Lineage, and Data Catalogs • Experience with solving performance challenges for a variety of velocities, latencies, and volumes of data • Designing and maintaining the data models, including conceptual, logical, and physical data models • Experience with SOA data layer utilizing data access frameworks and exposing data via web services • Experience with Business Intelligence and data mart architecture • Experience creating a data architecture vision between lines of business and IT • Demonstrated competency in communicating the value of data architecture to stakeholders and senior management • Experience in SDLC processes, database patterns, and development frameworks • Strong interpersonal, verbal, and written communication skills, with the ability to develop and conduct executive-level presentations • Experience crafting solutions that leverage data in NoSQL and SQL datastores for high availability and disaster tolerance • Preferred experience with Kubernetes, Cloud Native ecosystem, and Data Lake/Data Warehouse technologies • Deep expertise in Data engineering capabilities involving architecture, modeling (physical and logical), data governance, storage, security, resilience, and replication • Knowledge of Informatica – IICS task flows development and maintenance • Experience with MongoDB or another NoSQL database, PostgreSQL, or any relational database • Experience with Azure, Data Lake, Databricks, SQL, ETL, and MDM • Experience with data integration services such as Azure Data Factory • Experience with business intelligence tools; Power BI or Qlik is preferred • Experience in designing and building large-scale, enterprise systems in a highly available, scalable, performant, and distributed environment

Benefits

• Generous time off, including personal and volunteering • Tuition reimbursement and professional development opportunities • Remote work • Charitable contribution match programs • Stock purchase opportunities