Senior Ai Database Developers (MS SQL Server) (Global – Remote)

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

• Senior Ai Database Developers (MS SQL Server) (Global – Remote)

Senior Ai Database Developers (MS SQL Server) (Global – Remote)

Get thought leadership and industry insights on building better customer experiences.

• Global
• Full-time

Introduction

Work with Ai – Boost your career!
All our positions involve Ai work. If you don’t have experience, this is a great opportunity to propel your career! We will take you there!

Powerfront Inc. (www.powerfront.com) isn’t just another SaaS provider; we’re the architects of the INSIDE™ Ai Customer Visual Engagement Platform. An Ai powered solution used by most luxury brands allowing them to see their online world in real-time. We’re talking about live customer behavior tracking and the power to engage at the precise moment of impact. Forget static analytics—we’re revolutionizing customer interaction for industry titans like LV, Gucci, Ferrari, Cartier, Valentino, Staples, Rooms To Go and Lenovo.

We’re a global, fully remote team fueled by passion and a shared obsession with cutting-edge technology. We are fully committed to the future of Ai, with the majority of our development work focused on account Ai and intelligent customer engagement. We believe Ai is the foundation of modern customer experience and are dedicated to building solutions that leverage its full potential.We’re not just building software; we’re forging strategic partnerships that redefine customer engagement.

If you’re driven to tackle complex challenges, thrive in a dynamic, collaborative environment, and want to leave your mark on the next generation of e-commerce, Powerfront is your launchpad. This isn’t just a job; it’s a career-defining opportunity to be part of a team transforming how the world connects with brands.

We are seeking an experienced and skilled Senior MS SQL Server Database Developer with a focus on reporting within the Customer Service or Contact Center space. In this role, you will specialize in writing complex reporting queries, conducting data analysis, and optimizing database performance to support our customer service SaaS product. The ideal candidate will have deep expertise in MS SQL Server and experience working with customer service or contact center data, terminology, and metrics.

• Design and implement complex SQL queries and stored procedures to support reporting requirements and data analysis tasks specific to customer service and contact center operations.
• Collaborate with stakeholders to understand data and reporting needs within the context of customer service and translate them into efficient database queries.
• Analyze and optimize existing database queries to improve performance and support key metrics relevant to customer service, such as response times, call volumes, and customer satisfaction scores.
• Develop and maintain data models and database schemas that are tailored to the needs of customer service reporting.
• Monitor database performance and usage patterns, and implement tuning measures such as indexing and partitioning to support efficient reporting.
• Create and maintain ETL processes to extract, transform, and load data from various sources relevant to customer service operations into the SQL Server databases.
• Ensure data accuracy, integrity, and security through proper database design, data validation, and backup strategies, with a focus on customer service data.
• Troubleshoot and resolve database issues, including data corruption, connection problems, and performance bottlenecks, particularly as they relate to customer service data.
• Stay updated on the latest developments in MS SQL Server and customer service technologies, including new features and best practices, and incorporate them into your work.
• Provide technical guidance and mentorship to backend developers and analysts, sharing knowledge and best practices, particularly in the area of customer service reporting.
• Bachelor’s degree in Computer Science, Information Technology, or a related field (or equivalent work experience).
• Proven experience as an MS SQL Server Developer, with a strong portfolio showcasing your work on complex reporting queries and data analysis within the customer service or contact center space.
• Expertise in writing and optimizing complex T-SQL queries, stored procedures, and functions, particularly as they relate to customer service reporting.
• In-depth knowledge of database design principles, data modeling, and normalization, with an emphasis on customer service data structures.
• Experience with performance tuning techniques, including indexing, partitioning, and query optimization for customer service data.
• Familiarity with ETL processes and tools, with the ability to create and maintain data pipelines for customer service reporting.
• Strong analytical and problem-solving skills, with the ability to interpret customer service data and provide actionable insights.
• Understanding of data security and compliance best practices, with experience implementing data validation and protection measures for customer service data.
• Excellent communication and collaboration skills, with the ability to work effectively in a team environment and interact with stakeholders in the customer service domain.
• Detail-oriented mindset with a focus on delivering high-quality solutions within established timelines.
• Certification in Microsoft SQL Server or relevant technologies is a plus.

• A dynamic & forward-thinking organization revolutionizing retail technology
• A virtual workforce, remote but highly interactive and collaborative
• Competitive salary and benefits
• Be a part of an amazing culture with a high client and staff retention
• Take pride in partnering with the most prestigious brands in the world
• Career progression and longevity

Note: The purpose of this profile is to provide a general summary of essential responsibilities for the position and is not meant as an exhaustive list. Assignments may differ for individuals within the same role based on business conditions, departmental need or geographic location.

Powerfront provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics.