Global Healthcare Exchange (GHX) is a healthcare business and data automation company, empowering healthcare organizations to enable better patient care and maximize industry savings. The Software Engineer III will work on the Content Tooling solution with a focus on data engineering and analytics, responsible for creating and supporting data-intensive software solutions.
Responsibilities:
- Design and implement complex SQL queries, stored procedures, and database optimization strategies
- Develop and maintain ETL (Extract, Transform, Load) pipelines for data ingestion and transformation
- Design and develop data architecture, data models, and data manipulation structures for content management systems
- Build and optimize data warehousing solutions using cloud-based platforms
- Create and maintain analytics reports and dashboards for business stakeholders
- Perform data quality validation and implement data governance best practices
- Translate ideas into clear, maintainable code with minimal supervision and perform code reviews
- Coordinate with cross-functional teams including product, analytics, and offshore development teams in an Agile/Scrum environment
Requirements:
- Bachelor's degree in Computer Science, Engineering, Data Science, or related degree
- 5+ years of experience writing complex SQL queries including joins, subqueries, window functions, and CTEs with relational databases (PostgreSQL, MySQL, SQL Server)
- 3+ years of experience designing and implementing ETL processes and data pipelines
- Experience with data modeling (dimensional modeling, normalization/denormalization, star/snowflake schemas) and data transformation techniques
- Experience with programming languages used in data engineering (Python, Java), version control systems (Git), CI/CD pipelines, and Agile/Scrum environments
- Proficient with multiple technologies including SQL databases, ETL tools, cloud data platforms, and data visualization tools
- Expert-level SQL development skills with deep understanding of query optimization and performance tuning
- Strong understanding of ETL design patterns, data pipeline architectures, and data orchestration
- Identifies, implements, and applies best practices for data engineering; is the 'go to' person on the team
- Ability to handle multiple projects and possesses a proven track record of high-quality deliverables
- Delivers code with high quality and throughput consistently
- 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
- Hands-on experience with Snowflake data warehouse and Sigma Computing for building analytics reports and dashboards
- Knowledge of healthcare supply chain or healthcare IT systems