Sr Lead Data Systems Engineering
On-siteAustin, Texas, United States or Malta, New York, United States
Job Summary
Lead complex, cross-functional data engineering projects by designing, building, and optimizing enterprise data infrastructure and pipelines for GlobalFoundries Fabs in Dresden, the US, and Singapore. Act as a subject matter expert for Ab Initio, data warehouse design, and cloud data platform integration while providing technical leadership to engineering and support teams. Evaluate access control processes, create technical documentation, and mentor junior engineers on design standards and frameworks. Manage analytics platforms and perform root cause analysis for production data pipelines, including incident triage, SLA management, and job recovery.
Required Qualifications
- Experience in preparing Data warehouse design artifacts based on given requirements – Defining Standards, Building Frameworks, and Source-Target Mapping
- Strong analytical and data modeling skills including logical and physical schema design
- Deep understanding of database technology and data use within analytic platforms
- Hands-on expertise in Ab Initio GDE, Co>Operating System, EME, Conduct>It, Express>It, DML, XFR, multifile systems, and graph parameterization for enterprise-scale ETL development and support
- Experience owning production data pipelines, including incident triage, SLA management, root cause analysis, job recovery, restartability, scheduling coordination, and operational handoff to support teams
- Experience with AWS cloud Services including EMR, Redshift/Postgres
- Experience with other cloud and ETL technologies, including Databricks, Snowflake, and Ab Initio
- Good Understanding of other programming languages Python, Java
- Proven experience with large, complex database projects in environments producing high-volume data
- Strong understanding of data governance practices, including metadata management, lineage, auditability, access control, data retention, and secure handling of sensitive enterprise data
- Demonstrated Problem solving skills; familiarity with various root cause analysis methods; experience in documenting identified problems and determined resolutions
- Experience analyzing performance issues and tuning large-scale data pipelines, SQL workloads, ETL graphs, and database processes
- Perform all activities in a safe and responsible manner and support all Environmental, Health, Safety & Security requirements and programs
Desired Qualifications
- Master's degree in information technology, Electrical Engineering or similar relevant fields
- Minimum 15 years of experience in data warehouse design, ETL development, build activities, performance tuning, and optimization
- Very good knowledge of data warehouse architecture approaches and trends, and high interest to apply and further develop that knowledge, including understanding of Dimensional Modelling and ERD design approaches
- Experience in developing streaming applications Spark Streaming, Flink, Storm, etc
- Excellent conceptual abilities compared with very good technical documentation skills, e.g. ability to understand and document complex data flows as part of business / production processes
- Familiarity with SDLC concepts and processes
- Experience in semiconductor / High Tech Manufacturing industry
- Experience with reporting data solutions and business intelligence tools
- Knowledge of statistical data analysis and data mining
- Experience in test management, test case definition and test processes
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.