Data Architect/ Lead SQL DB Solutions Developer

Overview

On Site
Depends on Experience
Contract - W2

Skills

SQL
Azure SQL
SSIS
SSRS
Power BI

Job Details

Key Responsibilities

Design, develop, and maintain robust SQL Server and Azure SQL database solutions.

Lead the development and optimization of stored procedures, views, functions, and ETL processes using SSIS.

Build and deploy operational and analytical reports using SSRS and Power BI, ensuring performance and usability.

Integrate database solutions with Active Directory for secure authentication and role-based access control.

Collaborate with business stakeholders to gather requirements and translate them into technical specifications.

Mentor junior developers and provide technical leadership across database and reporting initiatives.

Conduct performance tuning, troubleshooting, and capacity planning for SQL environments.

Document database architecture, processes, and workflows clearly and concisely.

Required Skills & Qualifications

Bachelor s degree in Computer Science, Information Systems, or related field (Master s preferred).

5+ years of experience in SQL Server development and database architecture.

Excellent communication skills for stakeholder engagement and executive presentations.

Advanced proficiency in SQL, query optimization, and relational database design.

Strong experience with SSIS, SSRS, and Power BI.

Hands-on experience with Azure SQL and cloud-based data platforms.

Familiarity with Active Directory integration and role-based security models.

Excellent oral and written communication skills with the ability to present complex data concepts to diverse audiences.

Preferred Qualifications

Strategic thinker with a proactive approach to problem-solving.

Passionate about data visualization and storytelling through analytics.

Comfortable working in a fast-paced, dynamic environment.

Committed to continuous learning and professional development.

Familiarity with Azure Synapse, Databricks, or Delta Lake.

Microsoft certifications (e.g., Azure Data Scientist Associate, Power BI).

Exposure to CI/CD pipelines and DevOps practices for data workflows.

Proficiency in Python for statistical modeling and machine learning.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.