Job Description
The candidate is responsible for warehouse design to ETL (Extract Transform Load) development till MIS (Management Information) reports development and delivery. The role understands heterogeneous data structures and develops 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's Degree in Information Systems or equivalent.
- 8-10 years of experience as a BI developer and 5-6 years in a Business Analyst role.
- Strong experience in working with Oracle / SQL databases.
- Expertise in the Microsoft BI platform – SSIS, SSRS, SSAS, Power Pivot.
- Strong dimension modeling experience.
- Experience in handling heterogeneous data sources, warehouse modeling, analytics, and ETL 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 is preferred.
- Prior experience in SEI (Sage Enterprise Intelligence) is preferred.
- Prior exposure to InvestOne, Neoxam, Flexcube, Sage would be preferred.
#J-18808-Ljbffr
