Job Listings

Senior Analyst, Enterprise Risk – Pasadena, CA

IMG_3057

SUMMARY: The Senior Analyst will be responsible for providing data and analytics in support of risk, fraud, and loss mitigation efforts.  He/she will interact with executive and department management, providing actionable insights from analyses.  The ideal candidate must be a self-starter who is able to deliver high quality work within tight deadlines.  This role also requires learning overall business operations in order to properly analyze exposure.

RESPONSIBILITIES:

  • Identify high risk indicators from large sets of disparate data
  • Review and analyze patterns and trends in customer behavior
  • Translate data into actionable presentations and reports
  • Interpret findings and present to business leaders
  • Make recommendations/provide supporting analysis for fraud and loss prevention solutions
  • Automate recurring reports and drive operational process improvement
  • Other ad hoc analytical activities as needed

 

 REQUIREMENTS:

  • Bachelor’s degree in a quantitative, technical, or financial discipline.  Master’s degree preferred
  • A minimum of three years experience in either risk, fraud prevention, or loss mitigation analysis
  • Solid experience at writing complex Microsoft SQL Server T-SQL queries and understanding requirements for complex queries
  • High level of proficiency in Microsoft Excel, including experience with pivot tables, complex formulas, statistical functions, and coding macros in VBA
  • Exceptional quantitative talents and analytical/problem solving skills
  • Must be able to critically evaluate business problems/requirements and translate into analytical exercises.
  • Ability to adapt to constantly changing requirements, and to manage multiple projects with conflicting priorities
  • Strong verbal and written communication skills and the ability to interact professionally with diverse groups of executives, managers, supervisors, and subject matter experts

 

 DESIRED SKILLS:

  • Experience using major BI software packages (e.g. Tableau, Micro-Strategy)
  • Fraud modeling experience.  Statistical packages a plus (e.g. SAS, R)
  • Experience in prepaid debit card or credit card industry
  • Familiarity with know-your-customer (KYC) verifications
  • Microsoft Office Suite

*Must be a US Citizen or Green Card Holder.  e-mail resume to molly@synchrony-solutions.com

 

SAS Programmer

iStock_000008942406XSmall

POSITION SUMMARY:

Conduct analyses of large healthcare claims databases, programming in SAS.

RESPONSIBILITIES: 

  • Complete SAS programming tasks for complex health-related projects.
  • Develop, test, implement, and document analytic methods using SAS.
  • Work both independently and with team of SAS programmers to complete programming activities on assigned projects.

MINIMUM QUALIFICATIONS:

  • Bachelor’s degree in field related to healthcare services research, such as public health, healthcare policy, economics, or medical sociology.
  • 3 years experience programming in SAS and independently working on SAS programming projects.
  • Experience in healthcare industry preferred.
  • Experience preferred with the following:  large healthcare claims databases, healthcare coding systems (ICD, CPT, DRG, etc.), healthcare quality and/or cost measurement, healthcare episode groupers and risk adjustment methodologies, healthcare claims pricing systems.
  • Excellent problem-solving skills and high attention to detail.
  • Demonstrated ability to adhere to project deadlines.

·       Good oral and written communication skills.

*Must be a US citizen or Green Card Holder

Data Management Analyst – Remote

You will be accountable for helping some of the world’s largest organizations leverage the strengths of the SAS Risk Management technology platform. In addition, you may assist in the implementation and configuration of our own risk product implementations. You will develop and enhance client relationships primarily for the sales of products and services to our valued clients. You must possess or develop a strong knowledge of SAS Risk Management platform.

 

In this role, you will:

Build a trusted relationship with the client account to provide practical and theoretical guidance in the acquisition, transformation and loading of strategic data. Your skills will play a pivitol role in providing our clients with the data they require to successfully implement or leverage the SAS risk technology platform.

 

Included in your duties will be:

Designing, developing, and writing complex and original software code, specifically focusing on data processing to support risk focused implementations.

Working effectively with multiple operating systems and anticipating technical anomalies and enhancements for various environments; transferring and verifying data ETL routines across multiple environments.

Building SAS Data Integration Studio flows and leveraging the data integration technologies in the SAS V9 platform.

Designing and building advanced analytical procedures that leverage the SAS risk platform.

Writing and maintaining design documents.

Designing, developing, and ensuring the quality of prototype and demonstration systems.

Training clients and users for developed systems.

Giving presentations on SAS and company products.

Developing unique and new methods for data handling within the company’s own product lines.

Accurately forecasting the time needed to complete projects.

