Analyze and evaluate reported problems, take responsibility for resolution, and prevent recurrence.
Develop, implement, administer, and maintain, logical and physical data models to support business, performance, reliability, and security requirements.
Develop, test, implement, troubleshoot, and support data extraction, transformation, and loading processes.
Maintain technical documentation related for the data warehouse and other database systems.
Coach and train other employees on proper access and use of database systems.
Assists in setting standards, guidelines, and procedures to utilize the corporate database systems.
Support use of front-end data access, reporting, and analysis tools.
Tune data warehouse and other database systems for optimal performance and reliability.
Develop and maintain automation scripts using PowerShell to automate non-production data warehouse refreshes.
Independently lead Projects, Enhancements and BAU work without oversight.
Manage departmental internal controls and regulatory issues.
Helps direct work of managed service providers.
Requirements:
Bachelor’s degree in computer science or equivalent professional experience.
5+ years of professional experience developing, tuning, troubleshooting, and supporting database systems, and data warehouses.
Advanced knowledge of database systems, including Oracle, SQL Server, T-SQL, SSIS, and SSRS preferred (optional DB2).