Lead ETL Architect developing, testing, and deploying solutions at S&P Global. Collaborating with teams and optimizing data processes in an environment focused on essential intelligence.
Responsibilities
Own the technical ETL delivery for various data migration projects.
Design, develop, test, and deploy ETL and CDC solutions.
Maintain and optimize database systems.
Collaborate with other teams to integrate systems.
Develop and maintain code using IICS.
Monitor and debug published processes.
Write performance-efficient complex SQL queries and tune existing queries.
Manage a small team of technical resources.
Serve as an escalation point for less experienced developers.
Requirements
Senior-level experience in developing, testing, and deploying ETL and/or CDC solutions (utilizing Informatica Intelligent Cloud Services).
5+ years of experience with ETL tools, like Informatica, Tableau, Power BI, AWS Clue, etc.
Strong database programming skills.
Ability to effectively lead, train, and mentor less experienced developers.
Experience with Data warehouse technologies including ETL Data transformations.
Experience in best practices design of ETL implementations in a high-volume environment, including ETL software, database, and tuning.
Experience in best practices design of CDC implementations in a high-volume environment, including CDC software, database, and tuning.
Strong communication and collaboration skills.
Proficient with software development lifecycle (SDLC) methodologies such as Agile.
Experience in writing performance-efficient complex SQL queries and tuning existing queries.
Benefits
Health & Wellness: Health care coverage designed for the mind and body.
Flexible Downtime: Generous time off helps keep you energized for your time on.
Continuous Learning: Access a wealth of resources to grow your career and learn valuable new skills.
Invest in Your Future: Secure your financial future through competitive pay, retirement planning, a continuing education program with a company-matched student loan contribution, and financial wellness programs.
Family Friendly Perks: It’s not just about you. S&P Global has perks for your partners and little ones, too, with some best-in-class benefits for families.
Beyond the Basics: From retail discounts to referral incentive awards—small perks can make a big difference.
Senior Analytics Engineer at Simply Business designing data models and building infrastructure for AI and ML enhancement. Collaborating with engineering and product teams to integrate new data sources.
Data Analytics Engineer focused on building ETL pipelines and data models at Prodigy Finance. Working with AWS Redshift, Python, and SQL in a hybrid team.
Data Analytics Engineer driving innovative data solutions at Northern Trust. Collaborating on architecture, client satisfaction, and technology transformations with a global team in a hybrid role.
Analytics Engineer transforming raw data into actionable insights to support decision - making in data marketing. Working with various data technologies in a hybrid internship role in Paris.
Senior Analytics Engineer developing data pipelines and analytics capabilities for a data - driven analytics company. Collaborating with stakeholders to build trustworthy datasets for impactful decision - making.
Analytics Engineer driving the architecture and scalability of data models and pipelines at Preply. Collaborating across teams to empower data - driven decision - making in education tech.
Analytics Engineer for Customer Product Analytics team at Just Eat Takeaway.com. Enhancing user experience by delivering data - driven insights and optimizing product experience in a hybrid role.
Analytics Engineer transforming raw data into organized datasets. Collaborating with business teams to ensure data quality and governance in Azure environment.
Data Engineer creating scalable data pipelines for Capgemini's analytics solutions using modern ETL tools. Involves data storage and management using platforms like Snowflake and Redshift.
Analytics Engineer blending data analysis, business intelligence, and data engineering for a healthcare software company. Creating dashboards and data models to empower decision - making and improve healthcare outcomes.