Alliant Energy - Madison, WI
posted 2 months ago
Full-time - Senior
Hybrid - Madison, WI
Utilities
About the position
Alliant Energy is seeking a Senior Data Engineer (Snowflake/Informatica) to enhance the data and analytics practices within the organization. This role involves leading the design, development, implementation, enhancement, and maintenance of data pipelines across various technology platforms. The position requires expertise in Snowflake, Informatica, Python, and modern data practices to drive data-driven capabilities and ensure alignment with evolving analytics requirements.
Responsibilities
- Builds and maintains integrations using Agile principles and processes.
- Ensures systems are operating as designed and evaluates system processes and procedures.
- Assesses requests for changes to integrations and develops recommendations to tackle problems related to business system operations.
- Works on new and less-defined application projects to assess and refine user stories, formulate solutions, develop test plans, conduct testing, and implement systems improvements.
- Communicates customer requirements into user stories using Agile tools.
- Communicates methods for using technology to improve business processes.
- Mentors less expert analysts regularly.
- Reviews the statement of work and assists in developing technology road maps.
- Develops and evaluates the efficiency of system controls, modifying controls and procedures as appropriate.
- Handles inquiries regarding the technical aspects of integrations by coordinating work with IT staff and other business units.
- Designs and implements solutions to provide functional and end-user support, including system maintenance and fixes.
- Documents procedures and maintains corporate compliance with mandated regulations, such as Sarbanes-Oxley Act (SOX) compliance.
- Supports on-call activity for system support needs.
- Engages in other duties that support Alliant Energy's values and purpose.
Requirements
- 5 years of related experience.
- Bachelor's Degree with an emphasis in information technology or a related area (preferred).
- Experience implementing Data warehouse and Data lakes in the cloud.
- Proficient in SQL and strong experience in Python.
- Experience with extract and load processes from system sources such as Oracle, SQL Server, flat file, API, etc.
- Working experience with Snowflake, including data modeling, ELT using Snowflake SQL, and implementing complex stored procedures.
- Experience with Informatica, DBT Core, and CI/CD (preferred).
Nice-to-haves
- Experience with Agile Methodology.
- API Integration skills.
- Knowledge of Artificial Intelligence.
- Familiarity with Cloud Architectures and Cloud Computing.
- Data Integration and Data Modeling expertise.
Benefits
- Competitive pay
- Comprehensive health benefits
- Retirement benefits
- Tuition reimbursement
- Paid time off
- Volunteer opportunities
