Job Description

Sr. Database Engineer

Location:

BostonMassachusetts

Date Posted:

11/5/2021

Employment Type:

Permanent

Recruiter:

Clayton Minnich

Recruiter Email:

clayton.minnich@avidtr.com

Job ID:

JN -112021-14766

Job Description

What you'll do:

Responsible for developing architecture/processes, integrating solutions and documenting of SQL Server using the full Microsoft SQL Server stack; Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Powershell. and Tableau. Administer and provide technical leadership in support of the firm’s databases or BI enterprise applications and tools. Tableau environment and 3rd party tools will be managed and used as needed for support of BI operations and services.

This individual will serve as project manager for business intelligence implementations/upgrades, and provide technical database support for other projects:  vendor selection process, business processes analysis and support.

Develop, document and maintain key data integration processes in support of projects and ongoing services. Provide data integration services in support of local and hosted environments for enterprise applications, including the Enterprise Data Warehouse (EDW). Work as technical liaison between vendors and business to help translate business requirements into technical solutions. This individual will be a direct contact and resource for data projects and provide technical leadership/consulting services as needed.
 

Who you are:

  • BS in Computer Science or related field is preferred. 

  • 7 or more years of experience in Business Intelligence.

  • Microsoft SQL Server Certification is preferred

 

Required:

  • Expertise in Microsoft data development tools (SSMS, Visual Studio Data Tools).

  • Advanced T-SQL development, troubleshooting, and optimization.

  • Expert/Advanced SSIS.

  • Expert/Advanced SSRS.

  • Intermediate/Advanced Powershell Scripting.

  • C# Scripting in SSIS (Script Task).

  • Technical expertise regarding the use of data models, database design and architecture techniques.

  • Expert knowledge of Data Warehousing using the Kimball Dimensional Modeling method.

  • Expert knowledge of ETL design.

  • Expert level Data visualization or Data Analysis skills with Tableau required.

  • Experience working with API calls and handling return data in JSON and XML.

  • Some experience with SQL Server Performance Monitoring.

  • Some experience installing, configuring, administering, developing and supporting (Primarily, but not exclusively) Microsoft SQL Server databases, including experience with related technologies.

  • Some experience with SQL AAG in particular and HA/DR DB strategies in general.

  • Basic HTML and CSS.

  • Experience working in an Agile workflow.

  • Experience using Git for source control.

  • Ability to work independently without close supervision.

  • Genuine interest in and curiosity for Database technologies.

  • Strong knowledge of project management methodologies.

  • Excellent organizational, teamwork, customer service and problem-solving skills required.

  • Excellent written, verbal and interpersonal communication skills.

  • Excellent time management skills.

  • Regular business hours, monthly on-call rotation, and occasional evening/weekend work
  • Advanced Powershell/C# scripting.

 

Preferred:

  • General Linux experience.

Apply for this job