$140k | MS SQL Architect w/PowerBI/Azure | Nashville'ish in Nashville, TN at Vaco

Date Posted: 11/15/2020

Job Snapshot

Job Description

Position will be remote for now
Must move to Nashville by Q1

About the Role

Design, implement and maintain reporting databases, data warehouse and OLAP data structures

Design, develop, test, deliver, and implement SQL solutions within ETL processes.

Manage day to day operations of multiple Microsoft SQL Server/Postgres databases.

Optimize databases for performance and scalability.

Develop, implement and optimize stored procedures and functions using T-SQL

Analyze, define, and document system requirements for data, workflow, logical processes, interfaces with other systems, internal and external checks and controls, and outputs.

Responsible for problem resolution, database configuration, capacity planning, performance tuning and optimizations.

Create and maintain database master plans, data dictionaries and disaster recovery documentation

Consults with internal and external clients to prototype, refine, test, and debug databases and obtain client approval.

Writes and maintains documentation to describe program development, logic, coding, testing, changes, and corrections.

Design, build, and deploy BI solutions (Looker)

Job Requirements

About the Role Design, implement and maintain reporting databases, data warehouse and OLAP data structures Design, develop, test, deliver, and implement SQL solutions within ETL processes. Manage day to day operations of multiple Microsoft SQL Server/Postgres databases. Optimize databases for performance and scalability. Develop, implement and optimize stored procedures and functions using T-SQL Analyze, define, and document system requirements for data, workflow, logical processes, interfaces with other systems, internal and external checks and controls, and outputs. Responsible for problem resolution, database configuration, capacity planning, performance tuning and optimizations. Create and maintain database master plans, data dictionaries and disaster recovery documentation Consults with internal and external clients to prototype, refine, test, and debug databases and obtain client approval. Writes and maintains documentation to describe program development, logic, coding, testing, changes, and corrections. Design, build, and deploy BI solutions (Looker)