Job description

JOB DESCRIPTION:

• Provide centralized data services for Digital solutions teams – data scientists, business users with NoSQL and Big Data platforms, hybrid cloud, and BI tools.
• This position will cover multiple data driven projects encompassing data requirements gathering, discovery, pipeline design, data modeling, DDL release, and query tuning.
• Must be able to work independently, acting as the lead expert in data, and work with business analysts, project managers, architects, app developers and data engineers to deliver the results on time and with quality.

RESPONSIBILITIES:

• Mercer Data & Analytics COE is looking a senior data architect, with strong technical background as well as leadership qualities, to fill in as the leader of the data platform.
• Oversee the development and maintenance of a centralized data platform with latest big data and advanced analytics technology deployed globally on premise and on major public clouds.
• Oversee a pool of 50+ contingent data professionals developing and supporting 20+ projects and products on the platform.
• Define and maintenance operation standards on the platform.
• Improve the way data assets are managed and working with business to find new ways to monetize data.
• Provide centralized data services for Digital solutions teams – data scientists, business users with NoSQL and Big Data platforms, hybrid cloud, and BI tools.
• This position will cover multiple data driven projects encompassing data requirements gathering, discovery, pipeline design, data modeling, DDL release, and query tuning.
• Must be able to work independently, acting as the lead expert in data, and work with business analysts, project managers, architects, app developers and data engineers to deliver the results on time and with quality.

QUALIFICATIONS:

• 10+ years of experience working with data and 7+ years as a data architect.
• Broad knowledge and experience with relational, NoSQL and Big Data concepts, environments, and common products
• Solid background with SQL and SQL-like query languages, as well as various types of schema (Relational, Json, AVRO, etc.)
• 5+ years’ experience with common data modeling tools, such as Erwin, and conversion between various types of schema
• Expertise in Big Data (knowledge and background) is required, including Hadoop platform (HDFS, Hive, etc.), and other query engines, such as Presto.
• Experience delivering data solutions in the cloud (AWS / Azure)
• Good documentation and verbal communication skills
• Must be a dedicated team member who can handle various projects.

Job Type: Full-time

Salary: From $150,000.00 per year

Benefits:

• 401(k)
• Health insurance
• Paid time off

Schedule:

• Monday to Friday

Ability to commute/relocate:

• New York, NY 10001: Reliably commute or planning to relocate before starting work (Required)

Application Question(s):

• How many years of SQL experience do you have?

Experience:

• Data modeling: 4 years (Preferred)

Work Location: One location

gatheringourvoice.org is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, gatheringourvoice.org provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, gatheringourvoice.org is the ideal place to find your next job.