Job Listings

Senior SAS Data Integration/ Data Quality Architect – HealthCare Industry

Dance Lessons for Mathematicians

Must be a US citizen or Green Card Holder. Preferred location is Raleigh, NC, though other locations will be considered.

We are looking for an individual who demonstrates the following attributes:

• Health Care Domain Expertise: The individual will have a strong background in health care data including: HL7, medical record information, claims information, demographic/registration/ eligibility data.

• Technical Leadership: Strong experience in conceptualizing end-to-end solution architectures. Ability to guide other consultants with detailed reviews of their work and providing overall technical leadership. They have proven leadership skills either by managing technical teams or in a previous role as an architect responsible for laying the foundation for significant work.

• Multi-Faceted: A track record in charting untested waters. They need to demonstrate that they have the conceptual skills to learn new technologies, and contribute to areas such as infrastructure, administration, security with ease.

• Value Orientation: Our solution architects work closely with our engagement managers who lead our projects to deliver value. Unlike traditional project managers who focus solely on managing the cost and schedules, our engagement managers serve as true leaders for the engagement, creating value in all aspects of the project. Our consultants constantly calibrate their activities to ensure that they are focused on value and not solely on technical activities.

Minimum Requirements

• 10 + Years of experience in data management. Of which, at least 5 years need to be in health care data management acquired at a payor/ provider or a consulting firm that services these organizations

• Able to lead and support the customer with making decisions, recommending suitable DQ (match coding) / ETL approaches, recommending data model approaches

• Experience in creating ETL jobs using SAS Data Management Advanced / SAS DI Studio.

• Experience in developing data integration jobs that involves large volumes of healthcare data and optimizing performance of such jobs. Strong understanding of databases and SQL programming.

• General knowledge of SAS BI / EM / SAS programming

• Experienced in health care data modeling

• Ability to partner with business/ analytical staff and

• Inquisitive and quick learner capable of learning skills they do not possess We are looking for an individual who will lead our team in health care data management. We are looking for an individual who demonstrates the following attributes:

• Undergraduate degree in technical discipline

• Willingness to travel up to 40%

Preferred Requirements

• Knowledge of Hadoop

• Experience with SAS DataFlux

• Experience with Oracle and XML

• General experience / knowledge of web services, XML, etc.

• Ability to train customer personnel on SAS EG / DI and DQ, at a high level

• Master’s degree in Health Care related area or Computer Science

 

Predictive Modeler – Contract – Los Angeles

This is a short term (around 4-6 month) contract position. We are looking for a contractor that can create a Score Cards for our client.  Must be a US Citizen or Green Card Holder. Must work on-site.

Base expertise:

1.   Deep knowledge and experience in creating score cards, predictive models, clusters and others using advanced statistical and modeling techniques (multi-variant regression (several types) clustering, trees, others)

2.      Ability to understand complex data

3.      Ability to extract data (variables) from data using SQL; create Master Data tables

4.      Cleansing and readying data for use in Predictive Models

5.      Profiling and base-lining data

6.      Create value added and or intelligent variables from data

7.      Determine and choose statistical and predictive modeling techniques for the objective and insights from data profiling

8.      Run several predictive modeling techniques to determine the optimum technique for the objective

9.      Creating and implementing scorecards

10.  Documentation

11.  Business Presentation and explanation

12.  Do all the statistical work using SAS and or CART

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