Senior Data Architect

$104,580 - $183,015/Yr

Marsh & McLennan Companies - Wenatchee, WA

posted about 1 month ago

Full-time - Senior
Remote - Wenatchee, WA
Insurance Carriers and Related Activities

About the position

As a Senior Data Architect on the Data team at Marsh McLennan Agency (MMA), you will establish consistent data standards, reference architectures, patterns, and practices across the organization for both OLTP and OLAP technologies, including Data Warehouse and Data Lake house. Your role will involve defining reference data architecture and collaborating with agile teams to ensure that documented best practices are utilized in data platform development. You will create strategies and design solutions for various use cases such as Data Migration (end-to-end ETL process), database optimization, and data architectural solutions for Analytics Data Projects. Additionally, you will design, develop, and troubleshoot complex technical problems in OLAP/OLTP/DW and Analytics, providing solutions for Enterprise-level Applications utilizing the Azure Data Platform.

Responsibilities

  • Establish consistent data standards and reference architectures across the organization.
  • Define reference data architecture and work with agile teams to implement best practices in data platform development.
  • Create strategies and design solutions for Data Migration, database optimization, and data architectural solutions for Analytics Data Projects.
  • Design, develop, and troubleshoot complex technical problems in OLAP/OLTP/DW and Analytics.
  • Provide solutions for Enterprise-level Applications utilizing Azure Data Platform.

Requirements

  • 10+ 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 their strengths and weaknesses.
  • Expertise in creating ER, 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 various data velocities, latencies, and volumes.
  • 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.
  • 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, 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.

Nice-to-haves

  • Knowledge of Agency Management systems like Applied EPIC and Vertafore Sagitta, Benefit Point.
  • Microsoft Azure Data Engineer or other cloud certifications.
  • Data bricks experience and certification.

Benefits

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

Match and compare your resume to any job description

Start Matching
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service