Senior Database Developer

Senior Database Developer

1 day a week in office

Principal Duties and Responsibilities:

• Design, build, and maintain scalable data pipelines to ingest, process and transform data efficiently and reliably.
• Design, develop, optimize, and maintain complex SQL queries, stored procedures, functions, and database views to ensure efficient and reliable data.
• Develop and optimize Extract, Transform and Load (ETL) / Extract, Load and Transform (ELT) processes to support analytics and reporting needs.
• Ensure data quality, consistency, and reliability across all data platforms through validation, monitoring, and continuous improvement practices.
• Optimize database performance by tuning queries through effective use of indexing, execution plan analysis, and advanced query optimization techniques.
• Implement data validation and monitor to detect and resolve issues proactively.
• Optimize large-scale data loads and batch processing workflows to ensure efficient, reliable, and high performance data operations.
• Support reporting tools such as SSRS and Power BI.
• Mentor junior developers and provide technical guidance.
• Performs other similar and related duties as required.

MINIMUM QUALIFICATIONS:

• Bachelor’s degree in Computer Science, Information Technology, or a related technical field
• 7+ years of progressive experience in the IT industry, with a strong focus on database development, data engineering, and business intelligence solutions
• Hands-on experience with Microsoft technologies including SQL Server, SSIS, SSRS, Microsoft Fabric, PySpark, and Power BI
• Experience working with modern development and deployment platforms, including Azure DevOps
• Familiarity with cloud-based database solutions, such as Azure SQL Database, preferred
• Familiarity with Microsoft Fabric is preferred and will be considered a plus.
• Proficiency with scripting and automation languages such as Python and/or PowerShell
• Working knowledge of Microsoft 365 applications, including Office 365 and SharePoint Online.