ALOIS Solutions is seeking a Data Engineering & Analytics Lead with expertise in IBM Db2 to drive enterprise data architecture and BI modernization initiatives. The role involves designing scalable data pipelines, optimizing analytical workloads, and leading offshore engineers while collaborating with client technology teams.
Responsibilities:
- Design scalable data architectures supporting enterprise analytics and reporting
- Develop optimized Db2 data models, analytical queries, and table functions
- Lead BI modernization initiatives and refactor legacy stored procedures
- Build and optimize data pipelines and transformation logic
- Integrate Db2 datasets with BI tools such as Tableau, Power BI, MicroStrategy, or Metabase
- Collaborate with client teams on architecture and technical planning
- Lead 4–5 offshore data engineers/analysts and ensure best engineering practices
Requirements:
- Strong experience with IBM Db2 (LUW / Server)
- Advanced SQL performance tuning and analytical queries
- Expertise in MQTs, window functions, complex joins
- Experience with stored procedures, UDFs, and table functions
- Experience designing data pipelines and transformation logic
- Experience integrating with BI platforms
- Experience modernizing legacy BI ecosystems
- Exposure to cloud data platforms
- Experience with AI/ML data preparation pipelines