Data Engineer/BI Developer

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.