SQL Programmer

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

• 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.

Key Responsibilities

• Develops expert-level SQL scripts, stored procedures, and functions that support analytics and operational reporting.
• Buils 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.