Database Developer
samprasoftOakland (CA)
About the role
Consultant Position The Consultant will work with the Patient Outreach teams to understand patient follow up appointments that are performed in the clinics, this data is in Clarity tables. Upon gathering the data required we would tie the Medical Record and Patient Medical Information into the product performance tool using Tableau. This allows the MART group to track statistics and overall patient outreach performance. The ideal candidate is a great team player, will have a minimum of 5 years of database development and will show interest and have been exposed to a multitude of technologies. She/he would have excellent analytical skills with experience in working with web analytics tools, writing SQL queries, and proficient in creating reports with Tableau. We love what we do here and need someone who equally shares the joy and passion of working with data. If you are that person, we are looking for you!
Principal Responsibilities:
- Strong experience and understanding in Clarity and table structures (over 500 tables)
- Experience pulling information from Clarity and building into Tableau reporting
- Extremely strong database skills (MySQL, SQL Server)
- Database development, querying, reporting and data migration
- Develop complex SQL queries, stored procedures, and SSIS packages
- Write, optimize, and tune complex SQL scripts
- Proven ability to write and develop reports in Tableau
- Must have a thorough knowledge of, and experience building ETL jobs utilizing SSIS packages for data import, export, normalization, and manipulation
- Meet with business experts to analyze and document requirements from a database perspective
- Building customized interactive reports and dashboards, report scheduling in Tableau Server
- Establish and maintain working relationships with technical and architectural team members across the technology organization
Minimum Requirements:
- Must have 5+ years of experience in Clarity
- Exposure to web analytics
- Must demonstrate a clear understanding of the logical and physical database design and data normalization concepts
- Must have extensive hands-on experience with MS SQL Server 2016 SSIS, MS SQL Server 2016, SSRS2 years of experience with Tableau and Tableau Server
- Previous experience with Kaiser Permanente
Required Skills:
Basic Qualification: Additional Skills: San Francisco Bay Area Consultants are required.
Before you apply
Applying takes about a minute. These four things decide how fast it moves after that.
Your profile is current
It's what we read first. Occupations, seniority and locations matter more than a long history.
Two examples you can talk through
Not a portfolio — just two pieces of work where you can explain the decisions and what you'd change.
A number in mind
What you're on now and what would make you move. We negotiate better when we know both.
Your notice period
Employers plan around it, and it's the question that stalls offers most often.
Once you apply, someone reads it and calls you before anything reaches the employer — usually within two working days.