Job Listings

Database Administrator – Redmond, WA – CONTRACT

iStock_000008942406XSmall

This is a short-term contract position. The key to success in this position is to build a cloud-based SQL database from the ground up that allows for smooth data imports/extraction, data transfers through API calls, reporting, and data quality control.

·         Use your analytical thinking and communication skills to identify database requirements by interviewing relevant team members, analyzing department applications and operations, and evaluating existing systems.

·         Recommend data solutions by defining architecture of database and functional capabilities, with appropriate information security and HIPAA compliance, back-up, and recovery specifications.

·         Build data models and pipelines to securely and efficiently move personal and health data between various sources through our cloud-based data warehouse system with smartly designed, scalable, reliable code.

·         Create database to communicate fluidly with salesforce.com and other technology partners, and automate data transfers wherever and whenever possible for best use of data team time and resources.

·         Utilize your attention to detail and high standards to maintain, triage, and solve database issues quickly.

·         Document all database process and procedure and train team members on proper and efficient utilization.

·         Use your conceptual and analytical thinking to define data integration and reporting requirements.

·         Demonstrate your fantastic written and verbal communication skills by initiating and managing cross-departmental communication to resolve any integration-related questions and issues.

·         Work with Sales and Marketing team to respond to technical RFP questions. Document technical RFP responses for use in future RFPs.

·         Utilize your analytical and problem solving skills to manage issues and escalate as needed to the Account Director, and other teams such as Coaching, Biometrics, and Design.

·         Bachelor’s degree in Computer science or equivalent degree

·         Expert with MS Products – specifically excel, CSV and database software

·         Expert with SQL and SSIS and previous experience with Amazon Web Services and building a cloud-based database

·         Be able to handle light HTML work

This is an on-site position. Please only apply if you are local to the area.

Business Intelligence Analyst II – San Diego

The start of a profitable friendship!

Summary: The Business Intelligence Analyst II is responsible for the implementation, integration and expansion of the existing Data Warehouse and creation of focused Data Marts to meet the operational and organizational needs of department decision makers. Works with clinical and non-clinical clients designing a reporting infrastructure to meet organizational and operational requirements. Supports existing tools and adoption of standard strategic tools to support the Data Warehouse. Must have strong analytical, leadership, communication and documentation skills. Business Intelligence Analyst II will analyze customer requirements and translate them into solid system design, with an emphasis on improving user productivity and business decision making. The Decision Support Systems Team is an experienced group of twenty-two dedicated to the support of the organization in data reporting and decision making. A dynamic group of individuals, the Decision Support Systems Team is a great place to learn, produce, and have fun while delivering quality results and success to our customers. Sharp HealthCare’s Information Technology department is nationally recognized within the Health Care industry.

Required Skills and Qualifications:

Bachelor’s degree in an applicable field (computer science, business administration, nursing or health care administration).

Three to five years recent experience working with business intelligence tools that included system analysis and/or information technology activities.

Proven experience analyzing complex issues and/or requests to provide effective solutions.

Strong understanding of data warehousing principles and experience working with large data sets.

Experience with simple query commands using an Oracle database.

Ability to work with management, staff, physicians and vendors translating business reporting needs and/or operational reporting requests into technical requirements.

Understanding and experience developing project plans, scope documents and managing time lines such that project deliverables are thoroughly communicated to the client and deadlines are met.

Proven skill set in applying IS principles and practices to systematically interpret functional requirements into application design and the ability to communicate technical issues to non-technical customers.

Experience working in a fast paced environment where multiple duties are performed to meet client expectations and deadlines.

*must be a US citizen or Green Card Holder.

Excellent communication skills, both written and verbal. 
 
Preferred Skills and Qualifications
 
Two years’ experience working in a healthcare environment.
Experience with financial data.

Data Scientist – Los Angeles

Dance Lessons for Mathematicians

This position creates statistical and predictive models and scorecards for Revenue, Risk, Marketing, Customer Care, and other areas. The position will use various statistical techniques including clustering, advanced regression, data mining, and multivariate modeling for model creating and provide actionable insights, create segments and segment profiles. Additionally, this position will be primarily responsible for implementation of the models and scorecards. Other responsibilities include preparing reports and dashboards using trends, vintage, cohort, and comparative analysis. The person in this job will be constantly looking to improve and optimize existing models.

