Database Developer (SQL Server / Power BI / AI Productivity) (Pakistan Only)

About AllShore Talent

AllShore Talent is a leading remote staffing company, offering top-tier professionals working 100% remote to businesses worldwide. Specializing in IT and software development, design, administrative support, digital marketing, and more. AllShore connects organizations with skilled talent to meet diverse business needs.

Location: Remote / On-site (as applicable)

Position Overview

We are seeking a highly skilled Database Developer with deep expertise in SQL Server, T-SQL, data migration, and BI development.

The ideal candidate will have hands-on experience designing scalable databases, building complex stored procedures, optimizing data pipelines, and creating insightful dashboards in Power BI.

The candidate must also demonstrate the ability to leverage AI-powered tools (e.g., GitHub Copilot, ChatGPT, or Azure AI) to streamline query development, improve efficiency, and support faster delivery cycles.

Key Responsibilities

• Design, develop, and optimize relational database architectures to support enterprise applications.

• Write, review, and maintain complex T-SQL queries, views, triggers, and stored procedures.

• Perform data migration, transformation, and cleansing across multiple environments.

• Develop, schedule, and maintain SSIS packages for ETL processes.

• Design and implement data models for reporting and analytics.

• Build and publish Power BI dashboards and reports, integrating data from multiple sources.

• Monitor and improve database performance, scalability, and security.

• Collaborate closely with application developers, analysts, and business stakeholders to ensure data integrity and performance.

• Use AI-assisted development tools to enhance productivity, accelerate coding tasks, and automate repetitive database operations.

• Support data-driven decision-making through BI and analytics solutions.

Required Skills & Qualifications

• Bachelor’s degree in Computer Science, Software Engineering, or a related field.

• 5+ years of hands-on experience in Microsoft SQL Server (2016 or later).

• Strong experience in database design, normalization, and optimization.

• Expert-level proficiency in T-SQL, including advanced query tuning and indexing.

• Proven experience with SSIS (SQL Server Integration Services) for ETL processes.

• Experience in data migration between heterogeneous systems.

• Proficiency in Power BI report creation and data modeling.

• Familiarity with database security, roles, and permissions.

• Ability to use AI tools (e.g., GitHub Copilot, ChatGPT, Azure OpenAI, etc.) for query optimization, data analysis, and documentation.

• Strong analytical and problem-solving skills with attention to detail.

• Excellent collaboration and communication abilities.

Preferred (Nice-to-Have)

• Experience with Azure SQL, Synapse Analytics, or Databricks.

• Knowledge of data warehousing and dimensional modeling.

• Exposure to Python or R for data analytics.

• Understanding of Agile/Scrum methodologies.

Why Join Us

• Work in an AI-first engineering culture, where automation and innovation drive everything we do.

• Opportunity to collaborate on enterprise-grade applications and modern BI platforms.

• Learn, experiment, and grow your skills with access to leading-edge tools and technologies.
  

This is a short-term project engagement, expected to last approximately 4 to 6 weeks, with a part-time commitment of around 4 hours per day.