Data Analyst-Property

Sedgwick Claims Management Services, Inc. Naperville , IL 60540

Posted 3 months ago

Data Analyst


For a career path that is both challenging and rewarding, join Sedgwick's talented team of 21,000 colleagues around the globe. Sedgwick is a leading provider of technology-enabled risk, benefits and integrated business solutions. Taking care of people is at the heart of everything we do. Millions of people and organizations count on Sedgwick each year to take care of their needs when they face a major life event or something unexpected happens. Whether they have a workplace injury, suffer property or financial loss or damage from a natural or manmade disaster, are involved in an auto or other type of accident, or need time away from work for the birth of a child or another medical situation, we are here to provide compassionate care and expert guidance. Our clients depend on our talented colleagues to take care of their most valuable assets -- their employees, their customers and their property. At Sedgwick, caring counts. Join our team of creative and caring people of all backgrounds, and help us make a difference in the lives of others.

PRIMARY PURPOSE: To collect, analyze and report data; to be responsible for the data integrity; and to generate reports verifying and ensuring data integrity and accuracy.


  • Compiles data; prepares and distributes reports; and analyzes results.

  • Ensures data integrity; develops and produces reports utilized in measuring data accuracy.

  • May assist in the completion of appropriate client set-up and maintenance (parameter) forms.

  • Supports internal and external users including reports, installation, screen, etc.

  • Creates exception reports to identify fields of incorrect data.

  • Generates custom reports for internal and external client.


  • Performs other duties as assigned.

  • Supports the organization's quality program(s).


Education & Licensing

Bachelor's degree from an accredited college or university preferred.


Five (5) years of related experience or equivalent combination of education and experience required. Two (2) years query and report writing experience strongly preferred.

Skills & Knowledge

  • Strong knowledge of query and report writing

  • Excellent oral and written communication, including presentation skills

  • PC literate, including Microsoft Office products

  • Analytical and interpretive skills

  • Strong organizational skills

  • Excellent interpersonal skills

  • Ability to work in a team environment

  • Ability to meet or exceed Performance Competencies


When applicable and appropriate, consideration will be given to reasonable accommodations.

Mental: Clear and conceptual thinking ability; excellent judgment, troubleshooting, problem solving, analysis, and discretion; ability to handle work-related stress; ability to handle multiple priorities simultaneously; and ability to meet deadlines

Physical: Computer keyboarding, travel as required

Auditory/Visual: Hearing, vision and talking

NOTE: Credit security clearance, confirmed via a background credit check, is required for this position.

The statements contained in this document are intended to describe the general nature and level of work being performed by a colleague assigned to this description. They are not intended to constitute a comprehensive list of functions, duties, or local variances. Management retains the discretion to add or to change the duties of the position at any time.

Sedgwick is an Equal Opportunity Employer

and a

Drug-Free Workplace

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
EEP IT Business Analyst II

The Southern Company

Posted 2 days ago

