Build Smarter Data Solutions. Make a Real Business Impact. Are you a database development professional who enjoys solving complex problems, optimizing performance, and turning data into meaningful business solutions? Join our eTechnology Services team as a Senior Database Developer , where you'll play a key role in building, enhancing, and supporting the databases and data warehouse that power our business.
Position Description:
The Senior Database Developer will support our transactional databases and data warehouse in a collaborative, small-team environment and will handle a broad range of activities. This role will both build new solutions and support existing solutions, ensuring high performance, reliability, and scalability across our systems both on AWS and on-premises. You will be assigned to multiple projects and have the opportunity to work on applications from start to finish through the full life cycle. This includes gathering requirements, designing solutions, implementing changes, and supporting end users while also gaining satisfaction and recognition of seeing your work directly benefit the business. This position offers flexibility as a hybrid role, with the ability to work both onsite and remotely.
Primary Responsibilities:
- Working in a team designing and develop database and data marts, stored procedures, and other SQL Server Database objects to support state of the art cloud based and on-premise web applications, data warehouse, BI reporting and ETL
- Perform standard data integration work, data analysis, transformation, loading, and error handling between internal and external systems.
- Participate in all phases of data migration, including design, development, and testing
- Conduct general database activities (debug scripts/procedures, participate in code reviews, database tuning, database optimization), performance tuning etc.
- Apply data mining, model building, other analytical techniques to develop and maintain customer segmentation and predictive models to drive the business
- Follow a standard development process leveraging Waterfall and agile methodologies (Wagile)
Job Requirements:
- Degree in Information Systems or related field (Math, Engineering, Computer Science, or equivalent in work experience)
- 5+ years of hands-on experience in data warehouse and database ETL development, preferably using MS SQL Server
- Proven experience importing and exporting external data sources (e.g., via SFTP) into and out of the data warehouse. Data Modeling Experience a plus
- Experience managing databases and applications hosted on the cloud (preferably AWS) and handling large-scale, high-volume data environments
- Background in multi-tenant database design and familiarity with
SOC/SOC2
compliance standards
- Experience with AWS Cloud environment, including Redshift, AWS Bedrock, AWS Q is a plus
- Experience with other database tools including MySQL a plus
- Experience in developing reports and Dashboards using a BI tool a plus
- Proficiency using versioning Control Software e.
g.
BitBucket, GIT Pay:
From $120,000.00 per year
Benefits:
401(k) 401(k) matching Dental insurance Employee assistance program Flexible schedule Flexible spending account Health insurance Life insurance Paid time off Parental leave Professional development assistance Retirement plan Vision insurance
Experience:
SQL:
5 years (Required)
Work Location:
Hybrid remote in Wakefield, MA 01880