Programmer II

• 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.

#J-18808-Ljbffr