Data Warehouse Developer and Analyst

The Role:

Job Responsibilities

Data Analysis & SQL Development

• Write complex SQL queries to extract, manipulate, and analyze data from multiple databases
• Develop and maintain stored procedures, views, and functions
• Perform data validation, cleansing, and quality assurance
• Optimize SQL queries for performance and efficiency
• Create automated data extraction processes and ETL workflows
• Collaborate with database administrators to ensure data integrity

Power BI Report Development

• Design and develop interactive dashboards and reports using Power BI Desktop
• Create and maintain Power BI datasets and data models
• Implement DAX calculations for advanced analytics
• Publish reports to Power BI Service and manage workspace permissions
• Schedule automated data refreshes and monitor report performance
<...