Business Analyst III (Data Warehousing)

Are you looking for more than just a job? Do you want to have a voice and feel a sense of belonging? At ICW Group, we hire innovative people who consistently adapt, grow and deliver.

We believe in hard work, a fun work environment, and embracing creativity that only comes about when talented people collaborate to develop solutions.

Our mission is to create the best insurance experience possible.

Headquartered in San Diego with regional offices located throughout the United States, ICW Group has been named for seven consecutive years as a Top 50 performing P&C company offering the stability of a large, profitable and growing company combined with a small-company entrepreneurial spirit.

Our purpose-driven ethos provides team members with opportunities to contribute, develop, and belong.

The purpose of the Business Analyst III is to assume responsibility for helping business and IT implement technology solutions in a cost-effective way, and to facilitate communication with stakeholders, facilitators, and partners.

This position exists to analyze business partner's operations to align information technology solutions with business initiatives.

WHAT YOU WILL DO

Partners with business leaders to align IT initiatives with business strategy.

• Educates the IT organization on the direction of the business.
• Negotiates agreements and commitments by facilitating communication between business unit(s) and IT from initial requirements to final implementation.
• Works with business Product Owners to create and maintain an operating plan to achieve the strategic vision and operating platforms that define the people, processes, tools, and technology.

Partners with business and technology partners to elicit, analyze, translate, and document business requirements into technical requirements.

• Analyzes, documents, and tests program development, logic, process flows, and specifications.
• Finds ways to improve workflow and the cost effective utilization of insurance systems.
• Partners with business stakeholders to conduct user acceptance testing.
• Documents user manuals to describe application installation and operating procedures.
• Facilitates communication between IT and business stakeholders and Product Owners to ensure that projects are delivered on time and within budget.

Provides business process and technical expertise to IT staff for the implementation of enhancements, solutions, and maintenance for installed systems.

• Improves the cost effective utilization of insurance systems.
• Brings solutions to business units supported to enhance the enterprise's competitive edge.
• Contributes in design sessions in prototyping new or existing systems for the purpose of enhancing business processes, operations, and information process flow.
• Performs cost-benefit and ROI analyses for propose systems to aid teams in making implementation decisions.
• Identifies inefficient processes and procedures.

WHAT YOU BRING TO THE ROLE

Bachelor's degree from four-year college or university in Computer Science, Information Technology, Engineering, or related field.

Advanced Degree with Industry / Technical designations (i.e., CPCU, ARM, and CBAP) preferred. Minimum 5 years of relevant technical or business work experience or equivalent combination of education and experience .

Minimum 4 years of related experience in business analysis required.

CERTIFICATES, LICENSES, REGISTRATIONS

CBAP, ITIL, SQL, CPCU, ARM, CSM, CSPO, preferred but not required. Position may require experience in business analysis and SAP systems, specifically FI, CD, ICM and BP.

KNOWELDGE AND SKILLS

• Knowledge of insurance preferred.
• Strong analytical skills; ability to create compelling business cases; very strong understanding of business complexity and project interdependencies.
• Intellectual curiosity and the ability to question status quo; ability to partner with software engineers quality analysts to identify course of resolutions.
• Ability to create and interpret user needs into specifications, user stories, flowcharts, UML diagrams, etc.
• Highly competent in reading, analyzing, and interpreting technical industry-related journals and DOI filings.
• Ability to coordinate and organize input from various stakeholders, negotiate priorities, resolve conflicts, and consensus building.
• Strong understanding of basic system engineering, object-oriented design, information risk and security guidelines, and architecture standards.
• Strong knowledge of Modeling Techniques : Object Orientation analysis, UML (e.g. Use Cases, Activity Diagrams); in depth understanding of the various software development lifecycles (e.

g. Scrum and Waterfall) and demonstrated experience in writing software requirements and test specifications.

• Strong understanding of data management and database concepts.
• Advanced knowledge of SQL, and ability to work on advanced Excel functions including VBA if required.
• Strong working knowledge of API standards for communicating and integration between applications.
• Must collaborate with business teams and leaders to identify data and reporting needs
• Utilize SQL to extract and analyze large amounts of data including testing and validation of data sets, balancing, etc.
• Perform data profiling and data-in-context analysis to support data warehousing projects, data conversion, and data quality issues
• Perform database structure research and create data mapping documents in order to understand relevant data elements along with their definitions and use
• Partner with data governance and data architecture teams to maintain metadata and lineage in data governance app
• Prior experience with AWS cloud data architectures, data warehousing, BI tools and Insurance domain preferred

PHYSICAL REQUIREMENTS

This job operates in a professional office environment. While performing the duties of this job, the employee is regularly required to talk or hear.

The employee frequently will sit, stand, walk, and bend during working hours. Requires manual and finger dexterity and eye-hand coordination.

May be required to lift light objects. Requires normal or corrected vision and hearing corrected to a normal range.

WORK ENVIRONMENT

This position operates in an office environment and requires the frequent use of computer, telephone, copier and other standard office equipment.

COMPENSATION ( Standard on all postings)

The current salary range for this position is $89,139.23 to $150,327.26. This range is exclusive of fringe benefits and potential bonuses.

If hired at ICW Group, your final base salary compensation will be determined by factors unique to each candidate; including experience, education, and location of the role and considers employees performing substantially similar work.

WHY JOIN ICW GROUP? ( Standard on all postings)

• Challenging work and the ability to make a difference
• You will have a voice and feel a sense of belonging
• We offer a competitive benefits package, with generous medical, dental, and vision plans as well as 401K retirement plans and company match
• Bonus potential for all positions
• Paid Time Off with an accrual rate of 5.23 hours per pay period (equal to 17 days per year)
• 10 paid holidays throughout the calendar year
• Want to continue learning? We'll support you 100%

ICW Group is committed to creating a diverse environment and is proud to be an Equal Opportunity Employer. ICW Group will not discriminate against an applicant or employee on the basis of race, color, religion, national origin, ancestry, sex / gender, age, physical or mental disability, military or veteran status, genetic information, sexual orientation, gender identity, gender expression, marital status, or any other characteristic protected by applicable federal, state or local law.

LI-TP1 #LI-HYBRID