Programmer II Job at JBA International, Napa, CA

YWQxakdyRlpjT0FTVVFycmk1bmI3THA5b1E9PQ==
  • 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

Aerotek

Warehouse Shipper Job at Aerotek

 ...Peak road,**Job Description**+ you will play a vital role in ensuring the efficient movement and management of goods within the warehouse.+ Your primary duties will include picking orders, boxing, packaging, shrink wrapping, and palletizing orders.+ You will utilize... 

Mayo Clinic

Nurse Practitioner or Physician Assistant - Hospital Internal Medicine - New Prague Job at Mayo Clinic

 ...City: New Prague State: MN Remote: No Department: Hospital Internal Medicine Why Mayo Clinic Mayo Clinic is top-ranked in more specialties than any other care provider according to U.S. News & World Report. As we work together to put the needs of the... 

Qual Pac 1600

Inside Sales Representative Job at Qual Pac 1600

 ...difference with over 1,000 team players, please read on. Inside Sales RepresentativeSalary: $65,000 with an additional 10%...  ...a successful sale.* Close consumable packaging products and equipment sales and achieve monthly quotas.* Research new accounts, identify... 

Fetch Pet Insurance

Claims Adjuster Job at Fetch Pet Insurance

 ...RESPONSIBILITIES. Adjudicate assigned claims in accordance with the Terms &...  ...computer systems simultaneously Work independently in a remote capacity, while also fostering...  ...equivalent preferred Property and Casualty Adjuster license in good standing preferred... 

Rustman Agency

Account Manager Job at Rustman Agency

 ...Our team operates in a flexible, remote environment built on trust, service, and growth. Job Summary We are looking for an Account Manager to support and maintain strong relationships with our clients. In this role, you will act as a trusted advisor, helping clients...