Data Engineer/BI Developer

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, and Engineering teams to deliver analytics solutions

Requirements

• Bachelor’s degree in Computer Science, Software Engineering, Information Systems, or a related field
• 5+ years of experience in SQL Development, Data Engineering, or Business Intelligence
• Strong expertise in Microsoft SQL Server, including stored procedures and query optimization
• Hands-on experience with ETL development and data integration
• Proven experience with Tableau dashboard and report development
• Experience working in Agile/Scrum environments

Preferred Qualifications

• Experience with Oracle databases
• Proficiency with SSIS or similar ETL tools
• Experience using GitHub and JIRA

About the Company

Avanceon provides advanced automation and control solutions, helping businesses optimize their operations through cutting-edge technology and data-driven insights.