Epyllion Group

More jobs from this company

Summary

Education

Experience

At least 12 years
The applicants should have experience in the following business area(s):
Telecommunication, Software Company, IT Enabled Service, Garments, Group of Companies

Additional Requirements

Hands-on in SSIS (Creation of Packages, Transformation like Lookup, Expression, Scheduling of Jobs) Perform Development & Support Activities for Data Warehousing domain using ETL Tools and Technologies.
Proficiency in working with relational databases, such as SQL Server, PGSQL, or MySQL.
Hands-on in DBA activities like should be aware of ways to monitor database performance, implement changes.
Strong proficiency in developing and managing Power BI reports and dashboards.
Hands-on in SQL, T-SQL. Ability to write complex SQL queries & performance tune them.
Understand High Level Design, Application Interface Design & Build and Low-Level Design.
Perform application analysis & propose technical solution for application enhancement or resolve production issues.
Perform Development & Deployment of database changes.
Creation of necessary documentation for all project deliverable phases.
Handle Production Issues & ensure SLAs are met.
Excellent communication skills for interacting with clients.
Strong problem-solving and analytical skills, with the ability to quickly grasp complex systems and troubleshoot issues.
Excellent communication and collaboration skills, with the ability to work effectively in a team environment.
Ability to manage multiple tasks and priorities, meet deadlines, and adapt to changing requirements.
Experience with cloud platforms (e.g., Azure, AWS) is a plus.

Data Warehouse/Data Lake Development:

Design, develop, and maintain data warehouse/data lake solutions to support the storage, integration, and retrieval of project-related data from disparate sources.
Define data modeling strategies, data structures, and ETL processes to ensure data integrity, consistency, and quality within the data warehouse environment.
Implement data governance policies, standards, and procedures to enforce data quality, security, and compliance requirements.

Power BI Development:

Create visually appealing and interactive Power BI dashboards, reports, and visualizations to present project-related data and insights in a meaningful and actionable manner.
Collaborate with project stakeholders to gather reporting requirements, define KPIs, and design data visualizations that address their information needs and support decision-making processes.
Customize and configure Power BI features, functionalities, and data connectors to integrate with various data sources and systems.

Data Analytics and Insights:

Perform data analysis, trend analysis, and predictive modeling using Power BI and other analytical tools to identify patterns, trends, and opportunities for process improvement and optimization.
Conduct ad-hoc data queries, data mining, and data profiling activities to extract actionable insights from project data and support project management decision-making.
Develop data-driven recommendations, insights, and reports to facilitate strategic planning, risk assessment, and performance monitoring across water and wastewater projects.

Database Management and Optimization:

Administer and optimize database systems, including MS SQL Server, PostgreSQL, or other relational database management systems (RDBMS), to ensure data availability, performance, and scalability.
Monitor database performance, conduct performance tuning, and implement indexing strategies to enhance query performance and optimize data retrieval operations.
Implement backup and recovery procedures, data security measures, and disaster recovery solutions to safeguard project data and ensure business continuity.

Collaboration and Documentation:

Collaborate with cross-functional teams, including project managers, data analysts, and IT professionals, to understand data requirements, gather feedback, and deliver data-driven solutions that meet project objectives.
Document technical specifications, data models, and solution architectures to ensure clarity, consistency, and maintainability of data warehouse and Power BI solutions.
Provide training and support to end-users on Power BI usage, best practices, and data visualization techniques to promote self-service analytics and user adoption.

Work at office

Full Time

Dhaka (Tejgaon)