About the Role:

As an SQL Developer, you will play a critical role in designing, developing, and optimizing database solutions that support business intelligence and data analytics initiatives. Your primary focus will be on creating efficient and scalable SQL Server Reporting Services (SSRS) reports, developing stored procedures, and performing performance tuning to ensure high system responsiveness. You will be responsible for transforming raw data into meaningful insights by building and maintaining data marts and implementing data modeling techniques such as star schema. Collaborating closely with data architects, analysts, and other stakeholders, you will ensure data integrity and accessibility across various platforms. Ultimately, your work will enable the organization to make data-driven decisions by providing reliable, timely, and accurate data solutions within the United States market context.

Minimum Qualifications:

Bachelor’s degree in Computer Science, Information Technology, or a related field.
Proven experience working with SQL Server Reporting Services (SSRS) and developing stored procedures.
Strong knowledge of SQL (Structured Query Language) and database concepts.
Experience with performance tuning and query optimization in SQL Server environments.
Familiarity with SQL Server Integration Services (SSIS) for data transformation tasks.

Preferred Qualifications:

Experience designing and implementing data marts and data models using star schema.
Knowledge of data warehousing concepts and best practices.
Familiarity with additional reporting tools or BI platforms.
Certification in Microsoft SQL Server or related technologies.
Experience working in Agile development environments.

Responsibilities:

Develop, test, and deploy complex SQL queries, stored procedures, and functions to support reporting and data analysis needs.
Design and maintain SQL Server Reporting Services (SSRS) reports that provide actionable insights to business users.
Perform performance tuning and optimization of SQL queries and database objects to enhance system efficiency.
Implement data transformation processes using SQL Server Integration Services (SSIS) to ensure data quality and consistency.
Collaborate with data architects to design and maintain data marts and data models, including star schema structures.
Analyze business requirements and translate them into technical specifications for database development.
Monitor and troubleshoot database performance issues and provide timely resolutions.
Document database designs, processes, and procedures to maintain knowledge sharing and compliance.

Skills:

The required skills such as SQL Server Reporting Services and stored procedures are essential for creating and managing reports that deliver critical business insights. Performance tuning skills are applied daily to optimize query execution and ensure fast data retrieval, which is vital for maintaining system responsiveness. Data transformation expertise using SQL Server Integration Services enables the developer to cleanse and prepare data for analysis, ensuring accuracy and consistency. Knowledge of data marts and star schema data modeling supports the structuring of data in a way that enhances reporting efficiency and scalability. Preferred skills like familiarity with data warehousing and additional BI tools further empower the developer to contribute to broader data strategy initiatives and improve overall data accessibility.

Learn more about this Employer on their Career Site