Database Developer

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, SSRS 2 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. My3Tech Inc