We are looking for BI Engineer to join us here at Global Shares a JP Morgan Company, who has an inquiring mind, a talent for precision, and enjoys working in all areas of Reporting and Analytics. The ideal candidate will have a strong background in both front-end and back-end development, with a particular emphasis on data integration, processing, and visualization. This role will enhance your career and offer a chance for you to contribute to the success of our customers across a huge range of industries, worldwide. We're excited to see what you'll bring to our team.
Responsibilities:
1. Design, develop and test BI solutions such as databases, data cubes, queries and views, reports, and dashboards. Performs data conversions, imports, and exports of data within and between internal and external software systems.
2. Implements data structures using best practices in data modelling, processes, and technologies.
3. Enhance the performance of business intelligence tools by defining data to filter and indexes, lead performance tuning of BI applications ensuring data integrity and security.
4. Document new and existing models, solutions, and implementations as well as lead the integration efforts for merging BI platforms with enterprise systems and applications.
5. Develop and maintain Java Spring Boot applications to support BI functionalities.
6. Create and maintain dashboards and reports using Sisense, Tableau and Jasper.
7. Utilize Azure Cloud Services for storage, compute, and other relevant functionalities.
8. Ensure effective use of Azure Data Factory Studio for data pipeline management.
9. Implement and manage Kafka for real-time data streaming and processing.
10. Manage applications using Kubernetes. Ensure high availability, scalability, and efficient resource utilization.
11. Develop and manage REST APIs and other API types for seamless data exchange between systems. Ensure APIs are secure, scalable, and well-documented.
Required qualifications, capabilities, and skills
12. PostgreSQL & Microsoft SQL Server knowledge is required with strong skills in writing & optimizing SQL queries for analytics.
13. Experience in data warehousing processes using advanced SQL functions and procedures, with focus on portability within multiple environments (QA, UAT and PROD).
14. Experience with relational databases, data modelling, and data visualization tools to deliver results.
15. Certifications in relevant technologies (., Azure Cloud Services, Kafka, Kubernetes).
16. Proficient in using Kafka for data streaming and processing.
17. Skilled in deploying and managing applications on Kubernetes.
18. Solid understanding of API development and integration.
19. Knowledge of data security best practices and regulatory compliance.
20. Project experience with the proven ability to work on multiple projects concurrently leveraging excellent organization and time-management skills.
21. Experience providing business-related/and or technical subject matter expertise on large, highly complex reporting projects and business analytics to support management, multi-functional departments, staff members, and peers. Strong verbal and written communication skills to explain confidential and complex issues and make recommendations to leadership.