Senior Data Engineer (Snowflake/ Informatica) at Alliant Energy in Madison, Wisconsin

Job Description:

Bring YOUR energy to Alliant Energy!



At Alliant Energy, our purpose is to serve customers and build stronger communities. We are passionate about powering beyond the market challenges of today, while powering what's next in energy. When our employees say "I am energy", it means they take pride in the work we do when disaster strikes, as well as all the days in between. We want you to be safe, happy and healthy. That's why we prioritize safety, offer volunteer opportunities and provide competitive pay, comprehensive health and retirement benefits, tuition reimbursement and paid time off.



Alliant Energy is seeking a Senior Data Engineer (Snowflake/ Informatica) to play a crucial role in advancing the data and analytics practices within the organization. In this role, you will lead the design, development, implementation, enhancement, and maintenance of data pipelines across multiple technology platforms. Your expertise in Snowflake, Informatica, Python and modern data practices will be instrumental in driving data driven capabilities and ensuring alignment with evolving analytics requirements.


You have superb communication skills to articulate technical concepts to non-technical partners and collaborate effectively across teams. Conduct in-depth data needs analysis, capture requirements, and define detailed specifications. You will also implement and govern Data Management best practices and proactively recommend approaches and solutions.



*This is a hybrid position reporting to either the Cedar Rapids, IA or Madison, WI office.




What you will do

• Builds and maintains integrations using Agile principles and processes.
  
  


• Relying on general direction from a manager, ensures systems are operating as designed, evaluates system processes and procedures, assesses requests for changes to integrations, develops recommendations to tackle problems and issues related to business system operations, and makes decisions involving detailed knowledge of operational issues.
  
  


• Typically works on new, and less-defined application projects to assess and refine user stories, formulate, and communicate solutions, develop test plans, conduct testing, and implement systems and system improvements.
  
  


• Communicate customer requirements into user stories using Agile tools.
  
  


• Communicates methods for using technology to improve business processes.
  
  


• Regularly provides mentorship to less expert analysts.
  
  


• Reviews the statement of work and assists in developing technology road maps.
  
  


• Develops and evaluates the efficiency of system controls, e.g., reports and queries, modifying the controls and procedures as appropriate.
  
  


• Handles inquiries regarding the technical aspects of Integrations by aiding and coordinating work with IT staff and other business units.
  
  


• Designs and implements solutions to provide functional and end-user support including end-user assistance, system maintenance, and fixes.
  
  


• Documents procedures and maintains corporate compliance with mandated regulations by leading and in some cases owning the development, review, and update of appropriate policies, procedures, and standards, e.g., Sarbanes-Oxley Act (SOX) compliance.
  
  


• Supports on-call activity for system support needs.
  
  


• Engages in other duties as needed that support Alliant Energy's Values and helps deliver on our Purpose to serve customers and build stronger communities.
  
  

Required Experience

• 5 years of related experience.
  
  

Preferred Experience

• Bachelor's Degree Emphasis in information technology or related area.
  
  


• Experience implementing Data warehouse, 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 - data modeling, ELT using Snowflake SQL, implementing complex stored Procedures and standard DWH and ETL concepts.
  
  


• Experience with Informatica, DBT Core, and CI/CD preferred.
  
  

Key Skills

• Agile Methodology
  
  


• API Integration
  
  


• Artificial Intelligence
  
  


• Cloud Architectures
  
  


• Cloud Computing
  
  


• Data Integration
  
  


• Data Modeling
  
  


• SQL Proficiency
  
  

#LI-NR1


#LI-Hybrid



It's not just what we do; it's how we do it.



Live Safety. Everyone. Always | Make Things Better | Care For Others | Do The Right Thing | Act For Tomorrow | Think Beyond. Be Bold


Alliant Energy is committed to providing an inclusive work environment for all and is proud to be an Equal Opportunity Employer where an applicant's qualifications are considered without regard to race, color, religion, sex, national origin, age, disability, veteran status, sexual orientation, gender identity or expression, or any other basis prohibited by law.


All candidates selected for employment with Alliant Energy will be required to successfully complete a drug screen and background check.


Disclaimer:
The above information on this description has been crafted to indicate the general nature and level of work performed by employees within this classification. It is not crafted to contain or be interpreted as a comprehensive inventory of all duties, responsibilities and qualifications required of employees assigned to this job.


Alliant Energy and subsidiaries is an equal opportunity employer that values diversity in the workplace. Applicants in need of a reasonable accommodation for any part of the hiring process, please email talent@alliantenergy.com. Apply Now