• Develop and maintain datasets, data models, and data visualizations to support business decisions • Develop different data warehouse designs like star schema, snowflake schema, and dimensional modeling • Identify data sources, definitions, and timelines appropriate for analysis • Write, optimize and maintain complex SQL queries to support data analysis and reporting needs • Develop and generate ad hoc reports based on stakeholder requirements to support decision making processes in various departments • Work with Fabric to connect to various data sources such as databases, cloud storage, or APIs • Integrate data warehouse with business intelligence tools to create reports and dashboards • Design and build interactive reports using Power BI to present findings and identify trends to stakeholders • Ensure data quality and integrity by identifying and resolving data issues • Perform root cause analysis and uncover core issues using data, then assist the organization to improve • Analyze and interpret various sources of internal data and external data sources to support business decision-making • Design, build and maintain automated workflows using Power Automate to streamline business processes • Identify opportunities for process improvement and develop solutions to reduce manual effort.