The Hybrid Database Engineer / Business Intelligence Specialist is responsible for assisting the IT Director in IT matters performing analysis and research in a bid to optimize technical support processes in a company or organization. The Hybrid Database Engineer and Business Intelligence Specialist will be responsible for designing, developing, and maintaining our database systems while also providing business intelligence solutions to support data-driven decision-making. This role requires a blend of technical expertise in database management and business intelligence to optimize data storage, retrieval, and analysis.
PRIMARY ACCOUNTABILITIES
1. Design, develop, and maintain database systems to ensure optimal performance, security, and reliability.
2. Develop and implement business intelligence solutions, including data models, dashboards, and reports.
3. Collaborate with cross-functional teams to gather and analyze business requirements and translate them into technical specifications.
4. Perform data extraction, transformation, and loading (ETL) processes to integrate data from various sources.
5. Optimize database queries and performance to support efficient data retrieval and analysis.
6. Ensure data quality and integrity by implementing data governance and validation processes.
7. Provide technical support and troubleshooting for database and business intelligence systems.
8. Stay updated with the latest industry trends and technologies in database management and business intelligence.
COMPLIANCE
All employees of our institution are required to ensure compliance with Anti-Money Laundering (AML)/Bank Secrecy Act (BSA) and sanctions regulations. Roles and responsibilities related to compliance include:
1. Identify and report unusual and/or suspicious activities: Suspicious and/or unusual transactions recognized by the employee must be reported to the appropriate compliance personnel.
2. Monitor and screen transactions (as applicable) to ensure that they comply with sanctions regulations and do not involve individuals or entities on the Office of Foreign Assets Control (OFAC) list. This requires a thorough understanding of the bank's sanctions policies and procedures, as well as the ability to identify and flag transactions that may be in violation of these regulations.
3. Participate in regular training on AML/BSA and sanctions regulations. This includes training on how to identify and report unusual and/or suspicious activities, conduct CDD, and screen transactions for sanctions compliance.
4. Maintain accurate records of all transactions and activities, as applicable and ensure that these records are available for audit and review by regulatory authorities.
EDUCATION AND/OR WORK EXPERIENCE REQUIREMENTS
These specifications are general guidelines based on the minimum experience normally considered essential to the satisfactory performance of this position.
1. Computer science, information systems, engineering or related field (degree, diploma, certificate)
2. Minimum of 2-3 years of experience as a Database Engineer/Business Intelligence Specialist in at least one (preferably two) of the following areas:
- Strong proficiency in SQL and database management systems (e.g., PostgreSQL, SQL Server).
- Experience in non-relational databases such as MongoDB
- Experience with operating and supporting non-relational databases, such as MongoDB.
- Experience with Microsoft Power Apps and data architecture
- Experience with business intelligence tools (e.g., Tableau, Power BI, Looker).
- Knowledge of data warehousing concepts and ETL processes.
Preferred Qualifications:
- Experience with cloud-based data warehouses (e.g., Snowflake, Microsoft Fabric).
- Familiarity with machine learning and data science concepts.
- Previously worked on Core Banking / Finance systems.
- Certification in database management or business intelligence tools
3. Microsoft 365/Office 365 Support
4. Physical wiring/wire management capabilities
5. Hardware / Equipment selection capabilities (i.e. switches, firewalls, laptops)
6. Proven experience as a Database Engineer and/or Business Intelligence Specialist.
7. Strong proficiency in SQL and experience with RDBMS (e.g., SQL Server, MySQL, PostgreSQL).
8. Experience with BI tools such as Tableau, Power BI, or QlikView.
9. Excellent analytical and problem-solving skills.
10. Ability to work in a hybrid environment, balancing remote and onsite work.
MINIMUM REQUIREMENTS
The requirements listed below are representative of the knowledge, skill and/or ability required to perform the position in a satisfactory manner. Individual abilities may result in some deviation from these guidelines.
1. Strong analytical skills and attention to detail
2. Strong written and verbal communication skills
3. Familiarity with anti-money laundering laws and regulations, such as the Bank Secrecy Act and the USA PATRIOT Act
4. Ability to work independently and as part of a team
5. Strong working knowledge of MS Office Suite and other relevant software
6. Outstanding communication and negotiation skills.
7. Demonstrated leadership experience; strong problem-solving abilities; excellent interpersonal, written, and verbal communication skills in English and Spanish.
8. Demonstrated ability to think and act strategically.
9. Strong working knowledge of AML-related software such as AML monitoring systems, transaction monitoring systems, and KYC systems
10. Sound knowledge of US banking industry AML & Sanctions legal and regulatory framework (at the federal and state levels), current banking practices, and industry standards.
11. Excellent computer proficiency (MS Office – Word, Excel, PowerPoint and Outlook).
12. Excellent verbal and written communication skills in English & Spanish, including ability to effectively communicate with internal and external parties.
13. Must be able to work under pressure and meet deadlines, while maintaining a positive attitude and providing exemplary customer service.
14. Ability to deal with complex problems involving multiple facets and variables in non-standardized situations.
15. Additional Skills (Nice to have)
- SCCM management
- Windows/Linux support
- Network configuration (firewalls, elastic load balancers, gateways, tunnels)
Job Type: Full-time
Pay: $70,000.00 - $80,000.00 per year
Benefits:
- 401(k)
- Dental insurance
- Employee assistance program
- Flexible schedule
- Flexible spending account
- Health insurance
- Life insurance
- Paid time off
- Parental leave
- Referral program
- Tuition reimbursement
- Vision insurance
Compensation package:
Experience level:
Schedule:
Ability to Relocate:
- San Juan, PR 00907: Relocate before starting work (Required)
Work Location: Hybrid remote in San Juan, PR 00907