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.
About the role
- Informatica ETL Developer responsible for designing, developing, and maintaining ETL processes. Joining the Enterprise Data Warehouse team to support healthcare-related data systems.
Responsibilities
- Design and implement ETL solutions using Informatica PowerCenter to extract, transform, and load data from various agency sources.
- Automate data staging processes and optimize ETL job scheduling for performance and efficiency.
- Administer and support ETL environments, including development and production systems.
- Perform repository backups, recovery operations, and system maintenance.
- Develop mappings, mapplets, sessions, and workflows using a wide range of Informatica transformations.
- Monitor and troubleshoot ETL jobs across development, testing, and production environments.
- Write and optimize complex SQL queries and Unix Shell scripts for data marts and interfaces in Teradata.
- Collaborate with stakeholders to define requirements, document technical solutions, and support project planning.
- Participate in unit, integration, and system testing.
- Provide technical support, mentoring, and guidance to team members.
- Communicate project status and deliverables to leadership and clients.
- Continuously learn and apply new technologies to enhance system performance and capabilities.
Requirements
- 7+ years of experience with Informatica PowerCenter and ETL development.
- 5+ years of experience writing complex SQL and performance tuning.
- 5+ years of experience with Enterprise Relational Database Management systems (Teradata, DB2, Oracle, or SQL Server)
- 5+ years of Informatica PowerCenter administration experience.
- Strong communication, collaboration, and mentoring skills.
- Bachelor’s or advanced degree in IT, Computer Science, Mathematics, or a related field.
- Strong organizational and time management skills.
Benefits
- Telecommute (with occasional travel to Springfield, IL, two to three times per year)
Job title
Job type
Experience level
Salary
Not specified
Degree requirement
Tech skills
Location requirements
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.
Lead Web Analytics Developer architecture and implementation of web analytics tools at Hostinger. Collaborate with teams to enhance user experience and improve conversion rates.
Principal managing analytics engineering projects for private equity, leveraging AI technology. Leading cross - functional teams and contributing to business development in a hybrid work environment.
Prototyping analytical tools developed by the engineering and analytics teams for Clir Renewables. Collaborating on automation scripts and methods for renewable energy analysts.
Analytics Engineer Sr developing data pipelines and analytics solutions for Brazil's retail industry. Collaborating with marketing and product teams to optimize data usage and performance.