Data & Business Intelligence Analyst - HYBRID

3 weeks ago

Harrisburg, United States Penn National Insurance Full time
Job Description

Penn National Insurance is looking to add a Data & Business Intelligence Analyst to our incredible IT team This is a hybrid position reporting to the home office in Harrisburg, PA.

The Data and Business Intelligence Analyst position resides in the Information Technology department on the Enterprise Data Warehouse team. This position supports data collection, manipulation, reporting, and analysis in support of the Enterprise Data Warehouse, Advanced Analytics, and other areas within the company.

COMPETENCIES AND ESSENTIAL DUTIES OF THE DATA AND BUSINESS INTELLIGENCE ANALYST

Business Acumen
  • Maintains and updates data including extracts, queries, aggregates, and snapshots.
  • Extracts data for ad hoc predictive modeling projects.
  • Identifies and recommends internal and external data to be used for modeling and/or decision making.
  • Provides data and analysis for ad hoc projects as directed.
  • Has practical knowledge of various internal data sources (i.e., policy admin systems, claims systems, IT systems).
  • Is aware of workflows in various departments throughout the organization.
  • Creates and updates or modifies systems documentation including, but not limited to: business or systems requirements, change requests, workbooks, test matrices, test cases on new product development, and report layouts. Documentation is used by programmers/developers to program changes to production systems. (Applies to IT EDW)
  • Develops and delivers system training courses for corporate and service office business clients. (Applies to IT EDW)
Negotiation
  • Supports data needs of Commercial Lines, Personal Lines, Claims, IT, Actuarial, Finance, Statistics, Customer Experience, and Field Operations.
  • Collaborates with staff throughout the organization to solve problems and suggest efficient processes.
  • Actively participates in meetings involving several different departments.
Results Oriented
  • Assists Enterprise Data Warehouse team with metadata and ad hoc data extracts.
  • Tests data extracts, queries, aggregates, and snapshots.
  • Estimates, plans, leads, organizes, controls, and reports status for small-to-medium sized "planned" projects (or subsystems of strategic projects) or supports teams with several cross-functional team members. (Applies to IT EDW)
Time & Priority Management
  • Supports modelers with data needs in large modeling projects as well as smaller ad hoc projects.
Decision Making
  • Analyzes data quality and recommend improvements.
  • Acts as a liaison between business and IT personnel.
  • Designs and programs ad hoc business intelligence.
Embraces Data Analytics
  • Identifies problems that data analytics might help solve and/or opportunities to use data analytics to guide decisions.
  • Understands data available within specific domain.
  • Considers data with curiosity tempered by skepticism.
  • Recognizes unexpected patterns in data.
  • Has basic understanding of predictive analytics and statistics.
  • Compiles, manipulates, synthesizes, validates, and analyzes data.
  • Effectively communicates analytics results graphically and via narrative.
  • Performs various projects requested or assigned by the Manager of Data Warehouse & Business Intelligence, IT Team Leader
CORPORATE CORE COMPETENCIES OF THE DATA AND BUSINESS INTELLIGENCE ANALYST

Effectively Communicates and Connects
  • Communicates and negotiates effectively with peers regarding work outcomes.
  • Influences by making a strong case, bringing other people on the team to understand the presented viewpoint.
  • Provides feedback and is clear when disagreeing with an approach; offers suggestions for improvement.
  • Attentively listens and asks clarifying questions and paraphrases to enhance understanding.
  • Builds and nurtures positive relationships within the workplace.
Customer Focused
  • Identifies explicit and implied customer needs.
  • Asks probing questions to fully understand business requirements.
  • Develops positive relationships with customers by meeting their needs as well as incorporating their feedback.
  • Responds quickly and acts with high quality solutions that address needs and improve overall customer experience.
  • Owns resolution of customer experience outcome.
Talent Development Mindset
  • Discusses technical and professional development with peers to gain suggestions for further development.
  • Actively seeks and acts on opportunities to recognize peers for high performance.
  • Stays alert to identify learning opportunities for self.
Demonstrates Adaptability
  • Contributes to progressive thinking within the team by posing questions that challenge traditional methods or processes.
  • Proposes ideas and suggests new approaches to tackling own work tasks and issues in a better way to drive organization success.
  • Participates in and actively supports change initiatives and provides ideas to promote their success.
  • Recognizes and manages an ambiguous work environment.
  • Demonstrates flexibility in generating alternative solutions and recommendations.
Demonstrates Accountability
  • Applies judgment in making decisions about own work and takes responsibility for actions.
  • Demonstrates reliability by producing steady work results and delivering on commitments to team members on time.
  • Takes responsibility for regularly seeking and applying feedback and actively learning from errors and setbacks.
  • Understands the mission of the organization.
SPECIAL RELATIONSHIPS FOR THE DATA AND BUSINESS INTELLIGENCE ANALYST

Interacts primarily with Advanced Analytics and IT developers and analysts, but also interacts extensively with others requiring data and business intelligence including Commercial Lines, Personal Lines, Claims, Actuarial, Finance, Statistics, Customer Experience, Field Operations, and external data vendors.

