Avanceon is looking for a skilled Data Engineer / BI Developer with strong expertise in SQL Development, ETL Processes and Tableau Reporting to join our growing team.
The ideal candidate should have a strong database background and hands-on experience in developing reporting solutions, integrating data from multiple systems, and building interactive dashboards that support business and operational decision-making.
Key Responsibilities
- Develop and maintain complex SQL queries, views, stored procedures, functions, and database jobs.
- Design and optimize databases, reporting schemas, and data models.
- Develop ETL processes for extracting, transforming, and loading data from multiple sources.
- Design and develop Tableau dashboards, reports, and KPI monitoring solutions.
- Create efficient Tableau data sources, calculations, filters, and drill-down reports.
- Perform query tuning, performance optimization, and data validation.
- Collaborate with Business Analysts, Developers, GIS Specialists, SCADA Engineers, and Customer Teams to deliver reporting and analytics solutions.
- Support data analysis, troubleshooting, and reporting enhancements.
Required Skills
- Bachelor’s degree in computer science, Software Engineering, Information Systems, or related field.
- 5+ years of experience in SQL Development, Data Engineering, Business Intelligence, or Reporting Solutions.
- Strong expertise in:
- Microsoft SQL Server
- SQL Queries
- Stored Procedures
- Views
- Functions
- Query Optimization
- Database Design & Data Modeling
- Hands-on experience with ETL development and data integration.
- Experience with Tableau Dashboard and Report Development.
- Strong analytical and problem-solving skills.
- Experience working in Agile/Scrum environments.
Preferred Skills
- Experience with MSSQL and Oracle databases.
- Experience with SSIS or similar ETL tools.
- Familiarity with Tableau.
- Experience GitHub, JIRA.
Skills Required
- Bachelor's degree in Computer Science, Software Engineering, Information Systems, or related field.
- 5+ years of experience in SQL Development, Data Engineering, Business Intelligence, or Reporting Solutions.
- Microsoft SQL Server / MSSQL experience.
- Proficiency writing complex SQL queries.
- Experience developing stored procedures, views, and functions.
- Query tuning and performance optimization experience.
- Database design and data modeling skills.
- Hands-on ETL development and data integration experience.
- Tableau dashboard and report development experience.
- Experience working in Agile/Scrum environments.
- Strong analytical and problem-solving skills.
- Experience with Oracle databases.
- Experience with SSIS or similar ETL tools.
- Experience with GitHub.
- Experience with JIRA.
What We Do
Avanceon is the leading provider of automation, control systems integration, proprietary energy management solutions and support services. It has a strong market footprint through its offices in Dubai - UAE (covering Middle East), Lahore - Pakistan (covering South Asia) and Exton, Pennsylvania - United States of America (covering North America). Avanceon is also among the select group of ‘certified members’ of Control System Integrators Association (‘CSIA’) and is also listed on the Control Engineering Magazine’s System Integrator Hall of Fame.Avanceon has been in the automation business for the last 24 years and has transformed into a 360 degree solution provider for automation, energy management, service and maintenance. Servicing clients over a span of two decades, Avanceon has completed several projects for major blue chip companies enabling it to earn strong credentials, move up the learning curve and develop a diverse client base. Going forward, it intends to capitalize on its core strengths to expand its footprint in the Middle East by setting up offices in Qatar, Kingdom of Saudi Arabia (KSA) and Oman.
.png)
