Business Intelligence Software Developer

Business Intelligence Software Developer About Us
Horizon Systems and Services Inc. is a technology and data-driven insurance services company offering a full range of Policy and Claims Administration System products for the Property and Casualty
insurance industry.
We are looking for highly qualified professionals at our corporate headquarters in Sheboygan,
Wisconsin. In addition to providing our customers with superior value and service, we are dedicated to
providing engaging and challenging career opportunities for our employees. As a member of the
Horizon Systems team, we want help you to reach your full potential. Position Summary
The BI Software Developer will deliver analytical applications to the organization that include ETL,
Data Marts, Data Cubes (OLAP), standard reports and other analytical applications as required. The
candidate will assist in assessing Data Architecture for future evolution and change; and assess business needs, recommending new Visualization and Analytic tools as required. Summary of Essential Job Functions
Development: Data Models, ETL and OLAP Cubes - Design and Deploy Dimensional Data Models.
Create Integration Services packages, scripts, and other elements to move data from source systems into the data warehouse. The individual(s) will also utilize data transformation steps to cleanse, aggregate, and summarize data to create star schemas consisting of fact and dimension tables. Report Development - Work in collaboration with the organization to understand business issues,
identify new valuable areas of analysis and develop reports that analyze data warehouse information to
support effective rapid decision-making. Assist in developing and deploying reports using various tools
including Microsoft SSRS, Power BI, Excel, and custom applications. Ad-Hoc Reporting Environment Support - Deploy and maintain reporting models using Microsoft
Visual Studio and SQL Server Reporting services that the business community can leverage for selfservice analysis. Publish and maintain necessary metadata (data dictionary, etc.) to support the selfservice reporting environment. Conduct informal training sessions that foster a solid understanding
within the business community of both the ad-hoc reporting models and reports published through the
reporting dashboard. Production Processing Support - Provide support and troubleshoot issues as needed for the automated
ETL data processing environment. Assess the growing and evolving environment for improvement, and
work with the BI team to enhance process logic. Position Requirements
Bachelor's degree in Math, IT or FinanceThree or more years' experience building Data Warehouse and Business intelligence solutionsExperience working with SQL queries and data processesExperience with SQL Server 2012 or later. Demonstrable experience using Microsoft Business Intelligence technologies: SSAS, SSIS, SSRS, or similar technologiesWorking knowledge with SQL Server, and SQL, MDS/DAX query languagesAbility to work directly in a team environment with a business group to translate business requirements into reporting solutionsKeen interest in understanding business issues through detailed information analysisAbility to comprehend index design and SQL statement optimization techniqueAbility to work in a collaborative environment on complex problemsMust be able to analyze and understand business needs and requirements in order to translate to system specifications and deliverable solutionsShould be able to effectively identify test scenarios in order to assist with systems and user testingAbility to troubleshoot both Code and Data quality issuesGood communication and documentation skillsStrong work ethic and organized work habitsAbility to interface well with business end-users and vendorsFoster company success through a professional, courteous, and positive attitude
Horizon Systems and Services, Inc.is an Equal Opportunity Employer. All qualified applicants will
receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual
orientation, gender identity, national origin, age, protected veteran status, or disability status. Category: Technology , Keywords: Business Intelligence Developer