Current jobs related to SQL Programmer/Analyst - Honolulu - University of Hawaii Foundation
-
Business Systems Analyst
5 days ago
Honolulu, Hawaii, United States HMSA Full timeBusiness Analyst Role at HMSAWe are seeking a skilled Business Analyst to join our team at HMSA. As a Business Analyst, you will play a critical role in analyzing business problems and developing solutions to improve efficiency and effectiveness.Key Responsibilities:Analyze business problems and develop recommendations for improvementDefine system...
-
FEP Business Analyst
3 weeks ago
Honolulu, United States HMSA Full timeAnalyzes business problems, including, but not limited to enhancements to add functionality and/or redesigns of systems or processes to improve efficiency. Defines system functionality for systems analysts and programmers, including, but not limited to the definitions of screens, reports, and internal processing, such as edits, calculations, etc. Develops...
-
Support Analyst
3 weeks ago
Honolulu, United States Diverse Lynx Full timePosition: Support Analyst Location: Honolulu, HI Duration: Full-Time 6 - 8 Years of experiecne. Job Description: •Knowledge of software development practice, concepts, technology and methodology •Hands-on Experience in .Net framework and Microsoft programming •language •Hands-on Experience in Web applications and Web Technologies like •JavaScript,...
-
Junior Business Analyst
2 months ago
Honolulu, United States Honolulu Disposal Service Inc Full timeJob DescriptionJob DescriptionJob Title: Junior Business AnalystDepartment: Information TechnologyReports To: Efficiency ManagerJob Overview:The Junior Business Analyst is responsible for transforming data into actionable insights that drive business value. The Junior Business Analyst will oversee, recommend and implement business and operational...
-
Support Analyst
3 months ago
Honolulu, United States Diverse Lynx Full timePosition: Support Analyst Location: Honolulu, HI Duration: Full-Time 6 - 8 Years of experiecne. Job Description: • Knowledge of software development practice, concepts, technology and methodology • Hands-on Experience in .Net framework and Microsoft programming • language • Hands-on Experience in Web applications and Web Technologies like...
-
Strategic Data Analyst
3 weeks ago
Honolulu, United States Dice Full timeDice is the leading career destination for tech experts at every stage of their careers. Our client, TEKsystems c/o Allegis Group, is seeking the following. Apply via Dice today! Aloha! One of our local healthcare companies in Hawaii is seeking a Data Analyst with 3-5 years of experience. This is a great opportunity to learn and grow within the Data...
-
Healthcare Data Analyst for Financial Planning
2 weeks ago
Honolulu, Hawaii, United States HMSA Full timeJob SummaryAs a Senior Financial Healthcare Data Analyst III at HMSA, you will lead provider negotiations and projects that include the Clinical Integration Division, Health Management Operations, Finance Division, and Executive Leadership. Your comprehensive statistical analysis will support corporate strategies and initiatives for all Lines of Business.Key...
-
Data Analyst
3 weeks ago
Honolulu, United States Proservice Hawaii Full timeJOIN YOUR PROHANA Listed as one of Hawaii's Best Places to Work for over 17 years and Hawaii's Top 250 Businesses, at ProService our PROhana isn't just your co-workers, it's your community. Being a member of our PROhana means you'll be joining a team of other high performing individuals committed to and motivated by our core mission: Empowering Hawaii...
-
Data Analyst
7 days ago
Honolulu, Hawaii, United States Hawaiian Airlines Full timeAbout the RoleWe are seeking a highly skilled Data Analyst to join our Marketing Insights team at Hawaiian Airlines. As a key member of our team, you will be responsible for analyzing complex data sets to inform business decisions and drive growth.Key ResponsibilitiesDevelop and maintain advanced data models to analyze customer behavior and preferencesDesign...
-
Data Analyst
1 week ago
Honolulu, Hawaii, United States Hawaiian Airlines Full timeAbout the RoleWe are seeking a highly skilled Data Analyst to join our Marketing Insights team at Hawaiian Airlines. As a key member of our team, you will be responsible for analyzing complex data sets to inform business decisions and drive growth.Key ResponsibilitiesDevelop and maintain advanced data models to analyze customer behavior and preferencesDesign...
-
Senior Financial Healthcare Data Analyst III
6 days ago
Honolulu, Hawaii, United States HMSA Full timeJob SummaryWe are seeking a highly skilled Financial Data Analyst to join our team at HMSA. As a key member of our Clinical Integration Division, you will play a critical role in leading provider negotiations and projects that drive business growth and improvement.Key ResponsibilitiesDevelop and analyze complex data sets to inform business strategies and...
-
Senior Analyst, Loyalty and Travel Products
1 week ago
Honolulu, United States Hawaiian Airlines Full timeHawaiian Airlines Senior Analyst, Loyalty and Travel Products - Honolulu, Hawaii At Hawaiian Airlines, we are all about welcoming our guests with Hawaiian hospitality and aloha, and taking care of our people, our home, and the communities we serve. Join our ‘ohana and be a part of an exciting team of professionals dedicated to serving our kama‘āina and...
-
Senior Financial Healthcare Data Analyst III
1 hour ago
Honolulu, Hawaii, United States HMSA Full timeJob SummaryAs a Senior Financial Healthcare Data Analyst III at HMSA, you will lead provider negotiations and projects that drive business growth and improvement. You will analyze complex data from multiple sources to inform corporate strategies and initiatives, ensuring alignment with business objectives.Key ResponsibilitiesDevelop and implement data-driven...
-
Temporary Senior Analyst Trust Operations
4 days ago
Honolulu, United States Bishop & Company, Inc. Full timeJob DescriptionJob DescriptionBishop and Company is seeking a Senior Analyst Trust Operations for an excellent client in downtown Honolulu, HI.***Please note this position is 100% on-site in Honolulu, HI******No relocation, In-state applicants only. Must be available to interview immediately. ***Reporting to the manager, this position is responsible for...
-
Data Processing Systems Analyst
3 days ago
Honolulu, Hawaii, United States Hawaii State Department of Education Full timeJob SummaryWe are seeking a highly skilled Data Processing Systems Analyst to join our team at the Hawaii State Department of Education. As a key member of our team, you will be responsible for analyzing and designing systems for electronic data processing, as well as participating in systems analysis and development.Key ResponsibilitiesConduct fact-finding...
-
Solutions Analyst
3 weeks ago
Honolulu, United States Hawaii Gas Full timeSolutions Analyst Job ID 2024-6290 # of Openings 1 Category Information Technology Location Kamakee Address 515 Kamakee Street Location US-HI-Honolulu Min USD $70,873.00/Yr. Max USD $90,000.00/Yr. Overview PURPOSE STATEMENT The Solutions Analyst will work closely with clients to improve their business and technical processes. This includes...
-
Senior Tax Analyst
1 week ago
Honolulu, Hawaii, United States Lumen Inc Full timeAbout the RoleLumen Inc is seeking a highly skilled Senior Tax Analyst to join our dynamic team. As a key member of our finance department, you will play a critical role in driving business growth by connecting people, data, and applications.Key ResponsibilitiesDevelop and maintain large-scale automation projects to drive efficiencies and improve tax...
-
Honolulu, Hawaii, United States Hawaiian Airlines Full timeAbout the RoleHawaiian Airlines is seeking a highly skilled Senior Business Analyst to join our team. As a key member of our Business Intelligence team, you will be responsible for analyzing complex data sets, identifying trends, and providing actionable insights to inform business decisions.Key ResponsibilitiesData Analysis: Extract, compile, and evaluate...
-
Senior Change Management Analyst
3 weeks ago
Honolulu, Hawaii, United States Oracle Full timePosition Overview:The Change Implementation Analyst is a foundational role within the Support Services of the Global Services organization. This position focuses on executing solution-related service request configurations for application upkeep.Key Responsibilities:- Conduct scope assessments by gathering relevant information and utilizing application tools...
-
Financial Data Analyst for Healthcare Operations
2 weeks ago
Honolulu, Hawaii, United States HMSA Full timeJob SummaryAs a Senior Financial Healthcare Data Analyst III at HMSA, you will lead provider negotiations and projects that include the Clinical Integration Division, Health Management Operations, Finance Division, and Executive Leadership. Your comprehensive statistical analysis will support corporate strategies and initiatives for all Lines of Business.Key...
SQL Programmer/Analyst
3 months ago
POSITION INFORMATION
Title: SQL Programmer/Analyst
Division: Advancement Services
FLSA Status: Full-Time, Exempt
Starting Annual Salary: $70,000.00 commensurate with experience
POSITION SUMMARY
Reporting to the Advancement Analyst Manager (“Manager”) for Advancement Services. The SQL Programmer/Analyst will assist in the oversight of reporting and processes related to University of Hawai’i Foundation (“UHF”) enterprise systems. The position is located in Honolulu, Hawai'i and is an in-person, in-office position. The SQL Programmer/Analyst is essentially a programmer who will design, develop, and maintain the UHF data warehouse. The SQL Programmer/Analyst will work closely with fundraising and support staff to identify and clarify reporting objectives and needs, create custom reports, provide ad-hoc data as requested, and load external data into the UHF CRM database and related systems. The SQL Programmer/Analyst coordinates reporting development efforts with the Director of Gift Processing, Director of Annual Giving, and senior Advancement Services personnel to ensure that all resources remain focused on priority projects.
ESSENTIAL FUNCTIONS
- Work with management and end users to determine requirements and write ad-hoc SQL and PL/SQL queries of varying complexity against Oracle and SQL Server databases.
- Create and maintain custom reports using SAP Crystal Reports and IBM Cognos.
- Troubleshoot complex systems; diagnose and resolve database issues, working with application support as necessary; recommend and/or develop corrective scripts to implement data fixes.
- Support existing Business Intelligence solutions.
- Maintain and enhance the existing data warehouse and related builds.
- Monitor overnight data warehouse builds and performance.
- Identify opportunities and perform query tuning.
- Validate data held in the data warehouse, identify and address data integrity issues in the data warehouse and transactional database.
- Communicate functional and technical opportunities and issues with Advancement Services management.
- Proactively assess enterprise system features and trends, make recommendations to the Manager and/or Director of Information Technology, and spearhead system upgrades and enhancements.
- Document and translate business requirements for application developers.
- Maintain reporting data accuracy, integrity, and security.
- Manage and perform alumni and donor data loads from external sources into the CRM, Ellucian Advance, and related databases, ensuring data accuracy and integrity.
- Manage and perform exports of alumni and donor data to external systems, including the alumni online community and other cloud-based event management, fundraising and reporting platforms.
- Assist in the management of alumni and donor data enrichment initiatives.
- Maintain data accuracy, integrity and security of all alumni, donor and constituent records; recommend and implement solutions for identified inadequacies.
- Stay abreast of the latest technologies for data analysis, reporting and visualization; make recommendations accordingly.
- Perform other duties and activities in support of the UHF mission as requested.
EVALUATION
The SQL Programmer/Analyst will meet annually with his/her supervisor to put in place a plan for the year. At the end of each year, the SQL Programmer/Analyst and his/her supervisor will review progress toward the annual goals.
QUALIFICATIONS
• Bachelor’s degree in related area and at least 2 years of experience in database development, programming, and data management, preferably using Oracle and/or SQL Server.
• Working knowledge of ANSI SQL, PL/SQL and 1-2 years of experience programming in SQL using administration software such as TOAD and SQL Server Management Studio.
• Proficiency in data imports and exports, and basic database administration.
• Skill in writing technical documentation clearly and concisely for both technical and non-technical audiences.
• Must possess excellent analytical, organizational, and communication skills.
• Must be able to organize and prioritize work, be proactive, take initiative, resolve problems, follow through, and simultaneously manage multiple priorities to ensure goals are met in a timely manner.
PREFERRED KNOWLEDGE, SKILLS AND ABILITIES
• 2 years of experience working with enterprise-scale reports and dashboards, preferably using IBM Cognos, SAP Crystal Reports or similar business intelligence platforms.
• Project management experience is highly desirable.
WORKING CONDITIONS
Based at the central UH Foundation offices located 1810 University Ave., Suite 300, Honolulu, HI 96822, the SQL Programmer/Analyst will work in an in person, in-office environment and will need to sit or stand for extended periods while either working at a computer, attending a meeting, or performing desk work. The SQL Programmer/ Analyst must have a valid driver’s license and acceptable driving record or have an acceptable mode of transportation. The SQL Programmer/Analyst may need to work weekends and evenings and must be able to work to the demands of the position, which may exceed a 40-hour work week. Must have a legal right to work in the United States and provide verification of authorization to work in the United States.
