Analytics Engineer shaping Statista's reporting platform for data - driven decision - making. Focusing on BI tools like Power BI and improving report usability and transparency.
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
Director of Data & Analytics leading data strategy for Reach Financial, enhancing decision - making through a data - driven culture. Guiding a team to innovate and implement scalable data solutions.
Data Scientist creating scalable insights from unstructured data at AI safety company. Collaborating with engineering and research teams in a hybrid Paris location.
Senior Analytics Engineer owning the analytics data platform for parenting technology startup. Requires deep SQL expertise and data pipeline experience in a hybrid role.
Senior Analytics Engineer at Higgsfield AI translating product and finance metrics into data models. Collaborating cross - functionally to ensure consistent, reliable data for decision - making.
Senior Data Analytics Developer for Krux, building data infrastructure for innovative SaaS solutions in mining industry. Collaborating with a self - motivated team to drive company growth.
Lead Risk Analytics Consultant at Wells Fargo focused on model governance and risk management strategies. Collaborate across teams to enhance system stability and mentor junior staff.
Analytics Engineering Lead responsible for building data products at Sanlam Fintech. Overseeing analytics engineering practice modernization and talent development within the organization.
Analytics Engineer foundational technical pillar for Analytics & Data Engineering at Skin + Me, transforming raw data into a strategic engine for growth. Reporting to the Director of Data and optimizing performance across business units.
Senior Analytics Engineer at RB Global designing domain models and leading KPI efforts. Optimizing data performance and mentoring analytics engineers in a hybrid work environment.