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.

JBA International