Senior Database Engineer
We are looking for a Database Engineer responsible for the development, maintenance, and deployment of database applications. Your primary focus will be developing high-end data flows and processes from business requirements, suitable data (DW/OLAP) model that further supports high-end data-centric applications and business-reports/dashboards by following standard architecture patterns and best practices. Therefore, a commitment to collaborative problem solving, sophisticated design, and creating quality products is essential.
Ø Hands-on expertise on DW/DM schema, dimensional modeling, OLAP.
Ø Experience with cloud computing in the Azure environment with Azure Data Factory & Integration Runtime, or similar technologies.
Ø Transforming business data requirements in terms of the data model.
Ø Understanding Data architecture.
Ø Working on the Microsoft BI platform.
Ø Participating in business, meetings to grasp the need and suggest different options related to data ingestion, data sizing, feasibilities.
Ø Writing data transformations logics, data flows, and data pipeline.
Ø Good understanding of different dimensions and fact types and when to use which one.
Ø Assist with DW Schema (Star, Snow-flake, galaxy, or combined) design.
Ø Writing ETL SQL codes and ADF data flows to support data into Azure DW architecture.
Ø Code review, SQL query tuning, write/deploy SQL patches, database scripts, and work with applications, developers to create optimized queries.
Ø Work with Data modeling to visualize database structure.
Ø Knowledge of Data Aggregation, Data Granularity, Data Archiving, Data purging.
Ø Knowledge and usage of Azure platform, Azure Database/DW and its data migration methodologies.
Ø Prior experience with Power BI is required. Having experience in other BI software Tableau, Qlik, Sisense, etc. will be a plus.
Ø Must be flexible with working hours, independent and self- motivated, Punctual, Regular, and consistent attendance.
Ø Excellent interpersonal and communication skills in English.
Ø Business requirement analysis (for example: To include Program Planning Tool data, Call Center data, etc.).
Ø Transforming business requirements into technical requirements.
Ø Transforming technical requirements into DW/Datamart model for supporting. Data Flow, Source/Destination Data Models, how end-system consumes the data.
Ø Development of complex T-SQL and U-SQL to support business data needs.
Ø Monitoring & maintenance of the overall solution.
Ø Design new data model for data warehouse and develop ETL accordingly.
Ø Development of new Power BI reports & dashboards.
Ø Modify existing Power BI dashboards/reports if needed.
Ø Change/Refactor existing ETL if required.
Ø Troubleshooting and fixing of issues.
Ø Performance Optimization if required.
Ø Strong Communication skills to have an onshore meeting with global teams.
B.Sc./M.Sc in Computer Science or Software Engineering from any reputed university/Equivalent combination of education and experience may be considered.
Attractive Salary for deserving candidates, Medical Coverage, Salary review twice in a year, Weekly two holidays, Provident fund, Two festival bonus, Quarterly bonus, Performance Bonus, WPPF.
Vacation, Sick, and paid leaves
Eat & Drink
Lunch, Snacks, Tea, Coffee facility
Team Dinners, Monthly Lunch Mixers, Celebration of the traditional cultural festival, Annual day event, Team Outing,
participating every year in ISCT20 & Futsal tournament
4 Mohakhali, 4th Floor, Bir Uttam Ak Khandaker Rd,
Mohakhali (Amtoli) C/A, Dhaka-1212.