Job Summary:
The SQL Developer / Data Engineer (Mid-Level) is responsible for designing, developing, and maintaining scalable data solutions within Microsoft-based environments. The role focuses on building efficient SQL-driven data pipelines, ETL/ELT workflows, and transformation processes that support enterprise reporting, analytics, and automation initiatives.
Working closely with analysts, data scientists, and software engineers, the SQL Developer / Data Engineer ensures data integrity, consistency, and accessibility across multiple systems. The position involves integrating data from relational databases, APIs, and cloud-based sources into centralized repositories while contributing to data architecture improvements, schema optimization, and documentation.
The ideal candidate brings strong SQL expertise, hands-on experience with Microsoft SQL Server and modern data platforms, and familiarity with Python for automation and scripting. The role also requires practical knowledge of version control (Git), workflow automation, and performance optimization. Exposure to Azure Data Services, Power BI ecosystems, and containerized development (e.g., Docker) is an added advantage.
This position is well-suited for a detail-oriented professional with strong analytical reasoning, a collaborative mindset, and a commitment to building reliable, secure, and scalable data solutions that support the organization’s growing analytics and business intelligence needs.
Key Responsibilities
• Design, develop, and maintain SQL-based data pipelines, ETL/ELT workflows, and transformation logic within Microsoft-based environments.
• Write efficient SQL queries, stored procedures, and functions optimized for performance and scalability.
• Collaborate with analysts, data scientists, and software engineers to ensure data integrity, consistency, and accessibility across systems.
• Integrate data from relational databases, APIs, and flat-file or cloud sources (Azure Blob Storage, SharePoint, etc.) into centralized repositories.
• Contribute to data architecture design, schema optimization, and documentation of data models and flows.
• Implement version control (Git), code testing, and workflow automation standards within development environments.
• Monitor, troubleshoot, and optimize database and pipeline performance.
• Support ongoing modernization initiatives in analytics, automation, and business intelligence, especially those leveraging Power BI and Azure Data Services.
Required Skills and Qualifications
• Bachelor’s degree in computer science, Information Systems, Engineering, or a related field.
• Strong proficiency in SQL, including DDL, DML, joins, window functions, and query optimization.
• Experience with Microsoft SQL Server (T-SQL) and at least one additional RDBMS (PostgreSQL or MySQL preferred).
• Working knowledge of Python for scripting, automation, and data transformation.
• Solid understanding of data modeling, normalization, and relational schema design.
• Familiarity with ETL frameworks, data orchestration tools, and API integrations.
• Experience using Git/GitHub for version control and collaborative code management.
• Experience using AI-assisted development tools (e.g., GitHub Copilot, Codex, or Microsoft Copilot) for SQL optimization, documentation, and code review.
Preferred Qualifications
• Experience with Microsoft Azure services such as Azure Data Factory, Azure SQL Database, or Synapse Analytics.
• Exposure to data engineering or orchestration tools (e.g., Airflow, dbt, or Azure Data Factory pipelines).
• Familiarity with Docker or containerized development environments.
• Background in Power BI or equivalent analytics platforms, including data modeling and DAX.
• Awareness of data privacy, compliance, and security best practices (e.g. ISO 27001).
Soft Skills
• Strong analytical reasoning and structured problem-solving capability.
• Ability to translate technical concepts into clear, actionable insights.
• High attention to detail and commitment to maintainability, accuracy, and scalability.
• Collaborative mindset and adaptability in evolving technical environments.
Application Instructions
Please forward cover letters and CVs as a single PDF to: recruitment@fsioutsourcing.com
Use the subject line: SQL Developer / Data Engineer (Mid-Level) – [Candidate Name].
File Naming Convention: Lastname_Firstname_SQL-DE.pdf
Cover Letter Requirement:
Include concise answers to the following mandatory questions. Keep responses brief and clear.
Mandatory Questions:
- Describe one recent project where you built or maintained an ETL or ELT workflow. What was your role and the outcome?
- Which relational databases have you worked with most, and for how long?
- How comfortable are you with Python for data tasks? Mention one script or automation you are proud of.
- Which Microsoft tools have you used in production (for example, SQL Server, Azure Data Factory, Synapse, Power BI)?