VIEW JOBS 1/21/2020 12:00:00 AM 2020-04-20T00:00 EEP IT Business Analyst II Description This position is responsible for the configuration, implementation, and maintenance of business applications and will engage with internal/external stakeholders to meet the technical needs of the Energy Efficiency Department. The position will act as the Subject Matter Expert (SME) for various technical processes/systems and business requirements. JOB REQUIREMENTS: Education: Required: BS in Computer Science, Finance, Accounting, or equivalent work experience. Preferred: MBA or Master's Degree Technical Skills: Data analysis, Access (Intermediate proficiency), Excel (intermediate proficiency), Visio, MS SQL Server and SSRS/SSIS Interpersonal Skills: Critical thinking, problem solving, analytical, and written and verbal communication. Position Related Experience: 3-4 years of job-related experience. OR any combination of education and work experience which permits the candidate to meet position work requirements. MAJOR JOB RESPONSIBILITIES: Business Acumen: Identify and develop process improvements and methods to evaluate and validate results. Develop and implement resolutions aimed at data quality enhancements. Exhibits strong written and verbal communication skills. Evaluate and identify process improvements Possesses strong quantitative analysis skills. Engagement: Ensure tasks and deliverables are completed on time to minimize business impacts. Coordinate with internal and external stakeholders to ensure data accuracy and quality Consistently engages with Energy Efficiency Department to strengthen communication and support business needs. Oversee the elements of vendor management for the Energy Efficiency IT department and serve as the central point person between various operational functions and cross-functional teams to carry out various activities including, but not limited to: reconciliation/auditing, feedback, system configuration, Team oriented with excellent interpersonal skills and the ability to collaborate effectively with coworkers and management team Functional Expertise: Salesforce administration including but not limited to setting up/deactivating users; adding/modifying new fields/objects/page layouts/etc. Manage the Energy Efficiency's Salesforce platform and perform hands-on technical implementations and deliver functional solutions Manage Salesforce page layouts, security permissions, and code development/deployment (Apex and VisualForce) Manage the SharePoint administration, including but not limited to, setting up/deactivating users; granting permissions; creation of new subsites/document libraries as requested Design and implementing solutions related to all aspects of data analytics, including mining, generation, and data visualization. Develop/test/deploy updates as needed in multiple development and production environments Utilize Microsoft Management Studio and SQL Server to develop complex SQL's to query the energyENGINE database Implement Business Intelligence solutions (e.g. Power BI, Tableau) to develop innovative methods to visualize data Develop and run complex queries for ad hoc business data requests. Develop solutions to complex analytical/data-driven problems. Support system enhancements and new technology solution projects on behalf of the business. Manage and configure the STARS 1099 Database, IBM Watson/Silverpop, and SmartSheet systems/platforms Utilize SQL programming and report-writing development life cycle to include planning, design, documentation, programming and testing experience. Driving Results: Develop and implement recommendations for future enhancements Conduct quarterly security and audit reviews Participate in system implementations to support the overall EEP department Operate as a self-starter, be able to work independently, and proactively seek innovative approaches. Create visual reports (e.g. tables, charts, graphs) for department KPI's and other metrics. Lead IT department special projects as assigned Duties Discretion: Employee receives clear instructions from supervisor regarding what to do and how to do it. Tasks follow set guidelines or procedures. Employee must consider alternative courses of action and then make a decision after considering the options. Employee has the authority to make significant choices and decisions, without specific guidance or direction from the supervisor. Explanation: This position will manage all Salesforce update requests and determine the appropriate action for development and implementation. There is significant independent data analysis and validation when developing complex queries for ad hoc business requests. The position requires daily interaction with internal and external partners that varies from day-to-day. Due to the interaction with data files, they will determine the best course of action to assure data validation and error resolution. Task Complexity: Tasks are straight-forward, routine, and often repetitive. Tasks are varied and fairly complex. Assignments are quite varied and highly complex. Southern Company Gas provides for the energy needs of millions of U.S. households and businesses. As the largest natural gas-only distribution company in the United States, with more than 150 years of history behind us, we're working to ensure that Americans have access to an abundant, safely delivered supply of natural gas for decades to come. We offer our customers a wide range of energy services under one umbrella: seven regulated utilities as well as non-regulated businesses that offer retail, wholesale and storage services. Southern Company (NYSE: SO) is a leading energy company serving 9 million customers through its subsidiaries as of Jan. 1, 2019. The company provides clean, safe, reliable and affordable energy through electric operating companies in three states, natural gas distribution companies in four states, a competitive generation company serving wholesale customers across America, a leading distributed energy infrastructure company, a fiber optics network and telecommunications services . Southern Company brands are known for excellent customer service, high reliability and affordable prices below the national average. For more than a century, we have been building the future of energy and developing the full portfolio of energy resources, including carbon-free nuclear, advanced carbon capture technologies, natural gas, renewables, energy efficiency and storage technology. Through an industry-leading commitment to innovation and a low-carbon future, Southern Company and its subsidiaries develop the customized energy solutions our customers and communities require to drive growth and prosperity. Our uncompromising values ensure we put the needs of those we serve at the center of everything we do and govern our business to the benefit of our world. Our corporate culture and hiring practices have been recognized nationally by the U.S. Department of Defense, G.I. Jobs magazine, DiversityInc, Black Enterprise, Forbes and the Women's Choice Award. To learn more, visit Southern Company is an equal opportunity employer where an applicant's qualifications are considered without regard to race, color, religion, sex, national origin, age, disability, veteran status, genetic information, sexual orientation, gender identity or expression, or any other basis prohibited by law. Job Field: Administrative & Clerical Job Type: Standard Primary Location: Illinois-Metro Chicago-Naperville Operating Company: Southern Company Gas Job Type: Standard Travel (Up to...): No Work Location(s): G O Naperville - 1844 W Ferry Rd. (1844NapervilleCODE) 1844 W Ferry Rd. Naperville, 60536 Req ID: GAS2002346 The Southern Company Naperville IL

Data Analyst-Property

Sedgwick Claims Management Services, Inc.