Posted 4/27/2011

FacilitySource, Inc.

Data Analyst

FacilitySource, located in Columbus , OH is a leader in providing managed service solutions for outsourcing retail facility maintenance.  Our unique solution saves organizations millions of dollars annually, reduces the risk of liability, and allows our clients to use internal resources more strategically.  We support many leading national retailers, office buildings, shopping malls, and distribution centers, by providing support and solutions for all incoming facility maintenance calls.  FacilitySource is a fast growing and entrepreneurial division of Control, Inc.  We are looking for talented and experienced professionals to join our Data Analytics team.

Overall Job Description

The Data Analyst is part of a department responsible for programming in SAS to generate analysis datasets and tables.  The department is also responsible for the validation/QC of data.  This position requires 2+ years of basic programming experience in SAS, including a level of proficiency with SAS�s data step, macros and various procedures as well as being able to read SQL code.  Qualifications include good organizational skills, strong analytical and problem solving skills, good time management skills, ability to work independently as well as part of a team, and effectively communicating with customers. 

What You'll Do 
The Data Analyst will work with our programming team to assist in quality control of data in house as well as data provided from various clients.  In addition, they will be responsible for merging data from different sources (ASCII, text, CSV, Excel, etc) into a single integrated dataset in a format that is usable by the software application.  The applicant should be familiar with Microsoft Outlook, Word, Excel, and Access.  The Data Analytics Department is also responsible for pushing SQL updates (insert, delete, and update statements) into the production servers.

Responsibilities:

• Quality control of data

• Provide support as needed for existing client data updates (utilizing SQL code for updates and SAS logic for getting update set up)

• Work with implementation team to get clients on board by processing data from various sources to get loaded into system

• Reporting of data to clients as needed

• Miscellaneous department projects as needed

Qualifications:

• Bachelor�s degree in Statistics, Mathematics, or related field required

• 2+ years SAS programming experience with knowledge of Base SAS essential

• Strong analytical and problem-solving skills

• Basic SQL Code understanding (Update, Insert, and Delete statements)

• Ability to multi-task large volumes of work in a demanding environment

• Ability to work effectively in a team oriented environment

• Excellent communication and customer service skills

• Experience within the facility management or retail industry is beneficial

• PC proficiency in MS Excel, Word, Access, and Outlook

How to Apply:

Qualified Candidates should submit their resume and salary expectations to hr@facilitysource.com.  FacilitySource, Inc. is an EOE.

posted 4/20/2011

Cardinal Health- Columbus, Ohio

Strategic Planning/Execution (SAS and VB Development)

Cardinal Health, a Fortune 17, $99 billion healthcare services compay, is currently searching for a manager level candidate to work as a SAS and VB Development expert within our Pharmaceutical Segment.  The ideal candidate will have advanced knowledge of SAS and VB to assist with the development of decision support tools and analytics. 

• Develops tools and processes to deploy concepts in economic and pricing theory towards profitable customer acquisition and retention.
• Apply business logic and analysis for developing customer portfolio strategies and recommending tactics that allow us to retain and acquire profitable customers
• Performing sales operations functions such as implementation of sales and account management strategies and incentive plan administration.
• Understand thoroughly business processes and Cardinal systems and use this knowledge to develop and enhance existing processes to reduce costs and create efficiency. Improve our understanding of the specialty market and use this understanding to drive profitable sales growth.
• Expert in working with analytical tools including SAS, Excel, and Access etc. to understand and leverage the cost to serve model in deal acquisition and portfolio optimization activities.

Qualifications

• BS/BA Business or equivalent required but a Masters degree in Business, or Technical degree preferred 
• 3-5 years professional experience post bachelors� degree.
• Analytical & Word Processing: Must demonstrate command of MS Office applications (Excel, PowerPoint, Word and Outlook)
• Advanced knowledge and experience using SAS and VB to develop decision support tools and analytics to support business decision-making.
• Presentation: must demonstrate clear, concise articulation of proposed actions, illustrating opportunity, alternatives, recommendation and associated economics

For more details and to apply, please visit www.cardinalhealth.com/careers

Click Search for jobs and type in job number (Enter Req number 11000612 ) in the Job Number Search field.

EOE M/F/D/V Diversity Works Here

Posted 4/2/2011

Statistical Analyst

Large Mortgage Company in the Columbus area is in search of a Statistical Analyst that will be working with mortgage data.

Responsibilities entail data preparation, advanced analysis and documentation/reporting on the output.

The ideal candidate will need solid SAS and SQL experience, with excellent Excel skills.

Additionally, experience with Capital Markets or Basel II are highly desired.

This position requires a team oriented, adaptive and organized consultant that will work closely with other team members.


Job Requirements
Successful candidate will possess:
� 4 + years of credit risk experience (preferably mortgage)
� SAS (some Macros) and SQL skills
The consultants must be able to do the following:
� Work with the data to create a Probability of Default Model (regression modeling)
� Document it (reporting), with the ability to defend it

Contact: Eileen Leek
Smith Hanley Consulting Group
281-676-2221 

Posted 8/30/2010

Limited Brands � Columbus , Ohio

Manager, Statistical Modeling & Analysis

Limited Brands, through Victoria's Secret, Bath & Body Works, C.O. Bigelow, La Senza, White Barn Candle Co. and Henri Bendel, presently operates more than 3,140 specialty stores. The company's products are also available online at www.victoriassecret.com,  www.bathandbodyworks.com  and www.LaSenza.com.  

