Data Engineer & Developer

Overall Responsibility:

The Data Engineer & Developer is responsible for designing, developing, testing, and maintaining SQL-based data solutions that support operational processing, analytics, and enterprise reporting. This role focuses on hands-on development within SQL Server and Microsoft Fabric database workloads, including the creation of T-SQL stored procedures, views, functions, scripts, and scheduled jobs that enable reliable data movement, transformation, and downstream consumption. The position also supports the organization’s transition toward Microsoft Fabric by applying modern ELT patterns, environment-aware deployment practices, version control discipline, and repeatable release methods. This role is development-focused and does not include database administration responsibilities such as backups, patching, high availability/disaster recovery, or server administration.

This role is to be hired in San Pedro Sula, Honduras.

Duties:

SQL Development & Data Solutions Engineering

• Design, develop, test, and maintain T-SQL stored procedures, functions, views, scripts, and complex queries supporting operational and analytical workloads.
• Build and apply robust SQL development patterns, including parameterization, transaction handling, idempotency, exception handling, and logging/auditing.
• Develop transformation logic supporting incremental loads, late-arriving data, reprocessing, and traceability across environments.

Performance Optimization & Code Quality

• Refactor and optimize SQL code by analyzing execution plans, improving query performance, and implementing effective indexing strategies.
• Support data quality and reconciliation by embedding validation checkpoints, monitoring, and exception handling into solutions.
• Contribute to development standards such as naming conventions, SQL style guidelines, and code review practices.

Data Pipelines, Ingestion & Architecture

• Implement ingestion and ELT patterns using layered architectures (landing, staging, curated) for reliable data processing.
• Support ingestion from SQL Server, cloud/on-prem systems, and APIs using standardized methods.
• Create and manage SQL-based objects within Microsoft Fabric (Warehouse, Lakehouse SQL endpoints, and related artifacts).

Automation, Scheduling & DevOps Practices

• Develop and maintain SQL Server Agent jobs, schedules, alerts, and automation workflows.
• Implement job orchestration patterns that improve reliability, handle failures, and reduce manual dependencies.
• Use GitHub for version control and participate in CI/CD processes to ensure safe and repeatable deployments.

Collaboration, Governance & Documentation

• Collaborate with Data Engineering and platform teams to align with architecture standards, governance, and release processes.
• Document database objects, dependencies, deployment procedures, and operational runbooks for maintainability and auditability.
• Perform additional duties and special projects aligned with enterprise data engineering and analytics priorities.