QUALIFICATIONS FOR THE DATA AND BUSINESS INTELLIGENCE ANALYST

Education/Credentials

Bachelor's Degree in Mathematics, Computer Science, or a related field

Experience
  • Minimum of 2 years professional statistical or analytical experience, preferably within a property and casualty insurance environment
  • Programming skills in structured query language or other data management /analysis applications, such as Microsoft Access, SQL or other database program
  • Experience designing reports for end-users preferred
Technical/Professional Knowledge
  • Working knowledge of the property/casualty insurance industry and operations
  • Excellent communications skills, both oral and written
  • Strong organizational skills
  • Strong time management skills
  • Good interpersonal skills
  • Thorough knowledge of data warehousing and Penn National's Enterprise Data Warehouse
  • Excellent PC skills, with an emphasis on Access, Excel, Pivot Tables, Power Pivot, and SharePoint
  • Familiarity with Data Warehouse concepts (Kimball Star schema Fact and Dimensional data marts, Slowly Changing Dimensions, ETL and BI concepts)
  • Familiarity with database querying language such as MS SQL.
  • Working knowledge of relational databases as well as business object-oriented databases and XML.
Only candidates from the following states will be considered for positions at Penn National Insurance: Alabama, Delaware, Iowa, Maryland, Minnesota, North Carolina, New Jersey, Pennsylvania, South Carolina, Tennessee, Virginia, Wisconsin.

