Senior Data Engineer (Snowflake/ Informatica)

Posted 2 Days Ago
Madison, WI
5-7 Years Experience
Energy
The Role
Alliant Energy is seeking a Senior Data Engineer with expertise in Snowflake, Informatica, and Python to lead the design, development, and maintenance of data pipelines. Responsibilities include building and maintaining integrations, conducting data analysis, implementing data management best practices, and providing mentorship to analysts. This is a hybrid position based in either the Cedar Rapids, IA or Madison, WI office.
Summary Generated by Built In

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 [email protected].

Top Skills

Snowflake,Informatica,Python
The Company
HQ: Madison, WI
2,450 Employees
On-site Workplace
Year Founded: 1917

What We Do

Alliant Energy Corporation (NASDAQ: LNT) is an energy holding company with more than 4,000 employees. Our top priority is providing nearly 953,000 homes, farms, and businesses in Iowa and Wisconsin with safe, reliable energy and power in a variety of sustainable forms. Honored in Newsweek’s 2021 list of America’s Most Responsible Companies.

Our corporate headquarters are located in Madison, Wisconsin. Additional general offices are located in Cedar Rapids and Dubuque, Iowa. We provide inclusive work environments, and are proud to be an Equal Opportunity Employer. We recognize and respect diversity. We appreciate the differences and perspectives a diverse culture brings to the work environment, the company and our customers.

Alliant Energy is a responsible corporate citizen. We are careful stewards of the environment, we support the communities in which we do business and we aggressively pursue emerging technology and safe, sustainable methods of energy production.

Jobs at Similar Companies

UL Solutions Logo UL Solutions

2025 Campus Full Time: Associate Marketing Specialist

Automotive • Professional Services • Software • Consulting • Energy • Chemical • Renewable Energy
Hybrid
Northbrook, IL, USA
15000 Employees
Austin, TX, USA
234 Employees

Energy CX Logo Energy CX

Strategic Account Executive

Greentech • Professional Services • Business Intelligence • Consulting • Energy • Financial Services • Utilities
Easy Apply
Chicago, IL, USA
55 Employees

Similar Companies Hiring

UL Solutions Thumbnail
Software • Renewable Energy • Professional Services • Energy • Consulting • Chemical • Automotive
Chicago, IL
15000 Employees
Energy CX Thumbnail
Utilities • Professional Services • Greentech • Financial Services • Energy • Consulting • Business Intelligence
Chicago, IL
55 Employees
InCommodities Thumbnail
Energy
Austin, TX
234 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account