Informatica IDMC & Snowflake Administrator

Alvarez & Marsal

Chicago (IL)

Sur place

USD 125 000 - 155 000

Plein temps

Il y a 12 jours

Obtenez une réponse de cet employeur

Votre CV et votre lettre de motivation, adaptés exactement à ce que l’employeur recherche.

Passez les filtres ATS

Résumé du poste

Alvarez & Marsal (A&M) is seeking a skilled Snowflake and IDMC administrator in the Chicago area to manage RBAC/DAC, runtime environments, and connectors across data platforms. The role focuses on secure, reliable data operations with governance and cost optimization.

Ideal candidates have 3+ years administering Snowflake and IDMC/IICS, with SQL, REST APIs, and CI/CD experience. Familiarity with Databricks and Azure data services is a plus. Must be authorized to work in the US.

Qualifications

  • 3+ years administering Snowflake with RBAC/DAC and performance tuning.
  • Hands-on IDMC/IICS administration across orgs, Secure Agents, connectors, schedules, asset migration, monitoring.
  • Exposure to Databricks and Azure data services is a plus.
  • Proficient in Snowflake security model, SQL, and administrative tooling.
  • Experience with REST APIs and IDMC Administrator services.

Responsabilités

  • IDMC Organization & Access Management: manage orgs, licenses, settings, and roles.
  • Enforce trusted IP ranges and SAML/SCIM; review audit logs and metering reports.
  • IDMC Runtime & Connectivity: deploy Secure Agents, groups, upgrades, logs.
  • Configure connectors (Snowflake, REST, cloud storage) and tracing for integrations.
  • Govern projects, manage permissions; CI/CD for data assets; asset migrations.
  • Monitor tasks and performance with Operational Insights; handle alerts.
  • Snowflake Admin & Security: design RBAC, grants, ownership; manage warehouses.
  • Performance & Cost: optimize warehouses, caching, query patterns; cost reporting.
  • Automation & APIs: use IDMC REST APIs; script grants/roles; run jobs.
  • Compliance & Governance: support audits and data governance across platforms.

Connaissances

Snowflake administration
IDMC/IICS administration
RBAC/DAC
SQL
REST APIs
CI/CD
Databricks integration
Azure data services
SAML/SCIM
Networking basics

Outils

Administrative tooling

Description du poste

Description
About Alvarez & Marsal

Alvarez & Marsal (A&M) is a global consulting firm with entrepreneurial, action and results-oriented professionals. We take a hands-on approach to solving our clients' problems and assisting them in reaching their potential. Our culture celebrates independent thinkers and doers who positively impact our clients and shape our industry. The collaborative environment and engaging work—guided by A&M's core values of Integrity, Quality, Objectivity, Fun, Personal Reward, and Inclusive Diversity—are why our people love working at A&M.

The Team

Own administration of Informatica Intelligent Data Management Cloud (IDMC) and Snowflake to ensure secure, reliable, and cost-efficient data operations. Scope includes org/user/role governance, runtime environments, connectivity, asset migration, scheduling/monitoring, Snowflake RBAC and security, performance optimization, incident response, and automation aligned with data platform best practices.

How you will contribute
  • IDMC Organization & Access Management
  • Administer master/sub-organizations, licenses, global settings, and regional provisioning; implement role-based and fine-grained permissions, user groups, and custom roles per service.
  • Enforce trusted IP ranges, SAML/SCIM where applicable; analyze audit/activity logs and metering reports for governance.
  • IDMC Runtime & Connectivity
  • Deploy and manage Secure Agents, agent groups, firewall/proxy settings, upgrades, and logs across runtime environments (including serverless where appropriate).
  • Configure connectors and connections (e.g., Snowflake, REST, cloud storages), manage dependencies and tracing for integrations.
  • IDMC Asset & Operations Management
  • Govern projects, tags, object-level permissions; implement CI/CD using Asset Management CLI, RunAJob Utility, and source control; orchestrate schedules and blackout periods; perform import/export/bundle migrations.
  • Monitor tasks and performance using Operational Insights; manage alerts and troubleshoot common issues.
  • Snowflake Administration & Security
  • Design and maintain Snowflake RBAC: system roles (ORGADMIN, ACCOUNTADMIN, SECURITYADMIN, USERADMIN, SYSADMIN, PUBLIC), custom role hierarchies, grants, and ownership models across accounts, databases, schemas, tables, stages, and other securable objects.
  • Provision users/roles, enforce least privilege, manage warehouses and resource monitors, and align DAC/RBAC governance for multi-team environments.
  • Performance, Reliability, and Cost Optimization
  • Monitor Snowflake performance and usage; optimize warehouses, caching, and query patterns; support integration with broader data operations (e.g., Databricks/Azure) when applicable.
  • Track IDMC metering/IPU usage and Snowflake consumption; implement controls to balance cost, SLAs, and throughput.
  • Automation & APIs
  • Utilize IDMC REST APIs for org, user, schedule, audit log queries; script Snowflake grants/role/user management and environment setup.
  • Compliance & Governance
  • Support audits, data governance, and policy enforcement across platforms; ensure alignment to organizational security/compliance standards.
