Senior Data Architect

International Catalyst Services, LLC; City of White Plains (NY); Remote; USD 113,000 - 198,000; Full time

Job summary

An established industry player is seeking a Senior Data Architect to join their dynamic Data team. In this pivotal role, you will establish data standards and reference architectures that drive the organization’s data strategy. You will work with agile teams to implement best practices in data platform development, ensuring robust solutions for data migration, optimization, and analytics. This position offers a unique opportunity to leverage your expertise in cloud technologies and data modeling while contributing to enterprise-level applications. Join a culture that values innovation and collaboration, where your contributions will have a meaningful impact on the organization and its clients.

Benefits

Generous time off

Tuition reimbursement

Professional development opportunities

Charitable contribution match programs

Stock purchase opportunities

Qualifications

• 10+ years in IT with expertise in data architecture and management.
• Proficient in cloud technologies and data modeling for enterprise systems.
• Strong communication skills for executive-level presentations.

Responsibilities

• Establish data standards and best practices for OLTP and OLAP systems.
• Design solutions for data migration and database optimization.
• Troubleshoot complex technical problems in data platforms.

Skills

Enterprise data architecture

Data Modelling

Data management

Data strategy

Cloud database technologies

Data Quality

Data Lineage

Data Catalogs

Performance optimization

Business Intelligence

Data governance

Data engineering

Streaming data ingestion

Communication skills

Education

Bachelor's degree in relevant field

Microsoft Azure Data Engineer certification

Tools

Azure Data Platform

MongoDB

PostgreSQL

Azure Data Factory

Power BI

Databricks

Job description

Our not-so-secret sauce.

Award-winning, inclusive, Top Workplace culture doesn’t happen overnight. It’s a result of hard work by extraordinary people. More than 11,000 of the industry’s brightest talent drive our efforts to deliver purposeful work and meaningful impact every day. Learn more about what makes us different and how you can thrive as a Senior Data Architect at Marsh McLennan Agency (MMA).

MMA provides business insurance, employee health & benefits, retirement, and private client insurance solutions to organizations and individuals seeking limitless possibilities. With 200 offices across North America, we combine the personalized service model of a local consultant with the global resources of the world’s leading professional services firm, Marsh McLennan (NYSE: MMC).

A day in the life.

As a Senior Data Architect on the Data team, you’ll 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. You will define reference data architecture and work with agile teams to ensure the documented best practices are used in data platform development. Additionally, you’ll 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. You will also design, develop, and troubleshoot highly complex technical problems in OLAP/OLTP/DW, Analytics, and provide solutions for Enterprise-level Applications utilizing Azure Data Platform.

Our future colleague.

We’d love to meet you if your professional track record includes these skills:

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

These additional qualifications are a plus, but not required to apply:

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

We know there are excellent candidates who might not check all of these boxes. Don’t be shy. If you’re close, we’d be very interested in meeting you.

Valuable benefits.

We value and respect the impact our colleagues make every day both inside and outside our organization. We’ve built a culture that promotes colleague well-being through robust benefit programs and resources, encourages professional and personal development, and celebrates opportunities to pursue the projects and causes that give colleagues fulfillment outside of work.

Some benefits included in this role are:

1. Generous time off, including personal and volunteering.
2. Tuition reimbursement and professional development opportunities.
3. Remote work.
4. Charitable contribution match programs.
5. Stock purchase opportunities.

To learn more about a career at MMA, check us out online: http://marshmma.com/careers or flip through our recruiting brochure: https://bit.ly/3Qpcjmw

Follow us on social media to meet our colleagues and see what makes us tick:

1. https://www.instagram.com/lifeatmma/
2. https://www.facebook.com/LifeatMMA
3. https://www.linkedin.com/company/marsh-mclennan-agency/

Who you are is who we are.

We embrace a culture that celebrates and promotes the many backgrounds, heritages, and perspectives of our colleagues and clients. We are always seeking those with ethics, talent, and ambition who are interested in joining our client-focused teams.

Marsh McLennan and its affiliates are EOE Minority/Female/Disability/Vet/Sexual Orientation/Gender Identity employers.

The applicable base salary range for this role is $113,000 to $197,800.

The base pay offered will be determined on factors such as experience, skills, training, location, certifications, education, and any applicable minimum wage requirements. Decisions will be determined on a case-by-case basis. In addition to the base salary, this position may be eligible for performance-based incentives.

We are excited to offer a competitive total rewards package which includes health and welfare benefits, tuition assistance, 401K savings and other retirement programs as well as employee assistance programs.

Applications will be accepted until: May 19, 2025.