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.
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.
Preference
Ensures data quality through validation, testing, and documentation.
Supports the development of coding standards, governance practices, and reusable logic libraries.