Database Developer

Job Description

Job Description

We are looking for a Database Developer to support enterprise reporting and analytics initiatives. This role will focus on building and enhancing data warehouse solutions, improving database performance, and delivering reliable data pipelines that support business operations and decision-making. The ideal candidate brings strong experience across Microsoft SQL Server, Azure data services, ETL development, and business intelligence tools in a collaborative Agile environment.

Responsibilities:

• Create and maintain scalable data warehouse structures and database solutions using Microsoft SQL Server, Azure SQL Database, and Azure Data Factory.

• Develop robust ETL workflows that extract, transform, validate, and load data from multiple sources into reporting and analytics platforms.

• Partner with business users and technical teams to convert reporting and data needs into efficient database designs and usable insights.

• Establish automated processes for data validation, auditing, and quality control to preserve accuracy and consistency across datasets.

• Improve database reliability and speed through query tuning, indexing strategies, and execution plan analysis.

• Support production operations by managing scheduled jobs, troubleshooting failures, and assisting with backup, recovery, and deployment activities.

• Build ad hoc reports, dashboards, and visualizations using Power BI and related business intelligence tools.

• Develop and maintain integrations with external systems through APIs, web services, and other data connectivity methods.

• Participate in technical reviews, testing efforts, and release activities while promoting sound architecture, coding, and security practices.

• Provide guidance to less experienced developers and contribute to code quality through peer reviews and knowledge sharing.

• 7+ years of experience in database development with significant exposure to data warehousing and analytics environments.
• Advanced proficiency in Microsoft SQL Server, including stored procedures, views, functions, and complex query development.
• Hands-on experience building ETL solutions with Azure Data Factory or comparable data integration platforms.
• Strong knowledge of relational database design, data modeling, and data mapping principles.
• Demonstrated expertise in database performance tuning, indexing, and execution plan review.
• Experience creating reports and dashboards with Power BI or similar visualization tools.
• Familiarity with Azure-based data platforms, including Azure SQL Database, and understanding of database security, backup, and recovery concepts.
• Strong analytical, troubleshooting, communication, and problem-solving skills, with experience working in Agile delivery environments.