Senior Business Intelligence Developer

· Understanding of PowerBI dashboards and how to configure those datasets to leverage SQL queries and views.

• Must have experience developing Power BI DAX expressions for reporting and data analysis

• Develop and support reporting and ETL solutions using SSRS, SSIS, and Power BI.

• Develop, maintain, and enhance Power BI dashboards, reports, and semantic datasets to support enterprise reporting and analytics.

• Develop Power BI DAX measures, calculated columns, and data models to deliver business intelligence solutions.

• Connect SQL Server data sources to Power BI using optimized SQL queries, stored procedures, and views.

• Experience developing or supporting ETL processes, data integration, and enterprise reporting solutions.

· Design, write, optimize, and maintain complex TSQL queries, stored procedures, views, and database scrips to support business applications and reporting needs.

· Manage and monitor the performance of TSQL databases, seeking improvements through performance and query tuning

· Create, manage, and continually improve TSQL Server maintenance plans through monitoring of queries, indexes, and TSQL statistics

· Create, manage, maintain, and improve backup, restore, and replication schedules driven by end user events and processes

· When required, manage and monitor the performance of cloud-based databases within AWS.

· Support the deployment of new databases and schema objects as needed in the on-premises and cloud environment.

· Monitor and maintain databases to ensure stability and optimal performance.

· Ensure that databases are secure and adhere to industry standards.

· Analyze and troubleshoot database issues and take necessary actions to resolve them.

· Generate reports to measure database performance, utilization, and growth.

· Plan and implement database activities including upgrades and patching.