What are the responsibilities and job description for the Database Engineer III position at Advisor360?
Position Available
Database Engineer III, Advisor360, LLC, Needham, Massachusetts (Hybrid)
Responsible for designing, developing, optimizing and overseeing the Advisor360 data platform. Specific duties and responsibilities will include:
- Crafting high-performance back-end data solutions to support reporting capabilities, such as front-end applications and websites, data mart activities, advanced analytics, and computational algorithms;
- Implementing, scheduling, and overseeing Extract Transform, and Load (ETL) and other monitoring processes;
- Examining execution plans and performance tune queries;
- Proactively escalating and owning issues to resolution before they become problems;
- Collaborating with other technical teams to maintain data platform efficiency and performance;
- Overseeing the loading of data from vendor and internal databases;
- Monitoring system performance by performing regular tests, troubleshooting, and integrating new features;
- Recommending solutions to improve new and existing database systems;
- Mentoring and guiding junior team members in best practices, coding standards, security considerations and general development;
- Offering technical support by responding to system problems in a timely manner; and
- Describing and documenting designs and implemented processes.
Requirements:
Position requires: a Bachelor’s degree (or an equivalent foreign degree) in Computer Science, Information Technology or a closely related field, and 5 years of experience as a Data Engineer.
Must also have 5 years of experience (which can have been gained concurrently with the primary experience requirement above) with the following:
- Migrating data from existing databases by doing Extraction, Transformation, and Loading of data through packages in SSIS;
- Using Microsoft SQL Server Data tools to do data analysis, reporting, and ETL process;
- Data modelling, reporting, analyzing, and monitoring using MS SQL Server, MSBI, Power BI, and Python;
- Implementing data security measures for protecting sensitive data and ensuring compliance with regulatory requirements; and
- Automating routine maintenance monitoring and deployment procedures.
This is a hybrid position working 3 days/week at the company office in Needham, MA and 2 days/week from a home office.
