Design, develop and support Power BI reports and dashboards.
Create/write SQL queries, complex joins, stored procedures, views, indexes and other database objects to process, prepare and extract data from various data sources like SQL Server, Snowflake Data Warehouse, SSAS.
Test and validate reports, dashboards and database objects for data accuracy/consistency and visuals.
Analyze existing SQL queries for performance improvements.
Create, maintain and monitor various jobs using Azure SQL Server, Data Factories and other technologies to support reporting needs.
Communicate with clients and stakeholders.
Gather and document requirements for reports, dashboards and ad-hoc needs.
Knowledge & Experience:
7+ years of experience with Microsoft Power BI stack.
Utilize appropriate data analytics and statistical tools and techniques to analyze a verity of data and data sources.
Strong analytic skills with the ability to collect, organize, analyze and disseminate significant amounts of information with attention to detail and accuracy is required.
Extensive experience with Microsoft Power BI stack on Azure platform with related tools - Azure Analysis Services/SSAS, DAX and M queries, SSRS, SSIS, Excel, Power Pivot and Azure Data Factory.
Experience with use of DevOps and Git Version Control or other source control tools.
Experience with aviation industry is a plus.
Knowledge of Databricks, Snowflake (Data Warehouse and Analytics) and/or Dell Boomi is a plus.
Bachelor's degree in Computer Science, Information Systems or related university degree or work equivalent required.