.req id: 123554remote position: hybridregion: americascountry: mexicostate/province: nuevo leoncity: monterrey*general overview*:*functional area*:information technology (itm)*career stream*: it solutions (soln)*role*:specialist (spe)*job title*:specialist, it solutions*job code*:spe-itm-soln*job level*: band 8*direct/indirect indicator*: indirect*summary*:*this role requires strong programming skills, particularly in python, and loads data from different sources including azure storage accounts, flat files, api, sql db, etc.
*detailed description*:performs 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.
*knowledge/skills/competencies*:- *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