What are the responsibilities and job description for the Programmer II position at JBA International?
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.