.Business Intelligence AnalystJob Summary:We are seeking a detail-oriented and data-driven Business Intelligence Analyst to join our team. In this role, you will be responsible for analyzing complex data, generating insightful reports, and supporting decision-making processes across the organization. You will work closely with various departments to identify business needs, develop analytical solutions, and drive strategic initiatives that enhance business performance.Key Responsibilities:Develop, implement, and maintain BI solutions using tools such as Tableau, Power BI, and Snowflake, ensuring the delivery of accurate and timely business insights.Design and manage complex SQL queries, stored procedures, and functions to support diverse business needs, ensuring optimal performance and data integrity.Perform data extraction, transformation, and loading (ETL) processes, integrating data from various sources into data warehouses, including Snowflake, for comprehensive reporting.Collaborate with cross-functional teams to gather business requirements, translating them into effective data models, reports, and dashboards that drive decision-making.Ensure the integrity, accuracy, and consistency of data by implementing best practices in relational database design, optimization, and data validation.Utilize APIs and scripting languages to automate data processes, streamline workflows, and enhance data manipulation capabilities.Provide advanced data analysis to identify trends, opportunities, and areas for improvement.Work with Microsoft Power Apps, Dataverse, and Microsoft Power Automate to support and enhance business process automation and data management.Continuously monitor and evaluate BI solutions, making improvements to meet evolving business needs and ensure the highest level of data quality.Support and train team members and stakeholders on the use of BI tools, fostering a data-driven culture within the organization.Qualifications:Bachelor's degree in Software Engineering, Data Science, Computer Science, or a related field.Demonstrated experience as a Business Intelligence Analyst or in a similar analytical role, with the ability to handle large datasets and conduct complex data analyses.Proficiency in BI tools such as Tableau and Power BI.Strong SQL skills, with experience in data querying, manipulation, and management.Expertise in writing complex queries, stored procedures, and functions tailored to various business requirements.Solid understanding of relational database design and optimization.Familiarity with APIs and scripting for efficient data manipulation and transfer.Hands-on experience with ETL processes and data warehousing.Experience working with cloud-based data platforms such as Snowflake.Experience working with Microsoft Power Apps, Dataverse, and Microsoft Power Automate.Proficiency in programming languages such as Python.Exceptional analytical and problem-solving skills
