Essential Functions
Computer and Network Operations
Design and develop ETL processes to transform a variety of raw data flat files and excel spreadsheets into SQL databases.
Develop and optimize queries stored procedure functions views and automation scripts using SQL TSQL Python C# and / or Powershell.
Utilize data management best practices and in-depth usage of Microsoft SSIS & SSRS to accomplish business initiatives.
Create and maintain a complex reporting structure including data storage systems data sets reports and dashboards using SQL queries stored procedures and programming languages such as R and Python.
Evaluate business requests for data and reports to determine feasibility cost and time required compatibility with current systems and effectiveness.
Develop business requirements and technical requirements for reporting/visualizations data models and databases. Create technical specifications derived from technical requirements.
Design and develop enterprise departmental business intelligence and data warehousing solutions.
Create and improve existing data warehouse processes optimize reporting and improve data integrity throughout organization.
Responsible for daily support of ARCU/Post ARCU ETL jobs completion and remediate issues.
Create and modify programs to run on the core processing system.
Manage assigned work queue on a constant daily basis updating requests with comments as necessary.
Prioritize daily schedule as work dictates.
Provide on-call support for critical production systems.
Complete assigned programming tasks and projects as required.
Document created code in accordance with direction and company standards.
Program test debug and administer computer software and processes.
Employ project management tools and methodologies in completion of programming projects and initiatives.
Develop and maintain user guides diagrams procedures and business continuity information.