Business Intelligence Analyst II

<strong>AF Group (Lansing, Mich.) and its subsidiaries are a premier provider of innovative insurance solutions. Insurance policies may be issued by any of the following companies within AF Group: Accident Fund Insurance Company of America, Accident Fund National Insurance Company, Accident Fund General Insurance Company, United Wisconsin Insurance Company, Third Coast Insurance Company, or CompWest Insurance Company.</strong>

Lansing, USA

AF Group

<p class="p1"><strong>AF Group&rsquo;s focused and passionate team uses industry-leading best practices, analytics and resources to manage risk and minimize loss for our policyholders while strengthening businesses with our valued independent agent partners.</strong></p> <p class="p1"><strong>We strive to continuously increase the long-term value of our organization by outperforming our industry peers and fostering a culture of underwriting and claims excellence.</strong></p>

keywords: summary,job description,work environment,analysis,review,reporting,solutions,coordinate,performance,management,technical,education & experience,knowledge,proficiency,communication,initiative,skills


Competitive Compensation and Benefits Package

Overview: <br />Responsible for analyzing business problems to determine the best way to apply BI capabilities to deliver solutions. Maintains and grows working knowledge of enterprise data assets and data-centric business processes. Assists in the analysis and decomposition of business requirements into technical requirements and testing protocols. Configures BI systems to deliver reports, data visualizations, and other solution components. Provides detailed direction on data handling for data warehousing. Consultant to business units and technical teams for detailed data availability, location, and lineage. Works within the System Development Life Cycle.<br /><br /> <p><strong>WORKING CONDITIONS:</strong></p> <p>Work is performed mainly in an office environment with minimal hazards. Ability to work extended hours as needed. May be exposed to temperatures which may be cooler than a normal office setting. Travel may be required.</p>
Responsibilities: <br /> <ul> <li>Evaluate business requests for new or modified capabilities to determine feasibility, cost and time required, compatibility with current systems, and computer capabilities.</li> <li>Analyze business requirements into technical requirements for reporting/visualizations and data models. Review technical specifications derived from technical requirements.</li> <li>Create and review/approve technical design documents and specifications on change requests and assignments within a project while maintaining documentation and abstracts in conformance with standards.</li> <li>Provide detailed source analysis and data mappings/transformations to BI developers to update existing data sources and integrations.</li> <li>Configure BI systems to deliver BI solutions.</li> <li>Devise and deliver testing plans and testing data to validate BI solutions.</li> <li>Coordinate user testing for acceptance of BI solutions.</li> <li>Deploy and Validate BI solutions ensuring changes follow appropriate Change and Release Management processes.</li> <li>Assist development teams with analysis and design for new or existing systems.</li> <li>Provide consultancy to business units for detailed information on data availability, location, and lineage.</li> <li>Perform data analysis, profiling, and quality assessment.</li> <li>Assist with incident management situations affecting BI capabilities and solutions.</li> <li>Review design proposals of other BI Analysts and vendors; as well as perform reviews on work during various stages of delivery for adherence to current standards.&nbsp;</li> <li>Perform peer reviews and mentor less experienced BI Analysts on solution approaches and ensuring conformity to standards and quality.</li> <li>Work with technical leads and architects to implement new standards, new technology, and tactical solutions driving the business strategy forward.&nbsp;</li> <li>Works within the System Development Life Cycle.</li> <li>Monitor the lifecycle of BI systems by being aware of obsolescence and release dates for the product per the System Development Lifecycle.</li> <li>Review patch and upgrade information and ensure implementation where appropriate.</li> <li>Own problem management process and ensures resolution to completion, including identifying discrepancies between BI systems and developing preventative measures for the long term.</li> <li>Track issues and errors, documenting resolutions.</li> <li>Act as a liaison between the Company and third-party vendors.</li> <li>Demonstrate ability to work under stressful situations and display professional demeanor.</li> <li>Ensure that documentation is available for both administrators and users.</li> <li>Respond to and resolve reported application, data, or tool issues in a timely manner.</li> <li>Identify and resolve application issues using appropriate systems, toolsets, or configuration processes.</li> <li>Raise awareness of application, tool and data issues and resolutions with the Customer and appropriate IS personnel.</li> <li>Maintain knowledge of standards and quality requirements.</li> <li>Periodically participate in groups/committees related to processes, standards and best practices.</li> <li>Maintain and enhance technical abilities through online resources such as manuals, periodicals and white papers.</li> <li>Review program specifications for completeness and conformance to quality standards.</li> <li>Periodically prepare reports for review by project leader/system supervisor.</li> <li>Works with minimum supervision and exercises sufficient discretion and independent judgment.</li> <li>Maintains confidentiality of information processed, as appropriate.</li> <li>Make recommendations to the architecture group and management for future application structure and design.</li> <li>Conducts performance monitoring and tuning of applications, systems and toolsets.</li> </ul> <br /><br /> <p>This position description identifies the responsibilities and tasks typically associated with the performance of the position. Other relevant essential functions may be required.</p>
Requirements: <br /> <p><strong>EDUCATION:<br /><br /></strong></p> <ul> <li>Bachelor&rsquo;s degree in computer science or related field.&nbsp;</li> <li>Combinations of relevant education, certifications, and experience may be considered in lieu of a degree.</li> <li>Continuous learning, as defined by the Company&rsquo;s learning philosophy, is required.&nbsp;</li> <li>Certification or progress toward certification is highly preferred and encouraged.</li> </ul> <br /> <p><strong>EXPERIENCE:&nbsp;<br /></strong></p> <ul> <li>Must have minimum three years relevant experience which provides the necessary skills, knowledge and abilities.</li> </ul> <br /> <p><strong>SKILLS/KNOWLEDGE/ABILITIES (SKA) REQUIRED:&nbsp;<br /><br /></strong></p> <ul> <li>Knowledge of, and the ability to apply, necessary software development practices and procedures.</li> <li>Ability to apply the principles of independent logical thinking to define problems, collect data, establish facts and draw valid conclusions.</li> <li>Ability to comprehend the consequences of various problem situations and to refer them for appropriate decision making.</li> <li>Proficiency in SQL and relational database concepts.</li> <li>Ability to design program logic, prepare test data, and test programs.&nbsp;</li> <li>Ability to review business requirements and compare to application for possible deviations from customer expectations.</li> <li>Experience working with multi-functional teams to perform complex data analysis, data mapping and support a variety of business intelligence, reporting, analytical and data visualization needs.</li> <li>Ability to make competent, independent decisions.</li> <li>Understanding of data warehousing methodology, data modeling, model management, data definition language, ETL, databases, business intelligence, metadata management, data profiling, data quality and their processes.</li> <li>Proven understanding of the SDLC process and project management steps used in IT solutions &ndash; specifically business intelligence solutions.</li> <li>Experience working with mainstream BI reporting systems and data modeling tools.</li> <li>Ability to work under stressful situations and display professional demeanor.</li> <li>Excellent triage, troubleshooting and problem-solving skills.</li> <li>Ability to handle multiple priorities and meet necessary deadlines.</li> <li>Excellent oral and written communication skills.</li> <li>Ability to effectively exchange information clearly and concisely, and present ideas, report facts and other information, and respond to questions as appropriate.</li> <li>Ability to maintain confidentiality.</li> <li>Ability to perform other assignments at locations outside the office.</li> <li>Ability to work varying hours, including evenings, weekends and holidays as required.</li> <li>Understand the need for, and display, a strong sense of urgency while maintaining a high level of quality.</li> </ul> <br /><br /> <p>The qualifications listed above are intended to represent the minimum education, experience, skills, knowledge and ability levels associated with performing the duties and responsibilities contained in this job description.&nbsp;</p> <p>We are an Equal Opportunity Employer. Diversity is valued and we will not tolerate discrimination or harassment in any form. Candidates for the position stated above are hired on an "at will" basis. Nothing herein is intended to create a contract.</p> <p>&nbsp;</p>