Job Details

ID #45698265
State Illinois
City Naperville
Job type Permanent
Salary USD Depends on Experience Depends on Experience
Source APN Consulting Inc
Showed 2022-09-15
Date 2022-09-14
Deadline 2022-11-12
Category Et cetera
Create resume

Business Data Analyst

Illinois, Naperville, 60540 Naperville USA

Vacancy expired!

Direct Client Requirement

Title: Business Data Analyst

Location: Naperville, IL, Rolling Meadows, IL or Raleigh, NC

Type: Full Time Permanent

DescriptionClient 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

Preferred to Have:
  • Advanced knowledge of TSQL, database schema design, reports, SQL performance tuning.
  • 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

Vacancy expired!

Subscribe Report job

Related jobs

»Data Analyst
2022-09-14