Sr Lead Data Systems Engineering

About GlobalFoundries: GlobalFoundries is a leading full-service semiconductor foundry providing a unique combination of design, development, and fabrication services to some of the world’s most inspired technology companies. With a global manufacturing footprint spanning three continents, GlobalFoundries makes possible the technologies and systems that transform industries and give customers the power to shape their markets. For more information, visit . Summary of Role: The Data Solutions Group is responsible for integrating manufacturing and engineering data out of a high variety of source systems used in the semiconductor engineering and production process. The data warehouse solutions are used in the GLOBALFOUNDRIES Fabs in Dresden, in the US and in Singapore, and the Data Solutions Group is responsible to conceptualize and provide timely, high-quality solutions that address analysis needs of engineers in a leading-edge semiconductor foundry Essential Responsibilities: Senior data engineering professional with strong technical solution design expertise, responsible for designing, building, optimizing, and governing enterprise data infrastructure and data pipelines. The role works closely with the Data Product Design team to translate business and design requirements into scalable, secure, and maintainable technical data products, while providing technical leadership and guidance to engineering and support teams. Other Responsibilities: Perform all activities in a safe and responsible manner and support all Environmental, Health, Safety & Security requirements and programs. Responsibilities include: Leading complex, cross-functional data engineering projects, acting as a subject matter expert for Ab Initio, data warehouse design, ETL architecture, and cloud data platform integration. Building data Solution: Creating secure, stable, and scalable data pipelines, managing analytics platforms Design Standards and Framework: Provides appropriate consulting, interfacing, standards and framework for data pipelines, Mentoring junior and mid-level data engineers, guiding implementation partners and operations support teams, reviewing design and code quality, and recommending engineering best practices. Evaluating access control: Evaluating and reporting on access control processes to determine data asset security Developing documentation: Creating technical documentation that supports best practices Required Qualification: 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. Preferred 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 Additional Skill: 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 GlobalFoundries is an equal opportunity employer, cultivating a diverse and inclusive workforce. We believe having a multicultural workplace enhances productivity, efficiency and innovation whilst our employees feel truly respected, valued and heard. As an affirmative employer, all qualified applicants are considered for employment regardless of age, ethnicity, marital status, citizenship, race, religion, political affiliation, gender, sexual orientation and medical and/or physical abilities. All offers of employment with GlobalFoundries are conditioned upon the successful completion of background checks, medical screenings as applicable and subject to the respective local laws and regulations. To ensure that we maintain a safe and healthy workplace for our GlobalFoundries employees, please note that offered candidates who have applied for jobs in India will have to be fully vaccinated prior to their targeted start date . Expected Salary Range The exact Salary will be determined based on qualifications, experience and location. If you need a reasonable accommodation for any part of the employment process, please contact us by email at and let us know the nature of your request and your contact information. Requests for accommodation will be considered on a case-by-case basis. Please note that only inquiries concerning a request for reasonable accommodation will be responded to from this email address. An offer with GlobalFoundries is conditioned upon the successful completion of pre-employment conditions, as applicable, and subject to applicable laws and regulations. GlobalFoundries is fully committed to equal opportunity in the workplace and believes that cultural diversity within the company enhances its business potential. GlobalFoundries goal of excellence in business necessitates the attraction and retention of highly qualified people. Artificial barriers and stereotypic biases detract from this objective and may be illegally discriminatory. All policies and processes which pertain to employees including recruitment, selection, training, utilization, promotion, compensation, benefits, extracurricular programs, and termination are created and implemented without regard to age, ethnicity, ancestry, color, marital status, medical condition, mental or physical disability, national origin, race, religion, political and/or third-party affiliation, sex, sexual orientation, gender identity or expression, veteran status, or any other characteristic or category specified by local, state or federal law