JOB REQUIREMENTS (as required by ADA - Americans with Disabilities Act)
  • This position is primarily a sedentary position that requires occasional standing and walking throughout the office environment.
  • Must be able to see and effectively use a computer monitor.
  • Must be able to operate a computer, keyboard and applicable printers and other general office equipment.
  • Must be able to access and enter information accurately using automated systems.
  • Must be able to hear and communicate via the telephone and/or monitoring devices to both internal and external clients.
  • Must be able to present information to individuals and groups.
  • Must be able to interpret and apply concepts that may or may not be based upon established guidelines.
  • Must be able to maintain acceptable attendance and adhere to scheduled work hours.

  • Business Intelligence Data Analyst

    6 days ago

    Harrisburg, Pennsylvania, United States Humana Full time

    About Us">Humana Inc. is a healthcare company committed to putting health first for our customers, teammates, and community. Through our insurance services and CenterWell healthcare services, we aim to improve the quality of life for people with Medicare, Medicaid, families, individuals, military service personnel, and communities at large.">Job...

  • Data Visualization Governance Analyst

    4 days ago

    Harrisburg, Pennsylvania, United States Ahold Delhaize USA Full time

    About the RoleAs a Data Visualization Governance Analyst, you will be an essential part of the HR Reporting and Analytics team at Ahold Delhaize USA. Your primary responsibility will be to create sophisticated business intelligence solutions for analyzing and presenting HR, financial, and business data to diverse stakeholders and brands.Main...

  • Business Intelligence Data Analyst

    5 days ago

    Harrisburg, Pennsylvania, United States Humana Full time

    At Humana, we are dedicated to putting health first – for our teammates, our customers and our company. We make it easier for the millions of people we serve to achieve their best health – delivering the care and service they need, when they need it. Our Humana Enterprise Operations Enablement (EOE) - CPSS Data & Analytics – BI team is seeking a highly...

  • Business Analyst

    1 week ago

    Harrisburg, United States Global Data Consultants Full time

    OverviewGDC IT Solutions is looking for a Business Analyst in the Harrisburg, PA area. This is a Hybrid Position that requires you to be onsite 2 days per week. Position Overview In this role, you'll prioritize defects and enhancements, collaborate with vendors on release schedules, and update business requirements. You'll also lead Lessons Learned...

  • Data Analyst

    1 week ago

    Harrisburg, United States ICON plc Full time

    Data Analyst - Excel & SQL - USA - Blue Bell, PA or Raleigh, NC (Hybrid) ICON plc is a world-leading healthcare intelligence and clinical research organization. We're proud to foster an inclusive environment driving innovation and excellence, and we welcome you to join us on our mission to shape the future of clinical development Symphony Health, part of the...

  • Business Intelligence Analyst

    2 weeks ago

    Harrisburg, Pennsylvania, United States cyberThink Full time

    **Job Summary:**CyberThink is seeking a highly skilled Data Analyst to support the Enterprise Risk Management program and other analytical projects. This role involves collaborating with internal business partners to develop, deliver, and maintain analytic applications and solutions to help achieve the department's risk management goals.Key...

  • Business Intelligence Analyst Leader

    3 weeks ago

    Harrisburg, Pennsylvania, United States Prequel Solutions Full time

    Key Responsibilities:As a Data Analyst at Prequel Solutions, your key responsibilities will include:Collaborating with internal stakeholders to understand business strategies, goals, and risks, translating them into analytical project plans and leading them through to completion.Providing tactical and strategic guidance on performance reporting to...

  • Intelligence Analyst

    6 days ago

    Harrisburg, United States U.S. Army Full time

    Job Description*ELIGIBLE FOR UP TO A $7.5K SIGNING BONUS. TALK TO YOUR RECRUITER FOR DETAILS.*ABOUT THIS JOB***THIS POSITION REQUIRES AN ENLISTMENT IN THE U.S. ARMY OR ARMY RESERVE***As an Intelligence Analyst, you'll be responsible for providing the Army with crucial and reliable information about enemy forces and potential areas of conflict. You'll...

  • Business Analyst

    1 week ago

    Harrisburg, United States cyberThink Full time

    Job Description: As a Business Analyst, you will be responsible for managing data processing and reporting projects to fulfill client reporting requirements, as well as supporting data clean-up and future conversion activities for a new statewide system. You will assist in managing critical tasks related to various systems and reporting efforts, and ensure...

  • Medicaid Business Analyst

    1 week ago

    Harrisburg, United States Global Data Consultants Full time

    OverviewGDC IT Solutions is looking for a Medicaid Business Analystin the Harrisburg, PAarea. Position Overview: We are currently seeking a skilled Medicaid Business Analyst to join our team! This role focuses on solving organizational problems by analyzing processes, workflows, and systems with the objective of identifying opportunities for either...

  • HRIS Data Visualization Analyst

    3 months ago

    Harrisburg, United States Ahold Delhaize Full time

    Ahold Delhaize USA, a division of global food retailer Ahold Delhaize, is part of the U.S. family of brands, which also includes five leading omnichannel grocery brands - Food Lion, Giant Food, The GIANT Company, Hannaford and Stop & Shop. Ahold Delhaize USA associates support the brands with a wide range of services, including Finance, Legal,...

  • HRIS Data Visualization Analyst

    7 days ago

    Harrisburg, United States Ahold Delhaize Full time

    Ahold Delhaize USA, a division of global food retailer Ahold Delhaize, is part of the U.S. family of brands, which also includes five leading omnichannel grocery brands - Food Lion, Giant Food, The GIANT Company, Hannaford and Stop & Shop. Ahold Delhaize USA associates support the brands with a wide range of services, including Finance, Legal,...

  • Geospatial Intelligence Analyst Position

    2 days ago

    Harrisburg, Pennsylvania, United States Army National Guard Full time

    As a Geospatial Intelligence Imagery Analyst for the Army National Guard, you will play a critical role in providing commanders with accurate battlefield information. Your geographical analysis of land and sea will be crucial to your Commander's ability to battle plan.Job Duties:Analyze images, fixed/moving targets, and geospatial data to produce...

  • Business Intelligence Specialist

    5 days ago

    Harrisburg, Pennsylvania, United States Ahold Delhaize Full time

    Job OverviewWe are seeking a highly skilled Business Intelligence Specialist to join our HR Reporting and Analytics team.The successful candidate will have expertise in Power BI reporting and configuration, as well as advanced MS Office skills, including Excel and Power BI.The ideal candidate will be responsible for developing sophisticated business...

  • Security Data Analyst

    2 days ago

    Harrisburg, Pennsylvania, United States Information Network Associates Full time

    Job OverviewWe are seeking a highly skilled and motivated individual to join our team as an Intelligence Analyst. The selected candidate will be responsible for collecting, analyzing, and disseminating intelligence related to security threats, geopolitical developments, and other relevant data.Main Responsibilities:Data Collection and Analysis: Gather and...

  • Data Analyst, Business Intelligence

    2 weeks ago

    Harrisburg, Pennsylvania, United States Harrisburg Area Community College Full time

    Job SummaryThis position is responsible for research, analysis, and report writing to support informed decision-making across the college. Utilizing advanced statistical methods, investigates complex issues, identifies and solves problems. Conducts labor market research to determine demand for current and future program offerings. Implements large national...

  • Lead Data Analyst

    1 week ago

    Harrisburg, United States Prequel Solutions Full time

    Job Description: Prequel Solutions is seeking a highly skilled Data Analyst Lead for a client project in Harrisburg, PA. The selected candidate will work onsite at a state agency, focusing on enhancing their data management system. This role involves technical design, developing solutions, and leadership to improve reporting and data tracking processes. This...

  • Business Intelligence Developer

    5 days ago

    Harrisburg, Pennsylvania, United States Humana Full time

    Job Description:At Humana, we are committed to putting health first for our teammates, customers, and company. We make it easier for the millions of people we serve to achieve their best health by delivering care and service when they need it.Key Responsibilities:Develop and maintain Power BI reports using Microsoft SQL ServerGather and analyze business...

  • Business Intelligence Solutions Manager

    1 day ago

    Harrisburg, Pennsylvania, United States Schaedler Yesco Distribution Full time

    About the RoleThis Business Intelligence Solutions Manager will lead the analysis, design, development & implementation of logical data models; physical databases, data conversions, data integrations, query & reporting functions, data management, data governance, and data quality assurance processes.Main ResponsibilitiesDesign, develop, and maintain ETL...

  • Data Analyst

    1 month ago

    Harrisburg, United States Prequel Solutions Full time

    Job Description: Our client is looking for a Risk Management Data Analyst who will collaborate with internal business partners to develop, deliver and maintain analytic applications and solutions to enhance the departments enterprise risk management goals. In this role, you will: Collaborate with internal stakeholders to understand business strategies,...