SQL Developer

Compunnel Inc.; Boston (MA); On-site; USD 80,000 - 110,000; Full time

Job summary

An established industry player is seeking a talented SQL Database Developer to join their dynamic team. In this role, you will design and optimize SQL databases, ensuring seamless data integration and reporting capabilities. You will collaborate closely with data management teams to establish best practices for data validation and performance tuning. This is a fantastic opportunity to enhance your skills in a supportive environment while contributing to impactful projects that drive business success. If you are passionate about data management and looking to make a significant impact, this role is perfect for you.

Qualifications

• 8+ years of experience in SQL server database design and optimization.
• Expertise in SQL programming including writing procedures and triggers.

Responsibilities

• Design and develop SQL tables, views, and stored procedures for reporting.
• Support ETL processes and automate data integration from various sources.

Skills

Problem solving

Analytical skills

Collaboration

Data governance

Tools

SQL Server

Qlik

Microsoft PowerBI

Job description

Direct message the job poster from Compunnel Inc.

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 smooth data transfer and integration across systems.
4. Collaborate with the Data Czar and Data Management Team to establish data validation rules and quality control measures.
5. Monitor technical metrics to track progress, assess project success, and inform future improvements.
6. Follow established business, technical, and project policies aligned with OSD, A&F, and EOTSS guidelines for data management best practices.
7. Assist in implementing best practices for indexing, partitioning, and query performance tuning, data nomenclature, and process standardizations to optimize data organization and system performance.
8. Translate functional requirements into technical design documentation.
9. Manage the project’s relational database models and schemas, ensuring they are aligned with business needs.
10. Document data models, integration process, and best practices to maintain system 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 expertise in SQL for querying, reporting, and data extraction with experience exporting and importing data from formats such as Excel (.xlsx) and CSV.
4. Proficiency in data modeling, ETL processes, and system integration (including data from both internal and external systems).
5. Familiarity with data pipeline design and management to facilitate smooth data flow.
6. Strong understanding of data validation controls and ensuring data consistency across systems.
7. Familiarity with public sector data systems (preferred).
8. Familiarity with Qlik and Microsoft PowerBI (preferred).

Skills

• Problem solving with a strong analytical approach to database performance, system integration, and automation.
• Ability to collaborate effectively with cross-functional teams (e.g., data management, development, and business teams).
• Experience with data governance and ensuring alignment with organizational data management standards.

Seniority level

Mid-Senior level

Employment type

Contract

Job function

Other

Industries

IT Services and IT Consulting