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 <ul> <li>Maintains and updates data including extracts, queries, aggregates, and snapshots.</li> <li>Extracts data for ad hoc predictive modeling projects.</li> <li>Identifies and recommends internal and external data to be used for modeling and/or decision making.</li> <li>Provides data and analysis for ad hoc projects as directed.</li> <li>Has practical knowledge of various internal data sources (i.e., policy admin systems, claims systems, IT systems).</li> <li>Is aware of workflows in various departments throughout the organization.</li> <li>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) </li> <li>Develops and delivers system training courses for corporate and service office business clients. (Applies to IT EDW) </li></ul>Negotiation <ul> <li>Supports data needs of Commercial Lines, Personal Lines, Claims, IT, Actuarial, Finance, Statistics, Customer Experience, and Field Operations.</li> <li>Collaborates with staff throughout the organization to solve problems and suggest efficient processes.</li> <li>Actively participates in meetings involving several different departments. </li></ul>Results Oriented <ul> <li>Assists Enterprise Data Warehouse team with metadata and ad hoc data extracts.</li> <li>Tests data extracts, queries, aggregates, and snapshots.</li> <li>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) </li></ul>Time & Priority Management <ul> <li>Supports modelers with data needs in large modeling projects as well as smaller ad hoc projects. </li></ul>Decision Making <ul> <li>Analyzes data quality and recommend improvements.</li> <li>Acts as a liaison between business and IT personnel.</li> <li>Designs and programs ad hoc business intelligence. </li></ul>Embraces Data Analytics <ul> <li>Identifies problems that data analytics might help solve and/or opportunities to use data analytics to guide decisions.</li> <li>Understands data available within specific domain.</li> <li>Considers data with curiosity tempered by skepticism.</li> <li>Recognizes unexpected patterns in data.</li> <li>Has basic understanding of predictive analytics and statistics.</li> <li>Compiles, manipulates, synthesizes, validates, and analyzes data.</li> <li>Effectively communicates analytics results graphically and via narrative.</li> <li>Performs various projects requested or assigned by the Manager of Data Warehouse & Business Intelligence, IT Team Leader </li></ul>CORPORATE CORE COMPETENCIES OF THE DATA AND BUSINESS INTELLIGENCE ANALYST Effectively Communicates and Connects <ul> <li>Communicates and negotiates effectively with peers regarding work outcomes.</li> <li>Influences by making a strong case, bringing other people on the team to understand the presented viewpoint.</li> <li>Provides feedback and is clear when disagreeing with an approach; offers suggestions for improvement.</li> <li>Attentively listens and asks clarifying questions and paraphrases to enhance understanding.</li> <li>Builds and nurtures positive relationships within the workplace. </li></ul>Customer Focused <ul> <li>Identifies explicit and implied customer needs.</li> <li>Asks probing questions to fully understand business requirements.</li> <li>Develops positive relationships with customers by meeting their needs as well as incorporating their feedback.</li> <li>Responds quickly and acts with high quality solutions that address needs and improve overall customer experience.</li> <li>Owns resolution of customer experience outcome. </li></ul>Talent Development Mindset <ul> <li>Discusses technical and professional development with peers to gain suggestions for further development.</li> <li>Actively seeks and acts on opportunities to recognize peers for high performance.</li> <li>Stays alert to identify learning opportunities for self. </li></ul>Demonstrates Adaptability <ul> <li>Contributes to progressive thinking within the team by posing questions that challenge traditional methods or processes.</li> <li>Proposes ideas and suggests new approaches to tackling own work tasks and issues in a better way to drive organization success.</li> <li>Participates in and actively supports change initiatives and provides ideas to promote their success.</li> <li>Recognizes and manages an ambiguous work environment.</li> <li>Demonstrates flexibility in generating alternative solutions and recommendations. </li></ul>Demonstrates Accountability <ul> <li>Applies judgment in making decisions about own work and takes responsibility for actions.</li> <li>Demonstrates reliability by producing steady work results and delivering on commitments to team members on time.</li> <li>Takes responsibility for regularly seeking and applying feedback and actively learning from errors and setbacks.</li> <li>Understands the mission of the organization. </li></ul>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 <ul> <li>Minimum of 2 years professional statistical or analytical experience, preferably within a property and casualty insurance environment</li> <li>Programming skills in structured query language or other data management /analysis applications, such as Microsoft Access, SQL or other database program</li> <li>Experience designing reports for end-users preferred </li></ul>Technical/Professional Knowledge <ul> <li>Working knowledge of the property/casualty insurance industry and operations </li> <li>Excellent communications skills, both oral and written</li> <li>Strong organizational skills</li> <li>Strong time management skills</li> <li>Good interpersonal skills </li> <li>Thorough knowledge of data warehousing and Penn National's Enterprise Data Warehouse</li> <li>Excellent PC skills, with an emphasis on Access, Excel, Pivot Tables, Power Pivot, and SharePoint</li> <li>Familiarity with Data Warehouse concepts (Kimball Star schema Fact and Dimensional data marts, Slowly Changing Dimensions, ETL and BI concepts)</li> <li>Familiarity with database querying language such as MS SQL.</li> <li>Working knowledge of relational databases as well as business object-oriented databases and XML. </li></ul>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) <ul> <li>This position is primarily a sedentary position that requires occasional standing and walking throughout the office environment.</li> <li>Must be able to see and effectively use a computer monitor.</li> <li>Must be able to operate a computer, keyboard and applicable printers and other general office equipment.</li> <li>Must be able to access and enter information accurately using automated systems.</li> <li>Must be able to hear and communicate via the telephone and/or monitoring devices to both internal and external clients.</li> <li>Must be able to present information to individuals and groups.</li> <li>Must be able to interpret and apply concepts that may or may not be based upon established guidelines.</li> <li>Must be able to maintain acceptable attendance and adhere to scheduled work hours. </li> </ul>

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 as required. 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 <ul> <li>Maintains and updates data including extracts, queries, aggregates, and snapshots.</li> <li>Extracts data for ad hoc predictive modeling projects.</li> <li>Identifies and recommends internal and external data to be used for modeling and/or decision making.</li> <li>Provides data and analysis for ad hoc projects as directed.</li> <li>Has practical knowledge of various internal data sources (i.e., policy admin systems, claims systems, IT systems).</li> <li>Is aware of workflows in various departments throughout the organization.</li> <li>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) </li> <li>Develops and delivers system training courses for corporate and service office business clients. (Applies to IT EDW) </li></ul>Negotiation <ul> <li>Supports data needs of Commercial Lines, Personal Lines, Claims, IT, Actuarial, Finance, Statistics, Customer Experience, and Field Operations.</li> <li>Collaborates with staff throughout the organization to solve problems and suggest efficient processes.</li> <li>Actively participates in meetings involving several different departments. </li></ul>Results Oriented <ul> <li>Assists Enterprise Data Warehouse team with metadata and ad hoc data extracts.</li> <li>Tests data extracts, queries, aggregates, and snapshots.</li> <li>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) </li></ul>Time & Priority Management <ul> <li>Supports modelers with data needs in large modeling projects as well as smaller ad hoc projects. </li></ul>Decision Making <ul> <li>Analyzes data quality and recommend improvements.</li> <li>Acts as a liaison between business and IT personnel.</li> <li>Designs and programs ad hoc business intelligence. </li></ul>Embraces Data Analytics <ul> <li>Identifies problems that data analytics might help solve and/or opportunities to use data analytics to guide decisions.</li> <li>Understands data available within specific domain.</li> <li>Considers data with curiosity tempered by skepticism.</li> <li>Recognizes unexpected patterns in data.</li> <li>Has basic understanding of predictive analytics and statistics.</li> <li>Compiles, manipulates, synthesizes, validates, and analyzes data.</li> <li>Effectively communicates analytics results graphically and via narrative.</li> <li>Performs various projects requested or assigned by the Manager of Data Warehouse & Business Intelligence, IT Team Leader </li></ul>CORPORATE CORE COMPETENCIES OF THE DATA AND BUSINESS INTELLIGENCE ANALYST Effectively Communicates and Connects <ul> <li>Communicates and negotiates effectively with peers regarding work outcomes.</li> <li>Influences by making a strong case, bringing other people on the team to understand the presented viewpoint.</li> <li>Provides feedback and is clear when disagreeing with an approach; offers suggestions for improvement.</li> <li>Attentively listens and asks clarifying questions and paraphrases to enhance understanding.</li> <li>Builds and nurtures positive relationships within the workplace. </li></ul>Customer Focused <ul> <li>Identifies explicit and implied customer needs.</li> <li>Asks probing questions to fully understand business requirements.</li> <li>Develops positive relationships with customers by meeting their needs as well as incorporating their feedback.</li> <li>Responds quickly and acts with high quality solutions that address needs and improve overall customer experience.</li> <li>Owns resolution of customer experience outcome. </li></ul>Talent Development Mindset <ul> <li>Discusses technical and professional development with peers to gain suggestions for further development.</li> <li>Actively seeks and acts on opportunities to recognize peers for high performance.</li> <li>Stays alert to identify learning opportunities for self. </li></ul>Demonstrates Adaptability <ul> <li>Contributes to progressive thinking within the team by posing questions that challenge traditional methods or processes.</li> <li>Proposes ideas and suggests new approaches to tackling own work tasks and issues in a better way to drive organization success.</li> <li>Participates in and actively supports change initiatives and provides ideas to promote their success.</li> <li>Recognizes and manages an ambiguous work environment.</li> <li>Demonstrates flexibility in generating alternative solutions and recommendations. </li></ul>Demonstrates Accountability <ul> <li>Applies judgment in making decisions about own work and takes responsibility for actions.</li> <li>Demonstrates reliability by producing steady work results and delivering on commitments to team members on time.</li> <li>Takes responsibility for regularly seeking and applying feedback and actively learning from errors and setbacks.</li> <li>Understands the mission of the organization. </li></ul>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 <ul> <li>Minimum of 2 years professional statistical or analytical experience, preferably within a property and casualty insurance environment</li> <li>Programming skills in structured query language or other data management /analysis applications, such as Microsoft Access, SQL or other database program</li> <li>Experience designing reports for end-users preferred </li></ul>Technical/Professional Knowledge <ul> <li>Working knowledge of the property/casualty insurance industry and operations </li> <li>Excellent communications skills, both oral and written</li> <li>Strong organizational skills</li> <li>Strong time management skills</li> <li>Good interpersonal skills </li> <li>Thorough knowledge of data warehousing and Penn National's Enterprise Data Warehouse</li> <li>Excellent PC skills, with an emphasis on Access, Excel, Pivot Tables, Power Pivot, and SharePoint</li> <li>Familiarity with Data Warehouse concepts (Kimball Star schema Fact and Dimensional data marts, Slowly Changing Dimensions, ETL and BI concepts)</li> <li>Familiarity with database querying language such as MS SQL.</li> <li>Working knowledge of relational databases as well as business object-oriented databases and XML. </li></ul>Only candidates from the following states will be considered: 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) <ul> <li>This position is primarily a sedentary position that requires occasional standing and walking throughout the office environment.</li> <li>Must be able to see and effectively use a computer monitor.</li> <li>Must be able to operate a computer, keyboard and applicable printers and other general office equipment.</li> <li>Must be able to access and enter information accurately using automated systems.</li> <li>Must be able to hear and communicate via the telephone and/or monitoring devices to both internal and external clients.</li> <li>Must be able to present information to individuals and groups.</li> <li>Must be able to interpret and apply concepts that may or may not be based upon established guidelines.</li> <li>Must be able to maintain acceptable attendance and adhere to scheduled work hours. </li> </ul>

