Sorry, this job is no longer accepting applications. See below for more jobs that match what you’re looking for!

Business Analyst

Expired Job

Ziontech Solutions Northbrook , IL 60062

Posted 2 months ago

Position: Business analyst (SAS or SQL)(No.of Positions 10)
Location: Northbrook, IL & Woonsocket RI.
Duration: 2+ months Contract with 100% extensions.
Interview Mode: 2 Phone Interviews
The Campaign Targeting Analytics Analyst is responsible for performing database list pulls for strategic initiatives to support communications to PBM members primarily relating to formulary and benefit plan designs.

This position is expected to:

Execute structured SAS-SQL Teradata code to synthesize large amounts of relational data to optimize complex member communications products to key audiences.

Perform quality assurance on list pulls
Qualifications Bachelors degree in Mathematics, Computer Science, MIS, Economics or related field (or related experience)
along with a minimum of 1-2 years of working knowledge and experience in successfully leveraging sophisticated database management platforms
such as Teradata, Oracle, SQL-server or structured programming. Must be proficient with SQL experience.
Candidates must have superior analytical skills and problem solving skills with a high level of independent judgment and initiative required.
The ideal candidate will have the ability to communicate effectively in a manner that is clear, logical and consistent.
Excellent interpersonal skills, including the ability to interact and influence at all levels of the organization.
This position requires strong of attention to detail and the ability to manage multiple projects simultaneously,
adjusting priorities as needed and meeting deadlines. Experience in database or direct marketing is heavily preferred.

Bachelors degree in Mathematics, Computer Science, MIS, Economics or related field (or related experience).

Minimum of 1-2 years of working knowledge and experience in successfully leveraging sophisticated database management platforms such as Teradata, Oracle, SQL-server or structured programming.

Camping OR Marketing experience will be a huge plus.

SAS Experience is preferred, but not required.

SAS, SQL, Teradata or Metadata and Tableau and SAS macros and IBM/UNICA.


SAS, Unix file handling, DB2,

Experience with MS/Word, MS/Excel, MS/Exchange, MS/Power Point, Access, Outlook,

Oracle, SQL/server, Business Objects, VISIO, MS/Project, ERwin.
Email id:

SAS, SQL, Teradata or Metadata and Tableau and SAS macros and IBM/UNICA
2+ months

See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Download the
LiveCareer app and find
your dream job anywhere

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
Senior Business Analyst Underwriting Supplier Management


Posted 2 days ago

VIEW JOBS 11/15/2018 12:00:00 AM 2019-02-13T00:00 Description : Where good people build rewarding careers. Think that working in the insurance field can't be exciting, rewarding and challenging? Think again. You'll help us reinvent protection and retirement to improve customers' lives. We'll help you make an impact with our training and mentoring offerings. Here, you'll have the opportunity to expand and apply your skills in ways you never thought possible. And you'll have fun doing it. Join a company of individuals with hopes, plans and passions, all using and developing our talents for good, at work and in life. Job Description Job Family Summary The Underwriting Supplier Management Team is responsible for collaborating with internal and external business partners to ensure the most efficient and effective processes and tools are operating as designed while working towards continual improvement. The team is also responsible for the strategy, analytics, ad-hoc requests, implementation, analyzing and communicating metrics, supplier relationships, contract and project management related to these processes and tools. Job Summary As Supplier Management Senior Business Analyst you will support functional and technical strategies, analyze internal and external data while evaluating processes to identify new efforts for innovation and improvement. You will serve as support to their assigned tool(s), process(es) and/or supplier(s) for teams across Product Operations, as well as the Allstate enterprise, providing resources for actionable results. Key Responsibilities * Supports ownership of internal and external business partner relationships * Uses understanding of current industry standards / environment to impact decisions and indicate requirements * Supports the development of business recommendations to achieve goals and communicates to underwriting team * Develop and present communication strategies: new plans, programs, processes, products and product performance * Knowledge of data sources, and has the ability to review data from existing and new sources, both internal and external to Allstate * Supports the team by providing analytics and reporting, which includes generating and formatting reports that to analyze and monitor supplier performance with minimal direction * Actively communicates anomalies and recommended actions to appropriate partners * Provides recommendations for potential next steps/actions for the team * Solicits inputs and collaborate with internal and external partners * Researches, analyzes and interprets data to find opportunities to impact growth and profitability * Ensures project controls are in place throughout the lifecycle of the project, and follows up as necessary * Determine where additional resources / expertise may be necessary to successfully complete projects and assignments * Forecasts short-term and long-term deliverables * Supports the development / design of new supplier and underwriting plans, programs, processes, products up to moderate complexity * Actively builds positive relationships among teams and team members to ensure cooperation on objectives * Consults on complex issues within their disciplines from an internal perspective Job Qualifications Knowledge/Skills/Abilities/Experience * Education: Bachelor's degree or equivalent experience * Experience: 3-5 years of industry experience with a background in project management or analytics preferred * Advanced analytical and problem-solving skills * Demonstrates and champions a sense of urgency, strong dedication, and accountability for achieving results * Effectively network and communicate with different types and levels of staff, both written and verbal * Knowledge of underwriting, product management and general insurance principles preferred * Knowledge of Allstate quoting systems and processes preferred The candidate(s) offered this position will be required to submit to a background investigation, which includes a drug screen. Good Work. Good Life. Good Hands®. As a Fortune 100 company and industry leader, we provide a competitive salary – but that's just the beginning. Our Total Rewards package also offers benefits like tuition assistance, medical and dental insurance, as well as a robust pension and 401(k). Plus, you'll have access to a wide variety of programs to help you balance your work and personal life -- including a generous paid time off policy. Learn more about life at Allstate. Connect with us on Twitter, Facebook, Instagram and LinkedIn or watch a video. Allstate generally does not sponsor individuals for employment-based visas for this position. Effective July 1, 2014, under Indiana House Enrolled Act (HEA) 1242, it is against public policy of the State of Indiana and a discriminatory practice for an employer to discriminate against a prospective employee on the basis of status as a veteran by refusing to employ an applicant on the basis that they are a veteran of the armed forces of the United States, a member of the Indiana National Guard or a member of a reserve component. For jobs in San Francisco, please click "here" for information regarding the San Francisco Fair Chance Ordinance. For jobs in Los Angeles, please click "here" for information regarding the Los Angeles Fair Chance Initiative for Hiring Ordinance. It is the policy of Allstate to employ the best qualified individuals available for all jobs without regard to race, color, religion, sex, age, national origin, sexual orientation, gender identity/gender expression, disability, and citizenship status as a veteran with a disability or veteran of the Vietnam Era. Allstate Northbrook IL

Business Analyst

Expired Job

Ziontech Solutions