SQL Developer with Clarity

  • location: Pasadena, CA
  • type: Contract
  • salary: $48.50 - $51.54 per hour
easy apply

job description

SQL Developer with Clarity

job summary:
Randstad Technologies is currently seeking a talented Sr. It Business Analyst to join a well-known client of ours within a location in the Pasadena, CA area.

We are looking for a talented SQL Programmer with advanced Excel and some Tableau experience to join our team. The SQL Programmer should have a minimum of three years of programming in SQL Oracle. This individual should be able to clearly and logically translate internal client needs and issues into reporting that provides useful insight into how we can better serve our members. The ideal candidate will have experience working with large health care datasets.

This position includes report development in Teradata and Oracle Exadata, providing product support to Business partners including: - issue resolution, root cause analysis, ensuring reports process timely and accurately, and developing new reports.

Must be legally authorized to work in the U.S. without sponsorship.

location: Pasadena, California
job type: Contract
salary: $48.50 - 51.54 per hour
work hours: 8am to 5pm
education: Bachelors
  1. Develops reports with accurate, easy to read, useful information.
  2. Translates needs, issues, and ideas into effective strategies and action plans.
  3. Advises and recommends areas of program planning, business management, budget execution and program coordination.
  4. Prepares needs assessment.
  5. Validates resource requirements and develops cost estimate models.
  6. Conducts and coordinates financial, product, market, operational, and related research to support strategic and business planning within the various departments and programs of the client group.
  7. Interprets, evaluates, and interrelates research data, and develops integrated business analyses and projections for incorporation into strategic decision-making.
  8. Plans and coordinates the development of primary and secondary market research studies in support of strategic planning and specific marketing initiatives, as required, and presents findings of studies to client committees.
  9. Provides consultative, technical, and staff support, as appropriate.
  • 7+ years providing support in a technical environment, prefer reporting support environment.
  • 5+ years experience with writing reports from relational databases
  • 5+ years experience with report development utilizing reporting tools
  • 3+ years experience with Epic/Clarity module
  • 3+ years experience with SQL Oracle
Preferred Experience:

  • T-SQL, Teradata, Oracle Exadata, MS Access, Visual Basic
  • Must have advanced MS Excel skills, experience with MS SQL Stack (SSMS, SSIS, SSAS), and building reports and dashboards inTableau.
  • Knowledge of Microsoft Office Suite products including Word, Powerpoint, Visio.
  • Knowledge of Healthcare systems for Clinical Care, Practice Management- Experience with developing web content. - Experience working in large corporations.
skills: Top 3-5 Required Skills:

  1. Experience with analytical manipulation and interpretation of large databases required.
  2. Broad familiarity with medical practices, especially revenue cycle management and process and outcomes measurement preferred.
  3. Very strong analytic and critical thinking skills, writing skills, communication skills, consulting skills, and ability to work within a team.
  4. Must be an independent self-starter.
  5. Clarity Data Model Certifications or Proficiencies in Resolute Hospital Billing, Resolute Professional Billing. Other modules preferred but not required - ADT & Prelude.
Desired Skills:

  1. Ability to express complex analytical and technical information to senior management or to audiences with clinical training.
  2. 3 years programming in SQL Oracle.
  3. Advanced Excel.
  4. Experience building reports and dashboards in Tableau.
Soft Skills:

  1. 3 years of related analytical consulting experience, healthcare experience preferred.
  2. Knowledge of project management principles, practices, techniques, and tools.
  3. Knowledge and appreciation of business concepts and requirements as applicable to a large academic, research, and/or health care facility.
  4. Knowledge and understanding of business research principles, processes, and techniques.
  5. Ability to develop and prepare business analyses and plans.
  6. Ability to develop and deliver presentations.
  7. Knowledge of the principles of strategic business decision-making.
  8. Ability to process computer data and to format and generate reports.
  9. Ability to create, compose, and edit written materials.
  10. Consultative and advisory skills.
  11. Skill in the use of survey and market research methodologies, systems, and techniques.
  12. Skill in the use of computerized spreadsheet, relational database, and word processing software.

Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

Qualified applicants in San Francisco with criminal histories will be considered for employment in accordance with the San Francisco Fair Chance Ordinance.

We will consider for employment all qualified Applicants, including those with criminal histories, in a manner consistent with the requirements of applicable state and local laws, including the City of Los Angeles' Fair Chance Initiative for Hiring Ordinance.

easy apply

get jobs in your inbox.

sign up

related jobs

    Oracle Developer

  • location: Los Angeles, CA
  • job type: Permanent
  • salary: $105,000 - $115,000 per year
  • date posted: 9/6/2019

    Salesforce Developer

  • location: Los Angeles, CA
  • job type: Contract
  • salary: $50 - $70 per hour
  • date posted: 9/13/2019