Programmer II Job at JBA International, Napa, CA

VHc3ajBKZnZRM09nb2lBOE9iY1RqbldRYkE9PQ==
  • JBA International
  • Napa, CA

Job Description

 

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.

Job Tags

Similar Jobs

Lincoln Park Zoological Society

Veterinary Technician Job at Lincoln Park Zoological Society

Lincoln Park Zoo inspires communities to create environments where wildlife will thrive in our urbanizing world. The zoo is a leader in local and global conservation, animal care and welfare, learning, and science. A historic Chicago landmark founded in 1868, the not-for... 

OdySea Aquarium

Animal Care Specialist I Job at OdySea Aquarium

 ...equivalent experience required. One to two years of professional husbandry, training, and interactive guest experience at a public zoo, aquarium, or similar facility. Emphasis should be on animal care and maintenance of exhibit and holding areas. Demonstrated... 

Super Soccer Stars

Part Time Golf, Tennis, Floor Hockey, Cheer Coaches for Elementary Schools Job at Super Soccer Stars

 ...TEAM! TGA Premier Sports runs a leading school-based youth sports enrichment programs for grades K-6. We are looking for enthusiastic golf, tennis, and floor hockey coaches to impact lives of the children we serve. Part time hours are from 4-10 hours per week , with... 

APL Associates

Virtual Administrative Assistant Job at APL Associates

 ...Job Description: Virtual Administrative Assistant Company: APL ASSOCIATES About APL Associates APL Associates is a private agency focused on vocational rehabilitation and developing employment opportunities for its clients through programs administered by the... 

Animal Care Clinic

DVM Student Externship Job at Animal Care Clinic

 ...diverse, caring, skilled and driven, making it an ideal area to raise a family! Popular activities in the area include, The Childrens Zoo, University of Nebraska sporting events and the many trails throughout the town that allow for hiking, biking and casual strolls with...