Senior Database Developer/Modeler

Gen3 Technology Consulting; New York (NY); Remote; USD 100,000 - 140,000; Full time

Job summary

A growing consulting firm is seeking a Senior Database Developer/Modeler. This role will focus on designing and optimizing database solutions to support data aggregation from various systems. Ideal candidates will have extensive SQL Server experience and a passion for data quality and architecture, within a supportive and inclusive work environment.

Benefits

Competitive compensation

Comprehensive health, vision, and dental benefits

Generous PTO and 11 days of paid Federal Holidays

$3k annual tuition reimbursement

401(k) with a matching plan

Pet insurance

Life and AD&D insurance

Short-term and Long-term disability insurance

Qualifications

• 7+ years of experience in database development and data modeling.
• Familiarity with SQL Server Data Tools, SSIS, and large datasets.
• Strong knowledge of database architecture and performance optimization techniques.

Responsibilities

• Support the development of the Website DataMart to aggregate data from multiple client systems.
• Build secure and optimized SQL Server objects like views and stored procedures.
• Perform regular database management duties, including backups and audits.

Skills

Database performance optimization

Data integration

Data quality control

SQL programming

Tools

SQL Server

Microsoft Visual Studio

Power BI

Job description

About us:

Gen3 Technology Consulting isan SBA-certified Woman-Owned Small Business (WOSB) providinga 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:

• Experience: 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 and 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

Certifications: N/A

What's In It for You (full-time Gen3 employees):

• Competitive compensation.
• Comprehensive health, vision, and dental benefits.
• Generous PTO and 11 days of paid Federal Holidays.
• $3k annual tuition reimbursement.
• 401(k) with a matching plan.
• Pet insurance.
• Life and AD&D insurance.
• Short-term and Long-term disability insurance.

Employment Eligibility: Eligible to work for any employer in the United States without requiring sponsorship. Most of our positions require a government security clearance, you must be a US Citizen or Green Card holder for consideration. Certain positions require at least three (3) of the past five (5) years of residence in the United States.

Other Requirements:

• A minimum of three (3) out of the past five (5) years of residency in the United States is mandatory.
• Candidates must possess either an active green card or citizenship.
• Prospective employees offered a position must have work authorization that does not necessitate employer-sponsored visa sponsorship, both presently and in the future.
• Those selected for this role may undergo a government security investigation and must meet the eligibility criteria for accessing classified information or be eligible for security clearances.
• Location: Gen3 is currently focusing its hiring efforts in these states: Alabama, Arizona, Colorado, DC, Florida, Georgia, Kentucky, Maryland, Missouri, North Carolina, New York, Ohio, Oklahoma, Oregon, Texas, Virginia, and Wisconsin.

Veteran and HubZone-friendly employer.

E-Verify Employer. EOE Statement: Gen3 is an equal opportunity employer. We adhere to all federal regulations and ensure that our hiring practices are based solely on merit. We do not discriminate against any applicant based on race, color, sex, sexual orientation, gender identity, religion, national origin, disability, or veteran status. All qualified applicants will receive consideration for employment.

Accommodation: Please contact the recruiting team at [e-mail] if you would like to request a reasonable accommodation during the application or interviewing process.