Location: Monterrey, NLE, MXFunctional Area: Information Technology (ITM)Career Stream: IT Solutions (SOLN)Role: Specialist (SPE)Job Title: Specialist, IT SolutionsJob Code: SPE-ITM-SOLNJob Level: Band 8Direct/Indirect Indicator: IndirectSummaryThe successful candidate is an experienced Data Lake developer with expertise in SQL and Python for Jupyter Notebooks, and has the ability to transform large volumes of data following the principles of ETL. The ideal candidate is a motivated self-starter with excellent programming/debugging skills, strong communication skills with the ability to collaborate with stakeholders to refine business requirements and translate into a detailed technical specification.Detailed DescriptionPerforms tasks such as, but not limited to, the following:Advanced Microsoft SQL, Azure Synapse or Azure Data Factory skills, including proficiency with stored procedure and trigger development, schema management, and execution plan optimization.Capable of constructing resilient data integration processes with an emphasis on data quality management and failure-response planning.Expertise in ETL principles.Experience extracting data from heterogeneous sources, including databases, CRM systems, flat file, web services, storage accounts, etc.Experience transforming the extracted data involving cleaning, aggregating, mapping, and converting it to ensure it meets the business requirements and is in a suitable format for analysis.Experience loading the transformed data into a target database, data warehouse, or data lake, making it accessible for querying and analysis.Experience integrating Azure Data Factory patterns, processes, components, security, linked services, datasets, activities and pipelines, and integration runtimes.Maintain documentation of software architecture, processes, and code.Strong communication skills. Able to work with stakeholders and customers to come up with requirements, sizing.Python: Write clean, scalable, and maintainable code following best practices.Knowledge of scripting, Forms and web services is an added advantage.Pandas, NumPy: Data manipulation and analysis.SQL: Ability to extract, transform, and load (ETL) data from relational databases.Other: Familiarity with Azure Datalake (Synapse Workspace).Experience with TFS, GIT, Azure DevOps or any other source control system.Excellent communication skills for explaining technical complexities.Ability to work in a collaborative, cross-functional environment.Skill in managing data projects independently.Abstract Thinking: Advanced problem-solving abilities.Problem-Solving: Proven experience in troubleshooting and optimizing code.Punctuality: Reliable and disciplined in managing project timelines.Communication Skills: Clear in explaining Code and their business impact.International Experience: Ability to work effectively in international and diverse teams across different geographies. This is a multinational company, and it may require having late night meetings to connect with team members or business users from the Asia geography.Production Support: Weekend on-call support is required.Physical DemandsDuties of this position are performed in a normal office environment.Duties may require extended periods of sitting and sustained visual concentration on a computer monitor or on numbers and other detailed data. Repetitive manual movements (e.g., data entry, using a computer mouse, using a calculator, etc.) are frequently required.Typical Experience5+ years of practical experience with Azure Data Lake / Data Engineering or similar role.Typical EducationEducational Requirements may vary by Geography.NotesThis job description is not intended to be an exhaustive list of all duties and responsibilities of the position. Employees are held accountable for all duties of the job. Job duties and the % of time identified for any function are subject to change at any time.Celestica is an equal opportunity employer. All qualified applicants will receive consideration for employment and will not be discriminated against on any protected status (including race, religion, national origin, gender, sexual orientation, age, marital status, veteran or disability status or other characteristics protected by law). At Celestica we are committed to fostering an inclusive, accessible environment, where all employees and customers feel valued, respected and supported. Special arrangements can be made for candidates who need it throughout the hiring process. Please indicate your needs and we will work with you to meet them.COMPANY OVERVIEW:Celestica (NYSE, TSX: CLS) enables the world's best brands. Through our recognized customer-centric approach, we partner with leading companies in Aerospace and Defense, Communications, Enterprise, HealthTech, Industrial, Capital Equipment and Energy to deliver solutions for their most complex challenges. As a leader in design, manufacturing, hardware platform and supply chain solutions, Celestica brings global expertise and insight at every stage of product development – from drawing board to full-scale production and after-market services for products from advanced medical devices, to highly engineered aviation systems, to next-generation hardware platform solutions for the Cloud. Headquartered in Toronto, with talented teams spanning 40+ locations in 13 countries across the Americas, Europe and Asia, we imagine, develop and deliver a better future with our customers.Celestica would like to thank all applicants, however, only qualified applicants will be contacted.Celestica does not accept unsolicited resumes from recruitment agencies or fee based recruitment services.
#J-18808-Ljbffr