Technical Data Analyst III

Responsibilities

• Write and optimize complex SQL queries including nested joins, temp tables, aggregations, window functions, and CTEs
• Identify patterns and relationships to evaluate, maintain, and enrich data quality across multiple systems and data sources
• Perform root cause analysis (RCA) and impact analysis to identify data quality issues and report findings to stakeholders
• Develop flexible, reusable, and efficient SQL code with minimal supervision while adhering to best practices
• Create and maintain analytics reports and dashboards for business stakeholders using modern BI tools
• Conduct data profiling and data quality validation to ensure high-quality data for downstream consumers
• Perform code reviews on SQL and data scripts, providing constructive feedback to ensure quality
• Collaborate with cross-functional teams including data engineering, product, and analytics teams in an Agile/Scrum environment

Knowledge and Skills

• Proficient with multiple technologies including SQL databases, data analysis tools, BI platforms, and scripting languages
• Expert-level SQL skills with deep understanding of complex queries, query optimization, and performance tuning
• Strong analytical skills including data mining, evaluation, analysis, and visualization
• Identifies, implements, and applies best practices for data analysis and quality; is the “go to” person on the team
• Ability to handle multiple projects and possesses a proven track record of high-quality deliverables
• Delivers high-quality analysis and SQL code with consistency and throughput
• Effectively communicates technical concepts to both technical staff and cross-functional teams with varying degrees of technical experience
• Possesses a broad understanding of Agile/LEAN principles and ability to apply agile methodology effectively

Required Experience

• Bachelor’s degree in Computer Science, Data Science, Information Systems, or related degree
• 5+ years of experience writing complex SQL queries including nested joins, temporary tables, aggregations, subqueries, window functions, and CTEs
• 5+ years of experience with relational databases (PostgreSQL, SQL Server, MySQL) and SQL query performance optimization
• Experience with data profiling, data quality assessment, data validation techniques, and finding insights in large, complex data sets
• Strong analytical skills including data mining and evaluation, with demonstrated ability to perform code/query reviews in Agile/Scrum environments

Preferred Experience

• Hands-on experience with Snowflake data warehouse and Sigma Computing for building analytics reports and dashboards
• Familiarity with healthcare data rules and standards (HIPAA, HL7) or healthcare supply chain/IT systems

The compensation for this role is: $67,000-$89,500

The base salary range represents the anticipated low and high end of the GHX’s salary range for this position. Actual salaries will vary based on various factors, such as the candidate’s qualifications, skills, competencies and proficiency for the role. The base salary is one component of GHX’s total compensation package for employees. Other rewards and benefits include: health, vision, and dental insurance, accident and life insurance, 401k matching, paid-time off, and education reimbursement, to name a few. To view more details of our benefits, visit us here: https://www.ghx.com/about/careers/

#LISR

GHX: It's the way you do business in healthcare

Global Healthcare Exchange (GHX) enables better patient care and billions in savings for the healthcare community by maximizing automation, efficiency and accuracy of business processes.

GHX is a healthcare business and data automation company, empowering healthcare organizations to enable better patient care and maximize industry savings using our world class cloud-based supply chain technology exchange platform, solutions, analytics and services. We bring together healthcare providers and manufacturers and distributors in North America and Europe - who rely on smart, secure healthcare-focused technology and comprehensive data to automate their business processes and make more informed decisions.

It is our passion and vision for a more operationally efficient healthcare supply chain, helping organizations reduce - not shift - the cost of doing business, paving the way to delivering patient care more effectively. Together we take more than a billion dollars out of the cost of delivering healthcare every year. GHX is privately owned, operates in the United States, Canada and Europe, and employs more than 1000 people worldwide. Our corporate headquarters is in Colorado, with additional offices in Europe.

Disclaimer

Global Healthcare Exchange, LLC and its North American subsidiaries (collectively, “GHX”) provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, national origin, sex, sexual orientation, gender identity, religion, age, genetic information, disability, veteran status or any other status protected by applicable law. All qualified applicants will receive consideration for employment without regard to any status protected by applicable law. This EEO policy applies to all terms, conditions, and privileges of employment, including hiring, training and development, promotion, transfer, compensation, benefits, educational assistance, termination, layoffs, social and recreational programs, and retirement.GHX believes that employees should be provided with a working environment which enables each employee to be productive and to work to the best of his or her ability. We do not condone or tolerate an atmosphere of intimidation or harassment based on race, color, national origin, sex, sexual orientation, gender identity, religion, age, genetic information, disability, veteran status or any other status protected by applicable law. GHX expects and requires the cooperation of all employees in maintaining a discrimination and harassment-free atmosphere.…