SQL Programmer
Career Match Solutions
Charlotte, NC
See who Career Match Solutions has hired for this role
See who Career Match Solutions has hired for this role
Role Summary
The SQL Programmer is responsible for developing expert‑level, reusable SQL code assets—including stored procedures, functions, and optimized queries—that strengthen the organization’s analytics environment. This role ensures high‑quality data transformation, reliable data pipelines, and standardized logic that supports reporting, dashboards, and advanced analytics.
Core Competencies
The SQL Programmer is responsible for developing expert‑level, reusable SQL code assets—including stored procedures, functions, and optimized queries—that strengthen the organization’s analytics environment. This role ensures high‑quality data transformation, reliable data pipelines, and standardized logic that supports reporting, dashboards, and advanced analytics.
Core Competencies
- Advanced SQL Development — Demonstrates mastery in writing complex SQL queries, stored procedures, views, and user‑defined functions; applies best practices for performance, readability, and maintainability.
- Reusable Code Architecture — Designs modular, scalable SQL components that can be leveraged across analytics workflows; builds standardized logic libraries to reduce duplication and improve consistency.
- Data Transformation & ETL Logic — Translates business and analytic requirements into efficient SQL‑based transformation processes; ensures data accuracy, completeness, and alignment with governance standards.
- Performance Optimization — Diagnoses and resolves query bottlenecks; applies indexing strategies, execution plan analysis, and tuning techniques to improve system performance.
- Collaboration & Requirements Translation — Works closely with analysts, informatics staff, and data engineers to understand needs, refine requirements, and deliver SQL solutions that support analytic use cases.
- Quality Assurance & Validation — Implements testing, validation, and documentation practices to ensure SQL code produces reliable, repeatable, and well‑governed outputs.
- Data Governance Alignment — Adheres to organizational standards for data security, naming conventions, version control, and documentation; contributes to the development of shared SQL coding standards.
- Develops expert‑level SQL scripts, stored procedures, and functions that support analytics and operational reporting.
- Builds reusable code assets and standardized logic to streamline data processing across teams.
- Optimizes complex queries and data transformations for performance and scalability.
- Collaborates with analytics and informatics teams to translate requirements into SQL‑based solutions.
- Provides complete documentation of codes and projects done throughout the engagement.
- Ensures data quality through validation, testing, and documentation.
- Supports the development of coding standards, governance practices, and reusable logic libraries.
- Ensures data quality through validation, testing, and documentation.
- Supports the development of coding standards, governance practices, and reusable logic libraries.
-
Seniority level
Entry level -
Employment type
Full-time -
Job function
Information Technology -
Industries
IT Services and IT Consulting
Referrals increase your chances of interviewing at Career Match Solutions by 2x
See who you knowSimilar jobs
People also viewed
-
Full Stack Developer
Full Stack Developer
-
Software Developer
Software Developer
-
Salesforce Data 360 developer
Salesforce Data 360 developer
-
Senior Oracle APEX Developer II
Senior Oracle APEX Developer II
-
PostgreSQL Database Developer with Security Clearance
PostgreSQL Database Developer with Security Clearance
-
Senior Oracle APEX Developer
Senior Oracle APEX Developer
-
Java-Oracle-PLSQL Developer (Flexcube/OBPM)
Java-Oracle-PLSQL Developer (Flexcube/OBPM)
-
GenAI Python Systems Engineer – Experienced Associate
GenAI Python Systems Engineer – Experienced Associate
-
AWS Redshift ETL Developer
AWS Redshift ETL Developer
-
Senior Python Developer
Senior Python Developer
Similar Searches
Explore top content on LinkedIn
Find curated posts and insights for relevant topics all in one place.
View top content