Informatica IDMC & Snowflake Administrator

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.

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.

• 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, ACCOUNT ADMIN, SECURITY ADMIN, 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.

• 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.

• 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.

• Cross‑functional collaboration with data engineering, analytics, security, and operations teams; strong troubleshooting and communication.

• Robust RBAC/DAC enforcement and auditability across IDMC and Snowflake.
• Stable, performant runtime environments and integrations with minimal incident MTTR.
• Efficient asset lifecycle and…