Senior MS SQL Server DB Developer - Remote Reporting

Powerfront; Colombia; A distancia; COP 280.260.000 - 404.820.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Remote workforce

Competitive salary

Great culture

Prestigious brands

Career progression

Global clients

Descripción de la vacante

Powerfront is recruiting a Senior MS SQL Server Database Developer focusing on reporting within the Customer Service domain. The role centers on crafting complex queries, data analysis, and optimizing database performance to support our SaaS product for customer service operations.

You will work in a global remote setup with a team that values cutting-edge AI-driven engagement and real-time customer experience enhancements.

Formación

• Design and implement complex SQL queries and stored procedures for reporting.
• Translate stakeholder reporting needs into efficient queries for customer service data.
• Analyze and optimize queries to improve performance and KPI reporting for CS data.
• Develop data models and schemas tailored to customer service reporting needs.
• Monitor performance and apply tuning like indexing/partitioning for efficiency.
• Create ETL processes to load CS data into SQL Server.
• Ensure data integrity, security, and proper backups for CS datasets.

Responsabilidades

• Design complex SQL queries and stored procedures for reporting in CS domains.
• Collaborate with stakeholders to translate CS data needs into efficient queries.
• Analyze and optimize queries to improve response times, CS metrics, and satisfaction scores.
• Maintain data models and schemas for CS reporting requirements.
• Monitor performance and implement indexing/partitioning strategies.
• Create and maintain ETL pipelines from various CS data sources.
• Ensure data accuracy, integrity, and security for CS data.

Conocimientos

MS SQL Server

T-SQL

Stored procedures

Data modeling

ETL

Performance tuning

Reporting

DB design

Security

Data analysis

Educación

Bachelor's degree in CS/IT

Descripción del empleo

Powerfront is recruiting a Senior MS SQL Server Database Developer focusing on reporting within the Customer Service domain. The role centers on crafting complex queries, data analysis, and optimizing database performance to support our SaaS product for customer service operations.

You will work in a global remote setup with a team that values cutting-edge AI-driven engagement and real-time customer experience enhancements.