Senior Database Developer/Modeler

About us:  

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: 

• 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 recruiting@gen3technology.com if you would like to request a reasonable accommodation during the application or interviewing process.