Job Description
The candidate is responsible for Warehouse design to ETL (Extract Transform Load) development and MIS (Management Information) reports development and delivery. The role requires understanding heterogeneous data structures and developing long-term sustainable data models.
Duties & Responsibilities
- Collaborate with business stakeholders to understand reporting and analytics requirements.
- Analyze and document user needs to design effective BI solutions.
- Design and develop data models to support reporting and analytics.
- Create and maintain logical and physical data models for BI applications.
- Develop Extract, Transform, Load (ETL) processes to extract data from various sources.
- Transform and load data into data warehouses or data marts for BI purposes.
- Create interactive and visually appealing reports and dashboards.
- Implement data visualizations to effectively communicate insights to stakeholders.
- Integrate data from diverse sources, ensuring data consistency and accuracy.
- Implement data integration solutions for seamless information flow.
- Optimize the performance of BI queries and reports.
- Identify and resolve performance bottlenecks for efficient data retrieval.
- Implement security measures to protect sensitive BI data.
- Define and enforce access control policies for data confidentiality.
- Document BI solutions, including data models, ETL processes, and report specifications.
- Create user documentation and training materials.
- Develop server-side logic using PHP for web applications.
- Ensure efficient data processing and server-side functionality.
- Integrate PHP applications with databases (e.g., MySQL, PostgreSQL) to manage data.
- Implement database queries and optimize database interactions.
- Write clean, efficient, and maintainable PHP code.
- Optimize code for performance and scalability.
- Ensure seamless communication between the server and client sides.
- Implement security measures in PHP applications to prevent vulnerabilities.
- Address common security issues, such as SQL injection and cross-site scripting.
- Develop and maintain APIs (Application Programming Interfaces) for communication between different systems.
- Ensure API documentation is comprehensive and up-to-date.
Desired Experience & Qualification
- Bachelor Degree in Information Systems or equivalent.
- 8-10 years experience as a BI developer and 5-6 years in a Business Analyst role.
- Strong experience in working with Oracle / SQL databases.
- Expertise on Microsoft BI platform – SSIS (Microsoft SQL Server Integration Services), SSRS (Microsoft SQL Server Reporting Services), SSAS (Microsoft SQL Server Analysis Services), Power Pivot.
- Strong Dimension Modeling experience.
- Experience in handling heterogeneous data sources, Warehouse modeling, analytics, and ETL (Extract, Transform, Load) tools.
- Expertise in time series, regression, and predictive analysis.
- Experience in financial services, especially mutual funds, is essential.
- Oracle Development experience is preferred.
- Experience in Business Object and OBIEE (Oracle Business Intelligence) is preferred.
- Prior Experience in SEI (Sage Enterprise Intelligence) is preferred.
- Prior exposure to InvestOne, Neoxam, Flexcube, Sage would be preferred.
#J-18808-Ljbffr
