Position: Business Intelligence (BI) Developer
Company: Wiztech Group
Category: Data Engineer
Experience required: 2y
English level: upper
Published: 2023-06-01T00:00:00+03:00

Business Intelligence (BI) Developer with Airflow, DBT experience

We are seeking a highly skilled and experienced Business Intelligence (BI) Developer to join our team. The ideal candidate will have a strong background in designing, building, and maintaining BI solutions in a complex business environment, with specific experience using Apache Airflow and DBT (Data Build Tool). You will be responsible for developing and enhancing BI systems that help us to make data-driven decisions.

*Responsibilities:*

1. Architect, implement, and maintain BI solutions using Apache Airflow, DBT, and other related tools.
2. Design, build, and launch new data models in production.
3. Translate business needs into technical specifications.
4. Develop and update technical documentation.
5. Provide end-to-end technical support and issue resolution.
6. Develop data set processes for data modeling, mining, and production.
7. Employ a variety of languages and tools to integrate systems together.
8. Recommend ways to improve data reliability, efficiency, and quality.
9. Collaborate with data engineers to build data transformations and data pipelines.
10. Work with cross-functional teams, including Data Science, Engineering, Product, and Business teams.
11. Implement data structures using best practices in data modeling, ETL/ELT processes, SQL, and DBT.
12. Debugging, monitoring, and troubleshooting BI solutions.
13. Creating visualizations and reports for requested projects.

*Requirements:*

1. Bachelor’s or Master's degree in Computer Science, Information Systems, or related field.
2. Proven experience as a BI Developer or Data Scientist.
3. Industry experience is preferred in using BI tools such as Apache Airflow, DBT.
4. Strong knowledge of ETL (Extract, Transform, Load) frameworks.
5. In-depth understanding of database management systems, online analytical processing (OLAP), and ETL framework.
6. Knowledge of SQL queries, SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS).
7. Proficient in scripting languages (Python, etc.)
8. Demonstrated abilities in problem-solving and troubleshooting.
9. Excellent communication skills.
10. Knowledge of data warehouse design (e.g., dimensional modeling) and data mining.
11. Understanding of the full life cycle of data, from ingestion through to visualization.
12. Able to work in a fast-paced and sometimes high-pressure environment.

*Nice to have:*

1. Experience with cloud services (Google Cloud, AWS, Azure) and understanding of distributed data/computing tools: Map/Reduce, Hadoop, Hive, Spark, Gurobi, MySQL, etc.
2. Experience in the industry related to the business’s core activities.
3. Certifications in Apache Airflow, DBT, or similar technologies.

*Working Conditions:*

This job typically requires constant sitting, typing, and looking at a computer screen. Depending on the organization's policies, you may work in an office or remotely. Occasional travel may be required.