Limited Brands currently has a need for a Manager, Statistical Modeling and Analysis.  The Manager will manage the analytics and modeling team staff to proactively develop strategic framework for optimizing all customer data.  He/she leads the  team in defining, building, and implementing next generation of analytics.   Builds statistical models to improve effective customer marketing strategies for a multi channel environment.   Coordinate with Customer Marketing Teams to identify marketing strategies and communications through the use of quantitative methods.  Collaborate with other modeling activities amongst channel and brands.  Own the vendor relationship for modeling tools.   Support brands in analyzing campaign results and seasonal hindsights.  Specific responsibilities include:  

Advanced Analytics & Modeling:

• Design and develop analytical solutions using various techniques to provide relevant customer insights:
• develop statistical models
• customer profiling
• segmentation analysis
• data analysis and mining

• Communicate complex analytical results in terms that are meaningful to marketing team. 
• Present ideas and findings with actionable recommendations.
• Integrate analytical findings with marketing strategies
• Analyze and pull data using SAS, SQL, or other languages as required by marketing solutions
• Manage relationships with marketing teams
• Evaluate needs and develop analytical solutions to clients business problems and opportunities.
• Partner with Direct modeling team to leverage learns and opportunities
• Manage the vendor for modeling tools
• Provide best practices for modeling
• Maintain knowledge base for modeling and analytical information

Standard Reporting:

• Support Reporting Team in managing the work overflow for report development.

Team Relations:

• Manage analytical resources
• Work cross functionally to service marketing teams and deliver on marketing goals

Qualifications:

• Quantitative Master's Degree
• Proficient using SAS & SQL for data mining
• 5+ years of work experience working with relational decision-support databases along with demonstrated computing and statistical modeling
• Developing and measuring direct marketing tests
• Strong experience with analytical tools and techniques
• Expert in analyzing customer performance data and translating that into meaningful segmentation, targeting strategies and optimization business rules.
• Strong leadership and communication skills
• Good organizational skills
• Excellent written/verbal communication skills
• Strong project management and presentation skills
• Experience directing and leading team development

 To apply: please submit your resume to wtaylor@limitedbrands.com or visit our website to learn more at www.limitedbrands.jobs

Posted 8/8/2010

Victoria�s Secret Direct � Columbus, Ohio

Manager, Statistical Modeling

The Manager, Statistical Modeling responsibilities include developing statistical models that form the foundation of our online and offline contact strategies. This includes 100+ models that determine mail depths associated with $200MM in Catalog & Related spend and that supports segmentation associated with a $300MM email business.   This business has existing modeling in place and this associate specifically will be charged with advancing the analytics agenda to optimize a marketing cadence with very heavy contact points across both catalogs and emails.  This position manages a Statistical Analyst.  

Specific responsibilities include:

�         Develop statistical models to enhance catalog and email mailing efficiency with a focus on modeling impact of multiple mailings in a heavy contact frequency including the impact of multiple additional contact points such as email.

�         Create scoring programs (based on model results) for production into mailings

�         Explore and analyze customer information in order to provide useful marketing strategies

�         Work with marketing team to incorporate research findings

�         Use relational database to create timely and insightful marketing reports

�         Partner with VP Marketing, P&A, and modeling team to deliver on a robust new contact strategy.

�         Present results to business leaders

�         Work with IT on resolving data integrity issues, providing data validation reports, and improve

�         the data warehouse.

�         Assist and train others in the use of the data warehouse for advanced analytics work.  

Qualifications:

�         Graduate degree in a quantitative field

�         Building and implementing selection models, preferably in Direct marketing

�         Eight plus years direct marketing and associated profitability metrics experience

�         Five years working with large data sets and analyzing business data elements

�         Solid spreadsheet skills

�         Understanding of data integrity issues

�         Ability to translate statistical jargon into layman�s terms

�         Ability to thrive in a fast paced and multi-tasking environment

�         Good interpersonal skills

�         Detail oriented with a high degree of accuracy

�         Advanced SAS and SQL skills

�         Demonstrated basic project management abilities  

To apply: please submit your resume to wtaylor@limitedbrands.com or visit our website to learn more at www.limitedbrands.jobs

Posted 8/8/2010

PNC

Business Analyst III

As a Business Analyst within the Business Intelligence team of the Knowledge Management Group, you will be part of a successful and growing organization. You will be based at One PNC Plaza in downtown Pittsburgh , where you will support the Business Banking segment within PNC in a team oriented atmosphere. We're committed to creating a work environment where everyone has the opportunity to thrive and succeed.

You will work as a key member of a cross-functional team to support the development, execution, and tracking of various Small Business Banking initiatives, including data collection and management, ad hoc analytics, in-depth analysis, and ongoing reporting. We offer a rewarding and challenging work environment that allows individuals to learn, grow and develop professionally and personally.

The successful candidate will have the following qualifications:

• Bachelor's Degree in marketing, information management, finance, or related field with 4-    7 years of experience or Masters in related field and 1-2 years work experience.
• Skilled at using Business Intelligence analytic software, preferable SAS, as well as Microsoft Office proficiency.
• Solid communication, database, problem solving and analytical skills.
• Ability to work individually or as part of a team.
• Must have accurate work and the ability to meet deadlines.
• Knowledge of financial services and products preferred.

PNC is a Fortune 500 financial services company. We're strong and now the sixth largest bank by deposit in the U.S.   But that doesn�t mean we speak in banking lingo or hide behind spreadsheets. In fact, it�s our down-to earth approach with customers that puts us on the map--in 15 states and the District of Columbia , plus offices nationwide.

We see how work/life balance, green initiatives, a family-friendly outlook and social responsibility make for happier employees. And happy employees make for very happy customers.

As part of our commitment to balance, we offer a comprehensive benefits package, with both full-and part-time benefits designed to provide high quality coverage at affordable costs. We understand the importance of health and wellness, fair salaries, time away, and opportunities to learn and grow

posted 12/1/2010