We are looking for a self-starter with a strong sense of ownership. The incumbent will work independently with all levels of the company, including executive, senior, and department management and with external vendors and clients. The ideal candidate will have the ability to consistently deliver projects of high quality with excellent attention to detail within tight deadlines. The successful person in this role will collaborate with the Data Warehouse team as a subject matter expert and help write business requirements for creating optimal data models for use in his/her job.

Responsibilities

Communication: Superior verbal and written presentation skills are required. Actively listen to others to understand their perspective and ensure continuous understanding regardless of communication channel or audience. Ability to present complex topics and analysis in easy to comprehend manner. Ability to summarize data into useful information using visual and other graphical approaches for leadership audiences.

Implementation/Execution: Combine consultative skills with analytical knowledge to critically evaluate objectives and present solutions. You are a problem solver with the ability to encourage others in collaborative manner and ability to influence with deep subject matter expertise.

Statistical Skills: You are savvy and extremely comfortable with statistical software and using related techniques, including data preparation and analysis. Demonstrate skill in data analysis techniques by resolving missing/ incomplete information, inconsistencies/anomalies within complex data environment.

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. Outstanding ability to work independently, within a team, and across various departments.

Requirements
Master’s degree in economics, statistics, or mathematics
Minimum 3 years of experience in a similar area
Outstanding analytical abilities with a steep learning curve
Leadership qualities in the analytical area with ability to lead critical “thought process” discussions
Must have advanced knowledge of SAS, R, and or other statistical tools
Experience in SQL, Python, and other languages

e-mail resume to molly@synchrony-solutions.com

Sr. Analyst – Seattle

Dance Lessons for Mathematicians

Must be a US citizen or Green Card Holder. e-mail molly@synchrony-solutions.com

Job Description:
The Operations Insights team is responsible for supporting the Customer Service Organization by providing business insight and actionable intelligence to drive strategic business recommendations and initiatives. The Sr. Analyst provides analytic support by dissecting large data sets and structuring a wide range of complex business problems, extracting and analyzing data from a variety of sources, utilizing facts/data to derive a conclusion, and constructing presentations that distill complex analytical findings into communications that are intended to inform and influence executive level audiences. Works independently to develop critical business partnerships to drive cross-functional business engagement, analysis and collaborative issue resolution recommendations.

The Sr. Analyst is an individual contributor who is extremely analytical, thrives on the challenges inherent in dissecting complex problems, who utilizes facts/data to derive conclusions and delivers clear recommendations to improve results. The ideal candidate likes to roll up their sleeves and get their hands dirty with data, spreadsheets, and models. Analytical dexterity and excellent communication skills are critical to success in this position.

Qualifications:
Bachelor’s Degree or equivalent work experience required
5 years knowledge, or experience working with SAS or other Statistical analysis tools
2+ years experience in a hands on analytical role, with focus on Root Cause Analysis and Behavioral Analysis
Experience in operational analysis of corporate initiatives preferred
Experience in statistical analytics and statistical tools (SAS, R, or other) preferred
Proficient in MS-SQL and 5 years hands-on experience in accessing (Data Mining) and manipulating data from multiple relational databases (Teradata, Oracle, MS-SQL server)
Business Intelligence (BI) Experience
Highly proficient in Excel, Access, and PowerPoint Advanced skills in report development and data analysis is required
Excellent communication skills (verbal and written)

Responsibilities:
Will be responsible for extracting data from multiple sources, manipulating data/data validation, conducting root cause analysis, developing solutions/recommendations and presenting to Sr. Leadership
Requires competency in customer focus, change & innovation, strategic thinking, relationship building & influencing, talent management, results focus and inspirational leadership.
Query data from relational databases (Teradata, MS SQL server)
Ability to perform data validation, analysis and modeling (Root Cause Analysis, Behavioral Analysis)
Develop Executive Level presentations and present complex, customized analytic findings to senior management
Lead continuous improvement initiatives for the Call Center (Direct to Customer) Organization
Create and distribute high level business performance reporting
Build cross functional relationships to drive strategic discussions and continuous improvement

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