SQL Developer

deploy; Birmingham (AL); On-site; USD 80,000 - 100,000; Full time

Job summary

Deploy is seeking a skilled SQL Programmer specialized in SSRS and SSIS to join their team in Birmingham, Alabama. The role involves designing, developing, and maintaining SQL solutions to support business intelligence and data integration needs.

Key responsibilities include writing complex SQL queries, developing reports, maintaining ETL processes, and collaborating with various stakeholders to enhance data-driven decision-making. A bachelor's degree in Computer Science or a related field is required, along with proven SQL experience.

Qualifications

• Proven experience as a SQL Programmer or similar role.
• Strong expertise in SQL programming and query optimization.
• Effective communication and collaboration skills.

Responsibilities

• Design, write, and optimize complex SQL queries and ETL processes.
• Develop interactive reports using SSRS based on business requirements.
• Maintain SSIS packages for data automation and integration.

Skills

SQL programming

SSRS

SSIS

Query optimization

Data modeling

Problem-solving

Communication

Education

Bachelor's degree in Computer Science or related field

Tools

Microsoft SQL Server

Power BI

C#

Python

PowerShell

Job description

Job Title: SQL Programmer (SSRS/SSIS)

We seek a highly skilled and motivated SQL Programmer with expertise in SSRS (SQL Server Reporting Services) and SSIS (SQL Server Integration Services) to join our dynamic team. As a SQL Programmer, you will be responsible for designing, developing, and maintaining SQL-based solutions to support our business intelligence and data integration needs.

Responsibilities

1. Design, write, and optimize complex SQL queries, stored procedures, views, and functions to extract, transform, and load data from various sources into our data warehouse.
2. Design and develop interactive and visually appealing reports using SSRS to meet business requirements. Collaborate with end-users to gather report requirements, create data models, and ensure accurate and timely delivery of reports.
3. Develop and maintain SSIS packages to automate data extraction, transformation, and loading tasks. Implement data integration workflows to ensure smooth and efficient data movement between different systems and databases.
4. Analyze complex data sets, identify data quality issues, and implement appropriate solutions. Troubleshoot and resolve database performance and integrity issues.
5. Work closely with business analysts, data engineers, and other stakeholders to understand business requirements, translate them into technical solutions, and provide recommendations for data-driven decision-making.
6. Implement security measures and access controls to protect sensitive data. Adhere to data governance policies, industry best practices, and regulatory requirements.
7. Document database schemas, data models, and ETL processes. Create technical documentation and provide knowledge transfer to other team members.
8. Continuously enhance your skills and stay abreast of the latest advancements in SQL programming, SSRS, SSIS, and related technologies. Share your knowledge and expertise with the team.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, or a related field (or equivalent work experience).
• Proven experience as a SQL Programmer, Database Developer, or similar role.
• Strong expertise in SQL programming and query optimization.
• Proficiency in SSRS (SQL Server Reporting Services) for report development and customization.
• Experience with SSIS (SQL Server Integration Services) for ETL development and data integration.
• Solid understanding of relational database concepts, data modeling, and database design principles.
• Familiarity with data warehousing concepts and dimensional modeling.
• Knowledge of database administration tasks such as backup and recovery, performance tuning, and security.
• Excellent problem-solving and analytical skills.
• Strong attention to detail and ability to work independently and as part of a team.
• Effective communication and collaboration skills.

Preferred Skills

• Experience with other Microsoft SQL Server tools and technologies, such as SSAS (SQL Server Analysis Services) or Power BI.
• Knowledge of programming languages such as C#, Python, or PowerShell.
• Familiarity with Agile methodologies and software development life cycle (SDLC).

Join our team and contribute to developing and optimizing our data infrastructure. As a SQL Programmer with expertise in SSRS and SSIS, you will be crucial in leveraging data to drive informed business decisions and support our organization's growth.