Performing other tasks as assigned.

Reporting Engineer – Los Angeles, CA

 

SUMMARY:

To design and create robust reporting solutions that meet established specifications, design criteria, quality standards and business requirements with minimum supervision.

 

ROLES

•Provides technical expertise to business areas in understanding the data architecture

•Reviews and analyzes the reporting environment to make recommendations for improvements and/or upgrades

•Provides business requirements definition activities and translates them into logical and physical database designs

•Leverages knowledge of current software development methodologies to contribute to the overall planning of projects by recommending approaches, identifying resources, and developing timelines

•Works with Arch / QA / BSA to establish unit test criteria

•Ensures the practice of GDC code guidelines and best practices

•Establishes and validates constructed code against unit test criteria

•Participates in projects through the various phases

•While in QA phase, makes corrections to code, and updates comments/design docs to reflect changes

•Provides post production support

 

RESPONSIBILITIES:

•Designs and develops reporting models to meet business requirements

•Creates ad hoc queries to support business decisions

•Creates subscription reports using SQL Server Reporting Services (SSRS) and MicroStrategy

•Contributes to matrix teams designing and developing reporting and data warehouse solutions

•Prepares and maintains complete programming specifications, functional designs, and both high and detail level technical design documents

•Conducts code and security code reviews

•Creates deployment scripts

•Performs troubleshooting and analysis to assess root causes of reporting and data warehouse issues

•Maintains a high degree of knowledge on current technologies and tools

•Makes recommendations to improve operating efficiency and functionality of assigned systems areas

 

Duties

Under general direction, participates in the construction, implementation and support of software products that meet established specifications, design criteria, quality standards and business requirements.  Responsible for designing reporting solutions based upon business requirements documentation and architectural designs.

 

REQUIREMENTS:

•2+ years overall software and/or application development experience performing data analyst tasks

•2+ years experience with knowledge of T-SQL and Stored Procedures, Data Transformation Services (DTS), SQL Server Integration Services (SSIS), and SQL Server Reporting Services (SSRS) using Microsoft SQL Server

•2+ years experience with managing large volumes of data, extraction of data from SQL Server tables

•2+ years experience with MicroStrategy software – advanced reporting technique familiarity a plus

•Understanding of theoretical and practical aspects of decision support system design (ETL, Architecture, Metadata, Data Access, etc.)

•Ability to work well in a team environment and brainstorm with other developers/senior developers on ideas, work flow and technologies

Sr. Statistical Programmer – SF Bay Area

Must be a US Citizen or Green Card holder.  This is a permanent, full-time position.

The Senior Statistical Programmer serves as a lead programmer for assigned clinical/post-marketing study projects and is held accountable for all expected deliverables.  Additionally, the Senior Statistical Programmer is responsible for the development, validation, execution, maintenance, documentation, and archival of analysis datasets and programming code used in the analysis of clinical trial data targeted for regulatory submission.  All programming must be consistent with good programming practice and compliant with regulatory requirements. The employee will work interactively with biostatistics, data management, clinical and regulatory personnel and other departments as appropriate.  The employee will also interact with outside groups, e.g., Data Management CROs and EDC vendors.

 

Strong communication skill is required:

o   Ability to articulately communicate complex information to others and to comprehend complex analysis issues.  Being visible and approachable.

o   Ability to communicate verbally and in writing in a clear and timely manner; ability to listen to and understand the clinical study team and statistical programming department are required.

o   Ability to effectively express concepts and points of view in individual and informal group situations.

o   Ability to present ideas in an organized and concise manner.

·         Strong problem-solving skill including debugging code, looking up reference materials and documentation, and contacting appropriate support.  He/she must be able to exercise sound judgment within departmental practices in selecting methods and techniques to solve problems.

·         Bachelor’s degree, preferably in statistics, math, computer science, or similar discipline is required.  A Masters degree in statistics is strongly recommended.

·         At least 7 years of experience in clinical application development (using SAS) in the pharmaceutical/biotech industry.  Experience in the preparation and/or defense of regulatory submissions is required.

·         Proficiency with SAS/BASE, SAS/STAT, SAS macros, SAS/GRAPH, PROC SQL, and PROC REPORT.

·         Must be familiar with basic statistical concepts, such as: linear regression analysis, analysis of variance, hypothesis testing, non-parametric analysis, categorical data analysis, confidence intervals, p-values and capable of implementing these ideas in clear, concise SAS code for the purposes of data analysis and reporting.

