Integration Developer & Database Administrator

Description

POSITION DESCRIPTION

TITLE: Integration Developer & Database Administrator   

DEPARTMENT: Information Technology

REPORTS TO: Data & Delivery Supervisor, Information Technology  

BASIC PURPOSE OF POSITION: 

The role of the Integration Developer & Database Administrator is to oversee SPR’s data ecosystem by designing, developing, and monitoring data pipelines and assets. The overall goal of the Integration Developer & Database Administrator is to facilitate a seamless flow of information throughout the company, considering both backend data structure and frontend accessibility for end-users through reporting and analytics. 

ESSENTIAL DUTIES AND RESPONSIBILITIES:

· Manage SPR’s Data Lake and Warehouse in Azure Databricks environment

· Extend SPR’s Data Warehouse and datamarts to meet business needs

· Troubleshoot data quality issues and identify resolution

· Monitor and Develop new ETL pipelines

· Manage ETL and procedural dependencies and scheduling

· Manage and extend semantic layer utilizing SSAS Tabular

· Manage reporting inventory in PowerBI and SSRS 

· Develop new reports and dashboards per business requirements

· Manage SPR’s Analytics code base in Azure DevOps

· Manage access and maintain performance of SPR’s on prem application SQL Databases

· Identify slow running queries and implement optimization 

· Monitor, optimize and allocate physical data storage for database systems

· Develop, implement, and maintain change control and testing processes for modifications to data pipelines, databases, and reports

· Manage and respond to tickets in ticketing system

· Participate in SPR’s data governance efforts

· Work with end users and IT Project Teams to facilitate best practices for data access, data consumption, code management, and data integration

Requirements

 POSITION SPECIFICATIONS:

· 5 or more years industry experience

· Bachelor’s Degree in Computer Science or related job experience

· Highly proficient in developing, delivering, and managing Analytics environments

· Highly proficient in SPR’s Azure Data stack technologies (Data Factory, Data Lake Storage, Databricks, PowerBI) 

· Highly proficient in SQL and SSAS Tabular 

· Python knowledge is a plus

· Knowledge of code management best practices and ability to maintain SPRs repos 

· Proficient in Azure Cloud Administration

· Proficiency in Microsoft SQL Server Administration

· Knowledge of SCADA Network Architecture including alignment to Purdue Reference Model is a plus

· Experience with Time Series Data Integration and Historians is a plus

· Knowledge of management methods, budget preparation/implementation and regulatory policies and practices to complete job functions and responsibilities

· Experience at working both independently and in a team-oriented, collaborative environment is essential

· Strong written and oral communication skills

· Strong interpersonal skills

· Adept at conducting research into project-related issues, technology, and software products.

· Must be able to learn, understand, and apply new technologies

· Ability to effectively prioritize and execute tasks in a high-pressure environment is crucial

PHYSICAL REQUIREMENTS:

Visual and manual dexterity is extremely important for this position. The job presents normal hazards that are present in an office environment. Incumbent will be subject to performing sedentary to light work, exerting up to 10 pounds of force occasionally, or constantly lift, carry, push, pull or otherwise move objects, reach overhead for items, stoop, bend, and twist while working. Other physical activities include ability to utilize fingers to feel and grasp objects or work devices as needed and manual dexterity in the use of the hands, seeing, talking, hearing, performing repetitive motions and standing for long periods of time at the copier or fax machine. The incumbent must be able to travel by car or helicopter to other work sites when needed.

DISCLAIMER:

The position description has been designed to indicate the general nature and level of work performed by employees within this classification. Principle duties and responsibilities are intended to describe those functions that are essential to the performance of this job. 

This description does not state or imply that the above are the only duties and responsibilities assigned to this position. Employees holding this position will be required to perform any other job-related duties as requested by management. All requirements are subject to possible modification to reasonably accommodate individuals with a disability.