CI Database Specialist (m/f/d)

Air Liquide Global E&C Solutions Germany GmbH is a preferred technology partner for the global planning, design and construction of state-of-the-art process plants and related infrastructure. We enable our customers to optimize the use of our planet's natural resources to deliver clean and sustainable energy through our people and their ability to continuously innovate. Through the pioneering development of our proprietary technologies, we contribute to the transformation of the energy industry, helping to preserve and protect our planet's atmosphere.

 

 

• Pipeline & ETL Management: Own and manage the Google Apps Script-based CI Portfolio Library. Ensure the automated extraction, transformation, and loading (ETL) of monthly reporting data from project templates runs seamlessly via automated, time-based triggers without human intervention.

• Data Governance & Lifecycle: Enforce strict data governance and structural integrity by leveraging validation flags (Hub_Validated, CIG_Validated) and auditing automated modification logs. Manage system performance by routing closed project data into cold-storage Azure containers (portfolio-archive) to avoid Google Sheets cell limits.

• Access Control & Security Architecture: Maintain granular Row-Level Security (RLS) mappings that tie Azure User Principal Names (UPN) to specific data visibility dimensions. Proactively manage backend Google Workspace file permissions to prevent automated script execution failures.

• System Maintenance & Stabilization: Monitor local error logs to diagnose and resolve Apps Script runtime issues, frozen UI popups, and Azure API connection drops. Manually manage system safety locks (e.g., clearing stalled execution timestamps) and keep hardcoded environment parameters (email alerts, Daylight Savings Time arrays) up to date.

 

 

Are you a match?

 

• Advanced Workaround Engineering: Ability to design, implement, and maintain "chained trigger" methodologies to bypass strict platform limitations (such as Google's 6-minute execution limit) and optimize memory constraints when handling massive datasets via getDataRange().getValues().

• Operational Risk & Continuity Management: Competency in managing trigger ownership transfers smoothly during personnel transitions to avoid system-wide operational outages.

• Precision Diagnostics & Troubleshooting.

• Data Transformation Execution: Ability to dynamically map named ranges, transform complex multi-dimensional arrays into flat, CSV-ready records, and execute highly accurate data reconciliation engines

• Education: Bachelor’s Degree or equivalence in work experience. Discipline: Preferably Computer Science, Information Technology, or Data Engineering, alternatively Software Engineering or/and Business Analytics.

• Work Experience: 3-5 years.

• Foreign Language: English, others desirable. Level required: Fluent.

 

What makes us special | Our Benefits ​

 

The CI Database Specialist, is responsible for ensuring the absolute stability, security, and integrity of our Capital Implementation data pipeline and storage infrastructure. This role involves the end-to-end automation architecture that seamlessly extracts, transforms, and loads (ETL) regional project data from Google Sheets source files into Microsoft Azure Blob Storage, powering critical, downstream Power BI dashboards.
This role acts as the primary custodian of this data ecosystem—balancing proactive data governance and strict access control with hands-on technical troubleshooting. By optimizing data flows, managing the data lifecycle, and resolving integration bottlenecks, guaranteeing that leadership has uninterrupted access to reliable, high-fidelity business intelligence without requiring manual human intervention.

 

Our Differences make our Performance

At Air Liquide, we are committed to build a diverse and inclusive workplace that embraces the diversity of our employees, our customers, patients, community stakeholders and cultures across the world.
We welcome and consider applications from all qualified applicants, regardless of their background. We strongly believe a diverse organization opens up opportunities for people to express their talent, both individually and collectively and it helps foster our ability to innovate by living our fundamentals, acting for our success and creating an engaging environment in a changing world.