Sr. Database Engineer

The Sr. Database Engineer is responsible for the integration of client data elements into the defined architectural standard for use by various departments throughout the organization. This individual will assist project teams with tasks associated with the Initiation, Planning, Development, Deployment, and Ongoing Support Maintenance phases of our Agile Methodology in accordance with the documentation that is provided defining project scope and deliverables. These activities may include the development of data structures, ETL development, BI report development, and campaign execution.

Essential Duties and Responsibilities

Develop Logic and Physical models based on the definedarchitecture

Data Integration into approved architectures

Extract Transform Load (ETL) development andtesting

Submission of ETL solutions for final approval to the Systems Administrator

Development of appropriate notification / alert strategies within all ETLs

Serve as Subject Matter Expert (SME) within the Data Services Department for multiple clients / projects

Develop BI solutions using various toolsi.e.Azure Data Factory, SSIS, to meet organizational needs

Develop, implement and support customer user-defined stored procedures, functions, andviews

Maintain dataintegrity

Suggest software, hardware, and process-level improvements to uppermanagement

Suggest overall process improvements for existing solutions to uppermanagement

Supply proper data documentation for various project phases (as necessary),i.e.Entity-Relationship Diagrams, Data Dictionaries, ETL definitions

Advise Systems Administrator on effective backup / replication scheduling.

Capacity / scalability planning for expanding dataneeds

Provide 24 / 7 support for clients / projects serving as the SME (as necessary)

Integration of various 3rd data objects,i.e.Acxiom,DataFlux

Development and implementation of various Householding strategies as defined by PM on a per-clientbasis

Participate in peer codereview

Other duties and responsibilities asassigned

Sense of ownership and pride in your performance and its impact on the company's success

Critical thinker and problem-solving skills

Background / Experience

Excellent understanding of T-SQL

7+ years Microsoft SQL Server 2016 and above

7+ years IT industry experience; Marketing or Advertising experience a plus

Excellent skills with ETL tools like Azure Data Factory and SSIS

VB Script, C#, .NET, and Azure Cloud experience a plus

MCSA, MSCE, MCDBA Certifications a plus

Advancedproblem-solvingskills and excellent communication skills

Team player

Good time-management skills

Great interpersonal and communication skills