Detail View

Business Intelligence Developer

Cedar Rapids, IA

Job Information:

Central Iowa Power Cooperative (CIPCO) is currently searching for a Business Intelligence Developer to join the team in Cedar Rapids, IA. This position is responsible for designing, implementing and supporting the company’s databases, data warehouse and the development of business intelligence solutions. This position will apply business intelligence and analytics subject matter expertise (ETL, data modeling, data integration and BI development) to provide the business with the tools and data representations which allow informed organizational decision-making.

  • Partner with CIPCO personnel to understand and document business requirements and translate those into technical specifications for informational needs.
  • Design, develop and maintain database architecture and business intelligence tools.
  • Develop ETL processes to support data integration into data warehouse ensuring high data quality.
  • Systematically implement and support data governance processes ensuring availability, usability, integrity and security to the appropriate personnel.
  • Perform ad hoc data mining from within centralized data warehouse or externally in response to inquiries across departments.
  • Prepare and maintain detailed documentation on database and business intelligence architecture.
  • Troubleshoot and resolve issues relating to database performance and optimization.
  • Ensure databases are adequately maintained, backed up and have proper security settings.
  • Train and mentor employees on business intelligence software and solutions with an end goal of employee self-service.
  • Stay abreast of current database and business intelligence industry trends and emerging opportunities.
  • Continuously gain experience within the technology space, as well as learn aspects of the business to provide data analysis.

Requirements and Critical Success Factors
  • Bachelor’s degree in Information Technology or related discipline with a minimum of 3 years of related experience or equivalent combination of education and experience
  • Experience in writing ETL procedures using SSIS for data integration into SQL database
  • Experience with database and data warehouse designs, data modeling, data integrations, database tuning and business intelligence reporting and visualization tools (SSAS, SSRS, Power BI, Cognos, Crystal Reports)
  • Willingness and ability to collaborate in a team environment and work cross-functionally
  • Excellent problem-solving skills and willingness to think outside-the box
  • Expertise in extracting data from SQL server databases using SQL/T-SQL/MDX queries to retrieve and modify data
  • Self-starter
  • Ability to balance multiple projects with minimal supervision
  • Excellent analytical skills
  • Effective written and verbal communication skills

CIPCO is Iowa's largest cooperative energy provider serving 13 rural electric cooperatives and associations spanning 58 of Iowa's 99 counties. CIPCOs' members distribute power to nearly 300,000 Iowans and more than 12,000 commercial and industrial accounts.

CIPCO is a state-of-the-art energy provider with a diverse fuel mix of coal, nuclear, hydro, wind, solar, landfill gas, natural gas, and oil energy resources. We continue to invest in new technology and renewable energy production, supporting Iowa’s development of renewable energy resources. Over half of our electricity is generated from emission- and carbon-free resources, minimizing the impact to the environment.

CIPCO provides its employees with a comprehensive benefits package which includes: health insurance, dental insurance, vision insurance, pension plan, 401(k) match, short-term disability, long-term disability, life insurance, flexible spending accounts, paid time off, and much more.

Click here to find out why CIPCO is a great place to work!

For more information about CIPCO please visit:

EOE M/F/Disability/Veteran

Posted 01/12/18

Job ID: 63010