Federated Mutual Insurance Company

  • Business Intelligence Developer

    Job Locations US-MN-Owatonna
    Job ID 2019-2451
    Information Technology
  • Job Details

    Business Intelligence (BI) developers leverage their data skills to create advanced reporting and database solutions. They work with analysts and business partners to understand process and information needs, to develop functional reporting and data designs, and to implement solutions using Windows SQL Server technologies. As part of the IT team, you primarily serve the needs of property and casualty actuaries by supporting and enhancing data warehouses. Our BI systems aggregate information from numerous sources and provide management information to stakeholders throughout the company. As such, we frequently partner with Underwriting, Claims and other teams to deliver accurate, actionable information to a diverse group of stakeholders.


    • Develop and support mature data warehouse, data mart and reporting solutions
    • Analyze, design, develop, and document BI solutions using internal standards and best practices
    • Design functional specifications for BI front end, including dashboards and reporting
    • Consider appropriate data capture, flow and ETL
    • Design reports according to provided screens and previously created reports
    • Provide and accept peer reviews of code and BI packages
    • Analyze, recommend and coordinate solutions with business and IS stakeholders

    Skills Needed

    • Experience with SQL Server Management Studio
    • Ability to optimize Transactional SQL (TSQL) and MDX queries
    • Experience with Microsoft SQL Server Reporting Services (SSRS), Analysis Services (SSAS), Integration Services (SSIS)
    • Visual Basic syntax and coding skills for use within SSIS
    • Experience with self-service BI applications, including strong Excel and Power Pivot skills
    • Solid grasp of dimensional modeling and data warehousing concepts
    • Experience with OpsWise and Team Foundation Server
    • Optionally, the ability to support COBOL batch components, web service calls and Active Directory elements of the data warehouse
    • Strong technical aptitude, debugging and problem-solving skills
    • Excellent work/task management skills, including the ability to manage multiple tasks simultaneously
    • Ability to ask questions, keep up with technology changes, and contribute to a high-performing team

    About Us

    At Federated Insurance, we do life-changing work, focused on our client's success. For our employees, we provide tremendous opportunities for growth. Over 95% of them believe our company has an outstanding future. We make lives better, and we're looking for employees who want to make a difference in others' lives, all while enhancing their own.


    You will have opportunities to grow in your career. Our employees are encouraged to ask questions and learn on the job, and we are committed to promoting from within. We recognize your contributions with an exceptional rewards package that includes competitive pay and bonus programs, incredibly affordable health insurance, generous pension and 401(k) benefits, and gift matching and paid volunteer time to support your involvement in the community.


    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed

    Need help finding the right job?

    We can recommend jobs specifically for you! Click here to get started.