JBA International ยท 5 months ago
Programmer II
Napa, California, US
Full-time
Onsite
Mid Level
$41/hr - $54/hrJBA International is a company focused on providing innovative solutions, and they are seeking a Programmer II to enhance their data management operations. The role involves designing and developing ETL processes, optimizing SQL queries, and supporting business intelligence and data warehousing solutions.
ConsultingHealth CareLegalProfessional Services
No H1B
U.S. Citizen Only
Responsibilities
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
Qualification
Required
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
Company
JBA International
JBA International provides financial, life science, healthcare, legal, and office administration services.
Founded in 1988
201-500 employees
Funding
Current Stage
Growth StageLeadership Team
Jacqueline Buickians
Chief Executive Officer
Company data provided by crunchbase