Senior Data Engineer – IAM
Are you a highly skilled Data Engineer with deep expertise in SQL, data warehousing, and automated data pipelines—paired with a passion for strengthening Identity & Access Management (IAM) capabilities? This role offers an exciting opportunity to contribute to enterprise-wide IAM governance by delivering data-driven insights that directly enhance security posture and reduce operational risk.
Working with one of our top financial clients, this position calls for a Senior Data Engineer – IAM who will support the Governance & Analytics team in building automated pipelines, optimizing data environments, enabling accurate reporting, and integrating data across multiple platforms. The ideal candidate will bring strong SQL development skills, hands-on data engineering experience, and familiarity with IAM platforms such as SailPoint to drive secure, scalable, and reliable data solutions within an agile environment.
Responsibilities:
- Develop automated data pipelines and data stores from multiple enterprise systems, including design, implementation, testing, debugging, and deployment.
- Write complex SQL queries, stored procedures, and scripts for data transformation, manipulation, and retrieval.
- Build metadata-driven, reusable, and highly configurable data solutions.
- Optimize data warehouse performance through effective data modeling, indexing, and partitioning strategies.
- Lead the design and implementation of ETL processes.
- Collaborate with system owners and stakeholders to gather data requirements and deliver accurate reporting and analytical outputs.
- Ensure data integrity, compliance, and security across all data environments.
- Work within an Agile team to iterate quickly and release high-quality solutions.
- Research and propose new tools, processes, and automation opportunities to improve data engineering efficiency.
- Provide technical troubleshooting and support to internal teams on warehouse and pipeline issues.
- Stay current with new data engineering capabilities and continuously enhance data warehouse functionality.
- Develop and maintain documentation for processes, architecture, systems, and procedures.
- Design, develop, and maintain a scalable data lake environment supporting efficient data storage and processing.
- Implement data governance and data quality practices to ensure accuracy, consistency, and reliability.
- Integrate the data warehouse with cloud-based and on-premises platforms and data sources.
Desired Skill Set:
- 8+ years of in-depth experience with advanced SQL and complex data manipulation.
- 8+ years of strong experience with data warehousing environments
- 8+ years of proven Java development experience
- 5+ years of experience processing and storing multiple data formats, including CSV, XML, JSON, XLSX, etc.
- 2+ years of hands-on SailPoint experience with BeanShell scripting
- Strong oral and written communication skills with the ability to simplify technical concepts for business stakeholders.
Nice to Have:
- 1+ years of PowerShell scripting experience.
- Exposure to broader IAM concepts, data governance, or cloud data platforms.
BeachHead is an equal opportunity agency and employer. We advocate for you and welcome anyone regardless of race, color, religion, national origin, sex, physical or mental disability, or age.
Privacy Policy