SQL DBA - Advanced Level

JOB DESCRIPTION (General Overview of the Role):
Technician role provides support to TBM Office Analysts in stewarding the operational activities of the service.

Global Planning data coordinator
* Perform data management activities for general Global Planning processes
* Design, automate, and execute new and existing queries and reports from ITS/Global Planning Data Sources
* Steward ad-hoc tasks as required from time to time

TBM Operational activities
* Liaise with the ITDW Support team to add/change/delete Data Sources
* Manage automation of monthly report data load cadence
o Validate data loading from ITDW
o Run any necessary scripts & associated data loading
* Generating ad-hoc information for TBM Analysts/Planners
* Execute and recommend updates to Apptio monthly cadence runbook
* Receive and process application guidance from TBM Office Analysts, including documentation of the connections made within the Apptio Model
* Provide regular updates on the process throughout the cycle
* As appropriate, work within the Apptio tool or supporting dashboards to ensure timely, uninterrupted report delivery

Value-added services including:
* Recommendations to ITDW to improve data gathering & validation processes
* Automate work activities within the scope of assigned role, promoting long-term efficiency
* Perform activities purposefully for the transition of data load & basic reporting to another team

Required skills
* Technical Skills: Advanced SQL knowledge to provide guiding interface to ITDW team
* Technical Skills or Exposure to Tableau, PowerBI, and data modeling for analysis; experience or ambition to work with Financial Modeling technologies, such as Apptio or Nicus, desired
* Technical Skills: Exposure & experience with Visual Studio and SSIS/SSAS
* Technical Skills: Self-reliant with programming concepts & scripting in Powershell
* Work Processes: Exposure to Agile-Scrum work methods and expectations
* Communication Skills: Able to produce and maintain documentation with little supervision
* Work ethic: self-motivated with attention to detail and a desire to meet or exceed expectations; reliable; generally positive disposition
* Motivated to implement sustainable automation or, at minimum, provide practicable suggestions to redesign potentially redundant or slow processes

The Woodlands, TX, US