The company is a global leader in partnering with businesses to transform and manage their operations by leveraging the power of technology. The group is driven daily by its purpose of unleashing human energy through technology for an inclusive and sustainable future. It is a responsible and diverse organization with 350,000 members in over 50 countries.
The role:
The Unconventional IT Production Applications team delivers industry-leading business capabilities and computational sciences to our field production assets through proprietary, commercial-grade software. We are looking for a self-starting team member who will challenge the status quo and always be willing to learn and contribute in new ways. In this role, you will participate in requirements scoping, development, deployment, and support of production applications and data integration pipelines in service of a diverse customer base.
Primary Job Functions:
● Develop and support data integrations using Oracle and Microsoft SQL leveraging SQL jobs, stored procedures, SSIS packages, Azure Data Factory, Data Bricks, and other industry standard tools.
● Provide ongoing innovative improvements to current ETL processes.
● Troubleshoot data quality issues across 3rd party and custom applications.
Requirements:
● Advanced Microsoft SQL and 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.
● Experience developing system health monitoring solutions with industry standard tools (Spotfire, Power BI, etc.)
● Expertise in ETL principles.
● Experience extracting data from heterogeneous sources, including databases, CRM systems, flat file, web services, 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.
Preferred Knowledge/Skills/Abilities:
● Prior work experience with large scale data management applications.
● Experience in Process Automation.
● Experience with C++ and Python.
● Experience/Familiarity with Agile methodologies (ADO, Scrum, Kanban, etc)
● Excellent communication skills (verbal and written)
Benefits:
● OSDE 210 family health plan.
● Birthday day off.
● Continuous training through content platforms.
And more!
Great, just keep talking to your recruiter.
Apply for this position
If you are already talking to a recruiter from CONEXIONHR, DON'T FILL THE FORM.