Qualifications
Experience
  • 3+ years administering Snowflake (roles, grants, warehouses, RBAC/DAC, performance).
  • Hands-on IDMC/IICS administration across orgs, Secure Agents, connectors, schedules, asset migration, and monitoring.
  • Exposure to integrations in modern data stacks (e.g., Databricks, Azure data services) is a plus.
  • Technical Skills
  • Snowflake security model (system/custom roles, role hierarchies, privileges, ownership), SQL, and administrative tooling.
  • IDMC Administrator service: user/role management, runtime environments, connectors, asset management CLI, RunAJob, Operational Insights, REST APIs.
  • Networking basics for Secure Agents (firewall/proxy), identity integrations (SAML/SCIM), and CI/CD for data assets.
Soft Skills
  • Cross-functional collaboration with data engineering, analytics, security, and operations teams; strong troubleshooting and communication.
Success Metrics
  • Robust RBAC/DAC enforcement and auditability across IDMC and Snowflake.
  • Stable, performant runtime environments and integrations with minimal incident MTTR.
  • Efficient asset lifecycle and deployment pipelines; predictable schedules and migration outcomes.
  • Optimized compute and metering costs with clear consumption reporting.
  • Preferred Certifications/Training
  • Informatica IDMC/IICS Administrator training (Administration Fundamentals; February 2025 release overview).
  • Snowflake role/access control best practices familiarity; formal Snowflake training or certification beneficial.
Your journey at A&M

We recognize that our people are the driving force behind our success, which is why we prioritize an employee experience that fosters each person’s unique professional and personal development. Our robust performance development process promotes continuous learning, rewards your contributions, and fosters a culture of meritocracy. With top‑notch training and on‑the‑job learning opportunities, you can acquire new skills and advance your career.

We prioritize your well-being, providing benefits and resources to support you on your personal journey. Our people consistently highlight the growth opportunities, our unique, entrepreneurial culture, and the fun we have together as their favorite aspects of working at A&M. The possibilities are endless for high‑performing and passionate professionals.

Regular employees working 30 or more hours per week are also entitled to participate in Alvarez & Marsal Holdings’ fringe benefits consisting of healthcare plans, flexible spending and savings accounts, life, AD&D, and disability coverages at rates determined periodically as well as a 401(k) retirement savings plan. Provided the eligibility requirements are met, employees will also receive an annual discretionary contribution to their 401(k) retirement savings plan from Alvarez & Marsal. Additionally, employees are eligible for paid time off including vacation, personal days, seventy‑two (72) hours of sick time (prorated for part time employees), ten federal holidays, one floating holiday, and parental leave. The amount of vacation and personal days available varies based on tenure and role type. Click here for more information regarding A&M’s benefits programs.

Thesalaryrange is $125,000- $155,000 annually, dependent on several variables including but not limited to education, experience, skills, and geography. In addition, A&M offers a discretionary bonus program which is based on a number of factors, including individual and firm performance. Please ask your recruiter for details.

Must be authorized to work in the US without the need for employment‑based sponsorship now or in the future. A&M will not sponsor applicants for US work visa status for this role.

Obtenez votre examen gratuit et confidentiel de votre CV.

ou faites glisser et déposez votre fichier ici.

Similar jobs

Postes similaires à comparer

Informatica IDMC & Snowflake Administrator
Informatica IDMC & Snowflake Administrator

Alvarez & Marsal • Nashville (TN)

Sur place
USD 125 000 - 155 000
Healthcare plans
401(k) plan
Paid time off
Informatica IDMC & Snowflake Administrator
Informatica IDMC & Snowflake Administrator

Alvarez & Marsal • Tampa (FL)

Sur place
USD 125 000 - 155 000
401(k) retirement savings plan
Informatica IDMC & Snowflake Administrator
Informatica IDMC & Snowflake Administrator

Alvarez & Marsal • New York (NY)

Sur place
USD 125 000 - 155 000
Healthcare plans
401(k) retirement plan
Paid time off
Informatica IDMC & Snowflake Administrator
Informatica IDMC & Snowflake Administrator

Alvarez & Marsal • Houston (TX)

Sur place
USD 125 000 - 155 000
Healthcare plans
401(k) retirement plan
Paid time off
Informatica IDMC & Snowflake Administrator
Informatica IDMC & Snowflake Administrator

Alvarez & Marsal • Charlotte (NC)

Sur place
USD 125 000 - 155 000
401(k) plan
Healthcare benefits
Paid time off
Informatica IDMC & Snowflake Administrator
Informatica IDMC & Snowflake Administrator

Alvarez & Marsal • Dallas (TX)

Sur place
USD 125 000 - 155 000
Healthcare plans
401(k) Retirement plan
Paid time off
+1
Informatica IDMC & Snowflake Administrator
Informatica IDMC & Snowflake Administrator

Alvarez & Marsal • Atlanta (GA)

Sur place
USD 125 000 - 155 000
Healthcare plans
401(k) retirement savings plan
Paid time off
Manager, IQx Digital Finance
Manager, IQx Digital Finance

Alvarez & Marsal • New York (NY)

Sur place
USD 170 000 - 190 000
Bonus program
401(k) retirement plan
Healthcare benefits
Manager, National Security-Cybersecurity Governance
Manager, National Security-Cybersecurity Governance

Alvarez & Marsal • New York (NY)

Sur place
USD 100 000 - 140 000
Healthcare plans
401(k) retirement plan
Paid time off
Director - Digital Transformation & Finance Modernization
Director - Digital Transformation & Finance Modernization

Alvarez & Marsal • Chicago (IL)

Sur place
USD 200 000 - 225 000
Healthcare plans
401(k) savings
Paid time off
+3