·         An understanding of clinical trial principles and regulatory requirements, including a basic knowledge of FDA/ICH guidelines and the software development life cycle; experience dealing with FDA/regulatory requests.

·         Strong familiarity with CDISC data structure including SDTM and ADaM.

·         Must be flexible and able to work both independently and as part of a team within a dynamic, interdisciplinary, small company environment.

·         Ability to prioritize and handle multiple tasks simultaneously is a must.

·         Strong documentation skills.

Sr. Database Developer – Los Angeles, CA

Dance Lessons for Mathematicians

Responsibilities include designing and creating a versatile process to transform data from disparate sources to flat file format that is optimized for processing, aggregating, maintaining, and querying.  We are looking for someone who has a deep understanding, knowledge, background, industry knowhow and is familiar with best practices ETL concepts, techniques, and tools.  The concepts and techniques include, but are not limited to, data loading frameworks, profiling, code optimization, process optimization, templates, compliance, naming conventions, and success metrics for maintainability, incremental load, data integration, meta-data, schedulers, source control, quality control and debugging.

Following existing policies, procedures, processes, methodologies, standards, creating and maintaining the data feeds.  The ideal candidate will consistently deliver high quality product with high attention to details within tight deadlines.

We are looking for someone who is a self-started, who can drive the project, has a strong sense of ownership, and who can influence others in a team environment. He or she will listen/ comprehend the reporting/ analytical needs of the users and creatively help implement data feeds that are optimized not only for business needs today, but that is forward looking a few years into the future.

ESSENTIAL SKILLS - Communication: Superior verbal and written presentation skills are required. – Implementation/Execution: Ability to combine industry knowledge, experience, innovative skills, and user input to create a flexible and an optimized infrastructure. Possess analytical skills to critically evaluate objectives and requirements and to translate them into work product. – Work Ethics: Must be able to simultaneously handle multiple projects and meet deadlines with proven ability to succeed in a high activity/pace environment with managing associated stress. – Problem Solving: You are a problem solver with the ability to encourage others in collaborative manner and ability to influence with deep subject matter expertise.

REQUIREMENTS - Bachelor’s degree in Information Science or related area.  – Minimum 2-3 years of experience in database development / ETL environment with at least one small/medium implementation with progressively larger degrees of responsibility and scope of implementation. – Experience with creating and data loading framework in multi-dimensional data models.

- Experience in Micro Strategy a plus.  Metadata, Dashboards, reports.

- Experience with all phases of the software development life cycle (SDLC).

- Knowledge of data modeling, meta data, testing, debugging, documenting, and business requirements documentation.

 

Sr. Statistical Programmer – E. SF Bay Area

The Sr. Statistical Programmer is responsible for developing and implementing SAS programs to

efficiently produce descriptive and statistical analyses, summary tables, data listings and graphics.

The Sr. Statistical Programmer typically works on complex problems in which analysis of situations

or data requires an in-depth evaluation of various factors, exercises judgment within broadly

defined practices and policies in selecting methods, techniques and evaluation criteria for obtaining

results, and may determine methods and procedures on new assignments and may provide

guidance to other lower level personnel.

RESPONSIBILITIES

Designs data warehouse, SCS, SCE databases. Uses creativity and ingenuity to solve complex

programming problems (e.g. creates reusable code, develops project/department standard

code, designs interconnected programs).

Serve as lead programmer and use professional concepts in accordance with company

objectives to solve complex problems in creative and effective ways for one or more clinical

studies.

Review and help develop documents related to study (Case Report Forms, Database

Specifications, Statistical Analysis Plans, TLF specifications, etc).

Define analysis dataset specification and ensure that specifications are met.

Development of data definition tables based on analysis dataset specifications and company

standards and policies.

Work with support programming team to program analysis datasets, listings, tables and figures

according to specifications.

Implement QA and QC validation in accordance with departmental SOP’s for deliverables

including:

- Formal study reports

- Data review committees

- Publications and meeting presentations

- Ad-hoc requests

 

REQUIREMENTS

Minimum of 7 years of SAS programming with 4 years of clinical trial experience.

B.S. in computer science, statistics, biology, or other relevant scientific area.

Candidate should be capable of clear and timely written and verbal communication with peers,customers, and management.

Able to give effective presentations to small groups such as Implementation Teams or Statistical Programming meetings.

*Must be a US Citizen or Green Card Holder

Director, ETL/Data Architect – Atlanta, GA

