SQL Developer

Position Summary:

We are seeking a skilled Data Developer to support the development and integration of an in-house SQL Server-based operational data store. This system is designed to centralize and enhance the analysis of public procurement data by integrating multiple databases and systems into a single, streamlined repository. The initiative aims to improve data management, ensuring accuracy and consistency while providing valuable insights into vendor and buyer activities.

The selected candidate will play a critical role in designing and optimizing data retrieval and processing while collaborating closely with the data management team to develop standardized data feeds. The ideal candidate will have expertise in MS SQL database design, including database modeling, schema development, and unit testing of interfaces and integrations.

Responsibilities:

1. Design and develop SQL tables, views, stored procedures, functions, and triggers to support reporting, analytics, and business logic.
2. Support ETL processes and automation for integrating internal and external data sources.
3. Design and implement data pipelines to facilitate seamless data transfer and integration across systems.
4. Collaborate with stakeholders to establish data validation rules and quality control measures.
5. Monitor technical metrics to track progress, assess project success, and inform future improvements.
6. Adhere to established business, technical, and project policies aligned with data management best practices.

The ideal candidate may also be expected to:

7. Optimize data organization and system performance through indexing, partitioning, query performance tuning, and process standardization.

8. Translate functional requirements into technical design documentation.

9. Manage relational database models and schemas to align with business needs.

10. Document data models, integration processes, and best practices to ensure transparency and knowledge sharing.

Qualifications:

1. 8+ years of experience in SQL Server database design, administration, and optimization.
2. Expertise in SQL programming, including writing procedures, functions, and triggers.
3. Strong skills in SQL querying, reporting, and data extraction with experience handling data formats such as Excel (.xlsx) and CSV.
4. Proficiency in data modeling, ETL processes, and system integration.
5. Familiarity with data pipeline design and management to facilitate smooth data flow.
6. Strong understanding of data validation controls and maintaining data consistency across systems.
7. Experience working with public sector data systems (preferred).
8. Knowledge of Qlik and Microsoft Power BI (preferred).

Skills:

• Strong problem-solving skills with an analytical approach to database performance, system integration, and automation.
• Ability to collaborate effectively with cross-functional teams, including data management, development, and business teams.
• Experience with data governance and ensuring alignment with organizational data management standards.