Senior Data Engineer
We are seeking a seasoned Data Architect and Developer to lead the design, development, and implementation of our data management systems. This individual will be responsible for creating scalable and efficient data pipelines using Informatica Cloud and SSIS, as well as managing data movement between SQL Server, Snowflake, and S3 storage.
* Design and implement ETL processes using Informatica Cloud and SSIS to ensure high-quality and reliable data
* Develop and optimize MS SQL stored procedures, views, and existing code based on evolving business requirements
* Ingest data from various sources including SQL databases, CSV files, and APIs to create centralized, reusable datasets
* Collaborate with stakeholders to design and build datasets and reports in Tableau
* Define and lead reporting requirements, partnering with business users to deliver actionable insights
Requirements:
* Strong expertise in ETL development with Informatica Cloud and SSIS
* Advanced SQL skills across MS SQL Server and Snowflake
* Experience with S3 storage integration for data centralization
* Proven ability to ingest and process data from diverse external sources
* Proficient in Tableau report development and stakeholder engagement