Data Engineer/BI Developer

Description

Summary: Avanceon is seeking a Data Engineer / BI Developer with strong SQL and Tableau expertise to design, develop, and optimize data solutions and support business decision-making. Highlights: 1. Develop and maintain complex SQL queries, views, and stored procedures. 2. Design and optimize databases, reporting schemas, and data models. 3. Design and develop Tableau dashboards, reports, and KPI monitoring solutions. 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.