The ETL/Data Architect creates and maintains architectural best practices addressing data and technology in the context of business processes across company. The position provides leadership and direction for strategic data architecture and governance. The ETL/Data Architect is responsible for developing a strategy and framework to address all aspects of data lifecycles. The ETL/Data Architect determines and develops architectural approaches and capabilities for Master Data Management implementations.

 

Within the role, the individual will be a part of the team as a Senior ETL Developer.  The individual will be experienced in SAS Data Management Studio (DI Studio/DataFlux) with strong SQL and SAS skills and well versed in the SDLC lifecycle processes.  The scope of ETL design and development includes but is not limited to data extraction from heterogeneous data sources, data transformation (e.g., data cleansing), database loading, and production support to meet the data needs of the projects.  Individual should have experience with various databases, including MSSQL and PostgreSQL.

Duties and Responsibilities
Essential Functions:
 

  1. Develop and recommend strategies and specifications for (technical) data solutions based on the analysis of the business goals, objectives, needs, and existing data systems infrastructure.
  2. Data Modeling and experience in developing new logical, conceptual, and physical models for data and system flows
  3. Develop technical strategies and architectures for high-performance, scalable and complex enterprise-grade system
  4. Demonstrates expertise in a variety of the field’s concepts, practices, and procedures related to ETL/Data design and development.
  5. Produce sound logical data models and build efficient physical databases
  6. Work with SAS developers, business analyst, DBAs, system administrators, to architect data model, design and implement database as well as write ETL related programs.
  7. Manage the Enterprise Data Model, including data dictionary/metadata registry
  8. Manage the ETL process and development
  9. Propose proper database features for best design, customization, and user experience.
  10. Document programming problems and resolutions for future reference.

 

   B.   Experience (years and type):
  • 8-10 years’ experience in providing ETL via SAS and SAS/ETL tools
  • 8-10  years’ experience providing MDM Solutions
  • 5 years’ experience using MS SQL Server databases
  • 3 years’ experience providing PostrgreSQL/Oracle databases
  • 8-10  years’ experience supporting SAS Analytics environment utilizing Base SAS with particular strength with SAS macros, SAS ODS, SQL, and  hash tables.
  • 5 years’ platform experience in Linux/Unix
  • 5 years’ of experience within the Healthcare industry with HIPAA requirements, working with health insurance claims transaction data (5010 837), prescription drug claims, enrollment data and provider data, particularly experience extracting data from Medicaid and Medicare-Advantage data files; including Monthly Membership Report (MMR), the Model Output Reports (MOR) and RAPS files or the Medicare Standard Analytical Files.

 

   C.   Knowledge, Skills and Abilities:
  • Strong experience in designing and implementing MDM Solutions. Experience in leading MDM teams to deliver MDM Solutions, to define MDM architectures and defining MDM patterns.
  • Strong experience working with metadata repository and data modeling tools (e.g. Erwin, Rational Data Architect)
  • Strong understanding of Data Warehouse/MDM concepts (ETL, Star Schema, slowly changing dimensions).
  • Strong Experience in Data Profiling, enrichment and synchronization using MDM tools (e.g. SAS ,Oracle , IBM)
  • Strong knowledge of relational databases, Data Warehouse and business Intelligence solutions
  • Relies on extensive experience and judgment to plan and accomplish goals. Performs a variety of tasks.
  • Excellent teamwork and collaboration skills.
  • Experience in PL/SQL (functions, store procedures, packages, etc,).
  • Proficient in shell scripting and performance tuning within a Unix/Linux Environment
  • Excellent written/verbal communications skills.
  • Ability to meet deadlines with attention to detail and accuracy.
  • Ability to handle multiple concurrent tasks/projects according to priorities.
  • Ability to work in a group or team environment

 

 

SAS Programmer – Atlanta, GA

Dance Lessons for Mathematicians

Health care data analyst and programmer position with rapidly growing health care consultancy that supports health plans operating in the U.S. Medicare and Medicaid markets.  The successful candidate will directly utilize SAS programming with administrative claims data and other health care data sources including surveys and electronic records.  Position will primarily focus on managed care payer analytics to support business efforts but will also be involved in research and applications supporting health management/quality initiatives including evidence-based medicine, care delivery models, disease management, health care policy, and technology.  Must be willing to work under tight deadlines and must have a business and a customer service mindset.

Duties and Responsibilities

Essential Functions:

1.      Lead day-to-day schedules and performance of SAS development staff to support the objectives of all customer segments.

2.      Provide technical leadership to the SAS team by sharing knowledge and research of tools/techniques and features, and providing coaching as needed to develop each resource.

3.      Lead remote SAS developers (offshore/remote if necessary).