With Confluent, organizations can harness the full power of continuously flowing data to innovate and win in the modern digital world. We have a purpose that drives us to do better every day we're creating an entirely new category within data infrastructure - data streaming. This technology will allow every organization to create experiences and use the power of data in ways that profoundly impact the way we all live. This impact is our purpose and drives us to do better every day. One Confluent. One team. One Data Streaming Platform. Data Connects Us. About the Role: This newly created role will be a key member of the CSGSO Business Analytics team and will work across the Customer Success Group (CSG) Strategy & Operations and CSG organization to utilize our business systems data to analyze and provide insight into the organization's performance. Additionally, this role will apply creativity and analytical thinking to design and implement operational dashboards and ad hoc reporting. The role requires that you have a strong technical knowledge of database and business intelligence design, and how to transform data into insight so we can utilize world class functional dashboards, reporting, and analysis to ensure data-driven decisions are a daily part of how we work. To do this you will work with our CSG Strategy & Operations teams to provide business insight. A background in Tableau, SQL, or experiences supporting a pre-sales and/or a post-sales customer business is preferred. This position reports to the Sr Manager of CSG Strategy & Operations Business Analytics. What You Will Do: Create the Tableau dashboards and analytic reporting in business systems such as Salesforce that allow us to measure and effectively execute strategies that guide Customer Solutions Group actions and investment Own core activities for small analytic projects of moderate to high complexity Gather requirements, design, and build dashboards & analytic reporting based on stakeholders & leadership needs to help monitor performance for all key indicators. Work with Sr Manager, Business Analytics to define and maintain a set of data definitions and available measures across the CSG business Work with Sr. Manager Business Analytics to establish a roadmap and rationalization plan for all of our dashboards, reporting, analysis tools, and processes deployed across CSG What You Will Bring: BS degree, preferably with a post graduate degree in Data Science, Information Technology, Computing, Business, Operations, or a related discipline. 2 years relevant industry experience or demonstrable applied knowledge of working with Tableau or other data visualization software, Salesforce, SQL (large data sets/data warehousing). The ability to communicate cross-functionally, derive requirements, set and meet deadlines, and deliver insightful analysis and/or models Keen attention to detail while completing complex tasks Open, growth mindset and high degrees of self motivation, fostered in a fast-paced, high growth, dynamic environment Come As You Are At Confluent, equality is a core tenet of our culture. We are committed to building an inclusive global team that represents a variety of backgrounds, perspectives, beliefs, and experiences. The more diverse we are, the richer our community and the broader our impact. Employment decisions are made on the basis of job-related criteria without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, or any other classification protected by applicable law. At Confluent, we are committed to providing competitive pay and benefits that are in line with industry standards. We analyze and carefully consider several factors when determining compensation, including work history, education, professional experience, and location. This position has an annual estimated salary of $98,500 - $115,740, an annual bonus, and a competitive equity package. The actual pay may vary depending on your skills, qualifications, experience, and work location. In addition, Confluent offers a wide range of employee benefits. To learn more about our benefits click HERE (https://confluentbenefits.com/) . Click HERE (https://www.confluent.io/legal/confluent-candidate-privacy-notice/) to review our Candidate Privacy Notice which describes how and when Confluent, Inc., and its group companies, collects, uses, and shares certain personal information of California job applicants and prospective employees. LI-Remote

Business Intelligence Analyst Jobs in Harrisburg, PA

Data Business Intelligence Analyst Hybrid
November 18, 2024

Data Business Intelligence Analyst
November 15, 2024

Field Operations Business Intelligence Analyst
October 30, 2024

Business Intelligence Analyst
October 24, 2024

Quick filters

Top companies

Business Intelligence Analyst Jobs in Harrisburg, PA

Data Business Intelligence Analyst HybridNovember 18, 2024

Data Business Intelligence AnalystNovember 15, 2024

Field Operations Business Intelligence AnalystOctober 30, 2024