SQL SERVER DEVELOPER

Title – SQL and Data Warehouse Developer

Location – San Diego, CA

Duration – Contract

Job description:

AgreeYa is a global Systems Integrator and seeking a SQL and Data Warehouse Developer who have experience in designing and developing Microsoft SQL Server databases, data warehouses, and report writing to support our clients' needs. The data domains you will work with include IT assets, billing, and financial data.

Objective:

As a SQL and Data Warehouse Developer, you will utilize your expertise in SQL Server development, including SSIS (SQL Server Integration Services) and SSRS (SQL Server Reporting Services), to ensure efficient data management and reporting solutions. You must have a keen eye for detail and a strong understanding of database architecture principles.

Required Skills:

Design, develop, and maintain Microsoft SQL Server databases and data warehouses to store and manage large volumes of data.

Collaborate with stakeholders to gather requirements and translate them into efficient database structures and schemas.

Write complex SQL queries, stored procedures, and functions to retrieve and manipulate data.

Create and optimize ETL (Extract, Transform, Load) processes using SSIS for data integration from various sources into the data warehouse.

Develop reports and visualizations using SSRS to enable effective data analysis and reporting.

Monitor and fine-tune database performance to ensure optimal efficiency and scalability.

Implement data security measures to protect sensitive information and ensure compliance with regulatory requirements.

Troubleshoot and resolve database issues and performance bottlenecks.

Stay up to date with the latest industry trends and best practices in SQL Server development and data warehousing.

Collaborate with cross-functional teams to integrate data from external systems, such as ServiceNow and AWS, into the data warehouse (experience with these technologies is a plus).

Minimum of five years of experience in SQL Server development, including SSIS and SSRS.

Strong knowledge of database design, data modeling, and SQL optimization techniques.

Experience with Microsoft SQL Server Analysis Services (SSAS) is desirable.

About Us:
AgreeYa is a global systems integrator delivering competitive advantage for its customers through software, solutions, and services. Established in 1999, AgreeYa is headquartered in Folsom, California, with a global footprint and a team of more than 1,850 staff across offices. AgreeYa works with 500 organizations ranging from Fortune 100 firms to small and large businesses across industries such as Telecom, Banking, Financial Services & Insurance, Healthcare, Utility & Energy, Technology, Public sector, Pharma & Biotech, and others. 
 
AgreeYa is an equal opportunity employer. We evaluate qualified applicants without regard to race, color, religion, gender identity, sexual orientation, national origin, disability, veteran status or other protected characteristics.