Direct Client Requirement Title: Business Data AnalystLocation: Naperville, IL, Rolling Meadows, IL or Raleigh, NCType: Full Time Permanent Description Client has an immediate opening for a Data Analyst with an insurance business background to join the Data Management Team. This role works a hybrid schedule in Naperville, IL, Rolling Meadows, IL or Raleigh, NC to support client's ability to make data drive decisions. Occasional travel is required. This role will be required to work from the office Monday through Wednesday with the option of working remotely Thursday and Friday.
The ideal candidate will have at least 2 years' experience using specialized software to store and organize data demonstrating their ability with TSQL coding, schema design, reporting and ETL. Prefer candidates who have mapped data from source to target as well as define testing approaches and test plans with a P&C Insurance company Responsibilities:
Analyze data-related business and technical needs, elicit and document requirements related to data integration from source systems to target data warehouse, data marts, data analytic tools, and information delivery solutions.
Develop SQL to report out information from data warehouse and other data repositories as required by business operations and analytics team.
Develop hands-on experience with our systems to understand policy, claims and billing life cycles and information collected to operate our business.
Develop a thorough understanding of our insurance business and business processes and how these are represented in our data within the systems and the data warehouse.
Support release planning (blueprinting) efforts by identifying data pertinent scope and requirements driven by Policy, Claims, Billing workstreams on major and monthly releases.
Gather data needs from business consumers: BI/Analytics, Finance, Operations, etc.; and assesses the business "reasonableness” of the requests, as well as getting to the best requirement for the business.
Perform other duties as assigned.
Qualifications: Must Have:
Bachelors' degree and at least two years of relevant experience.
Equivalent is defined as six years of relevant experience.
Relevant experience as a business analyst for technical projects
Experience and proficiency in creating SQL queries out of complex data models.
Understanding of business intelligence/data warehousing technologies
Preferably strong knowledge of insurance industry data models/modeling relevant to the property & casualty industry and ability to apply models to a newly developed data warehouse and related tools and processes
Excellent oral and written communication and presentation skills, capable of presenting complex issues in a clear, concise and persuasive manner to the business and technical professionals, including C-level executives
Strategic mindset with an ability to plan and execute strategies
Demonstrated initiative, self-starter, with strong analytical and problem-solving skills
Strong work ethic and commitment to meeting deadlines
Strong knowledge of related technologies (Data Analytics, Business Intelligence, Warehousing, Information Governance, etc.).
Ability to troubleshoot difficult and undocumented issues with creative and well-thought-out solutions, after gaining manager's approval
About us: Since 2002, APN Consulting has been inspiring success in IT through meaningful connections between employers and candidates. We are trusted by a vast array of companies, from small enterprises to some of the world’s most trusted brands to present the best talent for their contract, contract to hire and full-time positions. To learn more, please visit us online at www.apnconsultinginc.com
