BI Developer

About the Opportunity:

EMCO Corporation is seeking a skilled and passionate Business Intelligence (BI) Developer to join our team and help us transform data into actionable insights. You will participate in designing, developing, and maintaining BI solutions that empower informed decision-making across the organization, while also ensuring optimal performance and security of our BI database environments. The ideal candidate will be able to leverage their strong technical skills to enhance business decision making capabilities with tailored BI & analytics solutions.

Key Responsibilities:

• Data Acquisition and Integration

• Develop & maintain data pipelines
• Extract, transform, and load (ETL) data from various sources
• Monitor and optimize end-to-end data flow for efficiency & performance

• Data Modeling and Storage

• Design & implement dimensional BI data models
• Configure & manage BI databases
• Apply best practices for indexing, partitioning, and other techniques to optimize BI database performance

• BI DB Maintenance, Performance Tuning and Troubleshooting

• Observe and troubleshoot data-related issues within the BI environment
• Monitor database performance and implement performance tuning strategies, including index optimization, query optimization, and scaling adjustments

• BI Development and Reporting

• Partner with stakeholders to understand business requirements and transform them into the required data warehouse architecture
• Maintain & develop interactive dashboards, reports and other analytics assets using BI and analytical tools such as Python, Power BI and Birst

Effectively communicate complex data analysis findings to both technical and non-technical audiences

Requirements

Qualifications:

• Completion of University Degree in Computer Science, Information Technology, or a related field

• 3+ years of experience as a BI Developer or similar role and 2+ years of experience with database administration tasks

• Experience with BI data warehousing concepts, data modelling principles and a solid understanding of ETL processes & tools

• Strong proficiency in SQL and relational databases

• Intermediate knowledge of programming languages, such as python or R, for data integration and custom analytics solutions

• Experience with Azure data platform services (Azure SQL Database, Azure Postgres DB, Azure Data Factory, etc.)

• Excellent analytical and problem-solving skills

• Strong organizational skills with the ability to multi-task in a fast-paced, dynamic environment

• Strong communication and interpersonal skills

Bonus points for:

• Knowledge of data mining and machine learning techniques

• Experience with general programming languages like Java or C#

• Proven track record of delivering successful BI projects on the Azure platform

• Experience with BI data visualization tools (Birst, Power BI, Tableau, etc.)