4.      Serve as a team liaison to project managers for SAS requirements.

5.      Lead and coordinate technical support for organization partner technologies.

6.      Define and create management tools to report staff progress.

7.      Coordinate and communicate customer and system issues with company’s internal resources.

8.      Ensure policies and procedures are followed to insure organization is compliant with HIPAA and other privacy / security requirements.

9.      Address problems from an economic, management, public policy, or sociological perspective as well as possess necessary proficiencies in research design, programming and statistics that are central to applying quantitative analysis to health care problems.

10. Experience working with health insurance claims transaction data, prescription drug claims, enrollment data and provider data, particularly experience extracting data from Medicare-Advantage data files including Monthly Membership Report (MMR), the Model Output Reports (MOR) and RAPS files or the Medicare 5% Standard Analytical Files.

11.  Designing and developing project-specific SAS programs, often producing analysis datasets, reports, or graphics

12. Extraction, transformation and loading (ETL) of a very large tables of health care data from text-formatted datasets.

13.  Development of utilities for QC/QA and analyses

14.  Ability to deliver ad-hoc reporting as requested

 

   B.   Experience (years and type):
  • 5+  years’ experience supporting SAS Analytics database environment
  • 2 year of experience within the Healthcare industry with HIPAA requirements
  • 3+ years’ experience working against MSSQL/ MySQL/PostrgreSQL databases
  • 3+ years’ experience of delivering SAS solutions via web based solutions
  • 3+ years’ experience of delivering SAS solutions on Linux platform

 

 

   C.   Knowledge, Skills and Abilities:
  • Expert knowledge of SAS 9.2 on Linux platform, using Enterprise Guide and the Enterprise Business Intelligence Suite.
  • Excellent knowledge and command of Base SAS with particular strength with SAS macros, SAS ODS, SQL, hash tables, Proc Report and Proc Template.
  • Demonstrated understanding of good software development practices.
  • Significant demonstrated experience with data set creation and data manipulation (sorting, merging, variable creation).
  • Experience programming against multimillion record data files.
  • Ability to program other high-level languages is beneficial.
  • Must be flexible, capable of multi-tasking, willing to learn new technologies, demonstrate initiative and self-motivation, and be able to work independently or as part of a team.
  • Strong written and verbal skill in technical and non-technical forums is vital to this position.
  • Reliable and efficient time management skills.

 

 

Must be a US citizen or Green Card holder

Marketing Analyst – Novato, CA

dogpic

This is a permanent job, but could possibly be a contract, or contract-to-hire if needed. Must be a US Citizen or Green Card Holder. Applicant must live in the San Francisco Bay Area, although a portion of the work can be done remotely, from home.

This critical position reports to the VP of Marketing and Ecommerce and is responsible for providing data driven information and insights regarding customers, competitors, industry trends, and campaign effectiveness to measure and support business decisions.

JOB RESPONSIBILITES:

  • Develop and maintain analyses, reporting, and use of key metrics that drive informed investment decisions across all marketing channels. Included are HouseFile growth models, LTV analysis across acquisition sources and merchandising categories, sales attribution and matchback, optimized customer contact strategies across on-line and off-line vehicles
  • Partner with Finance and Marketing to develop daily, weekly, monthly, quarterly, and yearly order and revenue forecasts that support operations – Inventory management, call center, distribution center.
  • Assist in the development and management of weekly marketing reports across all the channels (eg. Catalog, email, on-line) that allow the business owners to easily manage and maintain their own reporting while communicating key drivers.
  • Manage the development of circulation models using transactional, third-party data, and other customer engagement variables that drive housefile and prospecting response.
  • Construct A/B testing for marketing campaigns and web pages
  • Develop, execute, and analyze surveys to inform marketing and product features.
  • Perform Ad Hoc analysis as needed.
  • Constantly drive for automation and process improvements across all operational, reporting, and analytic queues.
  • Other duties as assigned

KNOWLEDGE, SKILL & EXPERIENCE:

  • 5+ years experience using MS Transact SQL. Knowledge of SSIS preferred but not required
  • Eagerness to learn business processes and grasp new concepts
  • Experience with applied statistics preferred but not required
  • Ability to effectively manipulate data using Excel and other MS Office tools
  • Experience with web analytic tools such as Coremetrics, Site Catalyst, or Google Analytics preferred but not required
  • Strong written and verbal communication skills
  • Very detail-oriented and organized while working in a very fast-paced environment
  • Ability to work in a team environment as well as on self-directed projects