BI Developer

Job Description

designing, building, and maintaining data pipelines using SQL Server technologies to extract, transform, and load data into a data warehouse, then utilizing Power BI to create interactive dashboards and visualizations for business insights, requiring strong proficiency in T-SQL, data modeling, ETL processes, and Power BI functionalities.

key Requirements

·       2 years experience in similar position

·       SQL Server – Advanced, PowerBI – Advanced, SSMS – Intermediate, SSIS – Intermediate

·       language English-Intermediate

Responsibilities:

·       Develop and implement ETL processes using SSIS packages to extract data from various sources (databases, flat files, APIs) and transform it into a format suitable for analysis in the data warehouse.

·       Write complex T-SQL queries to manipulate and clean data, ensuring data quality and consistency.

·       Create dimensional data models in SQL Server to optimize data analysis and reporting within Power BI.

·       Develop interactive Power BI dashboards and reports using DAX calculations to visualize key performance indicators (KPIs).

·       Manage data security and access controls within Power BI

·       Define data standards and documentation to ensure consistency across the organization.

·       Work closely with business stakeholders to understand data requirements and translate them into technical specifications.

·       Collaborate with data analysts and other data engineers to ensure seamless data flow and analysis.

Requirements and skills:

·       Expert knowledge of T-SQL and SQL Server database administration

·       Proficiency in SSIS package development for ETL processes

·       Advanced Power BI skills including data modeling, DAX calculations, and visualization design

·       Understanding of data warehousing concepts and dimensional modeling

·       Strong analytical and problem-solving abilities

·       Excellent communication and collaboration skills to work with diverse stakeholders

·       Ability to translate business requirements into technical solutions