Programmer II
Napa, California
Full Time USD 80K - 106K
Redwood Credit Union
Redwood Credit Union has been a trusted, and community focused credit union since 1950. We offer banking services to anyone in the North Bay/SF area.Redwood Credit Union is looking for a Programmer II, who will develop and support programming applications to accomplish business objectives. This consists of advanced analysis, coding, designing, implementing, and debugging programs using standard scripting language programming techniques and browser- based languages. Responsible for building and managing a centralized data and reporting platform to be used by all data consumers in the organization, analyze business problems and communicate highly complex data trends to organizational leaders in a way that's easy to understand.
Essential FunctionsComputer 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.
Minimum Qualifications: Knowledge, Skills and Abilities
- Advanced knowledge of SQL and in-depth experience using Microsoft SSIS & SSRS, and Python.
- Extensive knowledge in Microsoft Power BI, Power BI Desktop, Service, Gateways, Incremental data refresh, and Row level security.
- Proven experience using programming languages such as R, Python, and Powershell.
- ETL experience in a data warehouse environment using slowly changing dimensions.
- Proven ability to ingest and manipulate data in Power BI from multiple source systems using complex SQL queries and DAX to create production ready data models.
- Experience using version control tools such as Git, Bitbucket or similar central repository tools
- Familiarity with NoSQL Databases.
- Familiarity with JIRA preferred.
- • Preferred experience with Azure: Data Factory, Databricks, Data Lake Storage, Analysis Services, and API – PySpark.
- Ability to multi-task in a fast-paced environment.
- Ability to prioritize tasks and projects using a browser-based tracking system.
- Ability to read and understand technical manuals and specifications.
- Current knowledge of laws, rules, and regulations pertaining to information technology relating to financial institutions.
- Ability to work independently with limited supervision.
- Ability to develop and implement technology projects.
- Ability to effectively interact and communicate with outside vendors and internal clients.
- Ability to communicate effectively both verbally and in writing.
- Ability to establish and maintain effective working relationships with a diverse group of people.
- Ability to analyze complex business projects and determining the most appropriate method of achieving the necessary results.
- Excellent written and verbal communication skills.
Physical Requirements
- Ability to stand, bend, stoop, sit, walk, twist and turn.
- Ability to lift up to 25 pounds.
- Ability to use a computer keyboard, calculator, and mouse.
- Work environment is indoors; majority of the time is spent sitting at a desk.
Compensation: Base starting range: $40.00 to $53.00 per hour commensurate with experience. Our base salary starting range is based on scope and responsibilities of the position, candidate's work experience, education/training, key skills, and internal peer equity. We offer a competitive total rewards package including a wide range of medical, dental, vision, financial, and other benefits.
Redwood Credit Union offers a robust benefits package to our eligible employees including:• Competitive medical, dental, and vision insurance, mental health offerings• Employee performance incentive plan• Salary Advancement– Merit increase based on performance• 401(k) program with employer match• Time Off- Competitive PTO accrual plus 11 paid company holidays and your birthday off!
RCU Discounts and Perks:• RCU employees are eligible for a .75% discount off RCU standard collateral auto loans• RCU employees are eligible for a 1% discount on all recreational or boat loan products• 2% discount off Visas and LOC Loans through RCU• 0% interest loan to support employees with various immigration related expenses such as visa application fees and relocation costs. Loan amount up to $1,000.• 0% interest loan to support employees with expenses associated with the naturalization process. Loan amount up to $15,000.• 0% interest on garment, fitness, or home office equipment loan of up to $500• 100% financing for employee purchased homes! Internal Team MembersIf you are a current Team Member, please apply through the internal careers page located in RCUNET. We are an Equal Opportunity Employer
Tags: APIs Azure Bitbucket Business Intelligence Computer Science Databricks Data management Data warehouse Data Warehousing ETL Excel Git Jira Nonprofit NoSQL Power BI PySpark Python R Security SQL SSIS T-SQL
Perks/benefits: 401(k) matching Competitive pay Equity / stock options Fitness / gym Gear Health care Relocation support
More jobs like this
Explore more career opportunities
Find even more open roles below ordered by popularity of job title or skills/products/technologies used.