Database Developer

We are seeking an experienced professional to support our transactional databases and data warehouse within a small, collaborative team. This role involves a broad range of responsibilities, including building new solutions and supporting existing systems. The position offers opportunities to work on multiple projects and to contribute across the full application lifecycle - from initial design through implementation and ongoing support - while collaborating closely with end users. This position offers a flexible hybrid work schedule with both onsite and remote options.

Primary Job Responsibilities (consists of but are not limited to):

• Work with a team to design and develop data warehouse and database, stored procedures, and other SQL Server Database objects to support data warehouse, web applications, BI reporting and ETL on the cloud with multi-tenant solutions and on-premises.
• Participate in all phases of data migration, including design, development, and testing.
• Perform standard data integration work, data analysis, data transformation load, error handling, etc. between internal and external systems.
• Perform general database activities (debug scripts/procedures, participate in code reviews, database tuning, database optimization), performance tuning, etc.
• Review and analyze business requirements, consult with Tech Lead, Project Manager and Business Analyst to understand business requirement for database development and reports being implemented, create and update milestones and project timeline estimates.
• Use data mining, model building, other analytical techniques to develop and maintain customer segmentation and predictive models to drive the business.
• Practice standard development process leveraging Waterfall and agile methodologies (Wagile).
• Be able to mentor junior developers and provide support to users for ad-hoc requests.
• All other duties as assigned.

Job Qualifications:

• Minimum of five years of data warehouse and database ETL development experience preferably MS SQL Server, including T-SQL, and stored procedure.
• Experience with importing external data sources (from SFTP) into the data warehouse and vice versa.
• Experience with databases and applications hosted on the Cloud with large volumes, Big Data experience, preferably on AWS.
• Experience with multi-tenant hosting database design, SaaS, SOC and SOC2 compliant.
• Experience with production support and troubleshooting.
• Experience in developing reports and Dashboards using a BI tool is a plus.
• Knowledge of data profiling and data quality concepts and techniques.
• Data Modeling experience is a plus.
• Ability to travel to/work from the Wakefield, MA office once a week.

Education and Preferred Skills:

• Degree in Information Systems or related field (Mathematics, Engineering, Computer Science, or equivalent in work experience).
• Proficiency in Microsoft Office products.
• Proficiency using versioning Control Software e.g. BitBucket, GIT.
• A passion for Database Development and Analysis.
• Strong problem-solving skills.
• Self-motivated and self-driven is a must.
• Ability to work on a team; be a team player with a good attitude with limited supervision.
• Excellent verbal and written communication skills; ability to interact effectively with a variety of internal and external contacts.
• Highly organized with great attention to detail.

The above reflects management’s definition of essential functions for this position but does not restrict the tasks that may be assigned. The above responsibilities are representative only; management may modify the duties and responsibilities to this position at any time.

Work from Home Setup:

• An internet connection, via cable or fiber, that can support 300Mbps down and 10Mbps up. A wired (Ethernet) connection to the internet is preferred for best performance.
• A workstation, desk, or table that is ergonomically suitable for the employee’s physical needs, (standing, sitting, etc.). This workspace must support two, 24” displays, a laptop, docking station, keyboard, and mouse, at minimum.

Teleworkers must be reachable while teleworking during the employee’s regularly scheduled hours. Methods of communication include email account, voice calls, and messages using company-issued iPhone, Microsoft Office Teams, and other appropriate department tools and equipment. It is expected that teleworkers will attend all virtual scheduled meetings with their cameras on as much as possible. Additionally, any calls and/or voicemails will be answered in a timely manner.

Job Type: Full-time

Pay: $85,000.00 - $120,000.00 per year

Benefits:

• 401(k)
• 401(k) matching
• Dental insurance
• Flexible schedule
• Flexible spending account
• Health insurance
• Life insurance
• Paid time off
• Parental leave
• Vision insurance

Work Location: Hybrid remote in Wakefield, MA 01880

Salary : $85,000 - $120,000