Position Summary :
Bentley Systems is growing rapidly in cloud. Cloud Finance team requires a business analyst with experience in SQL / M / DAX and Azure ecosystem to improve upon existing reporting and help with new reporting requirements.
We are looking for a creative and dedicated individual who will fit with our collaborative culture.
Position will :
Perform various data analytics in SQL and Power BI using industry accepted tools
Responsible for developing and executing tools to monitor and report on data quality
Support initiatives for data integrity and normalization
Consolidate, clean and analyze data from large disparate data sets, queries, and reports present in operational and financial systems.
Work with various internal teams to add context to data
Maintain strict confidentiality and discretion
Essential Skills :
MS / BS degree in Computer Sciences / Engineering
Proficient with SQL Server Management Studio (SSMS)
Proficient with T-SQL including stored procedures, views, functions, query optimization
2 years of experience in ETL Technologies
Preferred Technical Skills :
At least 2 years of experience in report modelling
Basic Knowledge of R
Experience with Azure REST APIs and Azure Resource Graph (Kusto) is a plus
Proficient with M / DAX, PowerBI Desktop and service
Experience in Azure Cloud technologies e.g. Azure Data Factory, Azure Function, Azure SQL DW, Spark, Databricks