Senior Database Developer/Modeler

Gen3technology; New York (NY); Remote; USD 100,000 - 140,000; Full time

Job summary

A leading company is seeking a Senior Database Developer/Modeler to support the development of their Website DataMart. This role involves designing and optimizing SQL Server databases, collaborating with stakeholders, and ensuring high data integrity. Ideal candidates will have extensive experience in database development, particularly with SQL Server, and a strong background in performance optimization techniques.

Benefits

Remote work flexibility

Inclusive work environment

Focus on work-life balance

Qualifications

• 7+ years of experience in database development and data modeling.
• Proficiency in SQL Server objects (views, stored procedures, indexing).
• Experience with SQL Server Data Tools (SSDT) and data integration.

Responsibilities

• Develop the Website DataMart to aggregate data from multiple client systems.
• Build secure SQL Server objects and optimize performance.
• Collaborate with developers and analysts to implement data solutions.

Skills

SQL

Data Modeling

Performance Optimization

Data Integration

Tools

Microsoft Visual Studio

SQL Server

Power BI

Job description

Gen3 Technology Consulting is an SBA-certified Woman-Owned Small Business (WOSB) providing a diverse set of technology services and solutions to federal, state, and commercial clients. Founded in 2017, Gen3 leverages over 25 years of information technology management and leadership experience to help our clients define, plan, manage, and achieve their strategic vision while protecting their critical IT assets.

We attract and retain the highest caliber of talent by supporting an inclusive work environment, cultivating growth and leadership both professionally and personally, and encouraging work-life balance. We strive to make it our priority to be compassionate, family-friendly, respectful, and flexible.

About the role:

The Senior Database Developer/Modeler will support the development of the Website DataMart by designing, modeling, and optimizing database solutions that integrate and aggregate data from multiple client systems. This individual will be responsible for the end-to-end architecture, transformation processes, and integrity of the database and reporting environment.

Location: Remote

Project Duration: 2.5 years, with potential for extension

What you'll do:

• Support the development of the Website DataMart to aggregate data from multiple client systems
• Build secure and optimized SQL Server objects (views, stored procedures, tables, etc.) to support the needs of both public websites and internal applications
• Write and optimize SQL statements for data access and stored procedures for high performance
• Assist in data model design using best practices for scalability, normalization, and performance
• Perform regular database management duties including backups and audits to ensure that SQL databases remain accessible, secure, and stable
• Collaborate with developers, analysts, and business users to identify and implement data and reporting solutions
• Ensure data integrity and support data quality control processes across the solution
• Document database architecture, design decisions, and procedures for long-term support and maintainability

What you'll need:

• 7+ years of experience in database development and data modeling with SQL Server
• Technologies: Microsoft Visual Studio, SQL Server 2014/2016/2019, SQL Server Data Tools, Microsoft SQL Server Reporting Services, Power BI
• Strong knowledge of database architecture and performance optimization techniques
• Proficiency in stored procedures, views, indexing strategies, and query optimization
• Familiarity with data integration from multiple sources and large datasets
• Experience with SQL Server Data Tools (SSDT), SSIS, and Power BI integration
• Ability to communicate technical concepts to non-technical stakeholders
• Experience supporting both internal data applications and external-facing data requirements
• Experience working with New York City Public Schools (NYCPS) or other municipal agencies is a plus

Seniority level:

• Mid-Senior level

Employment type:

• Full-time

Job function:

• Sales, General Business, and Education

Industries:

• Wireless Services, Telecommunications, and Communications Equipment Manufacturing

Referrals increase your chances of interviewing at Gen3 Technology Consulting by 2x.