Business Intelligence Analyst

Job Title: Business Intelligence Analyst Job DescriptionWe are seeking a skilled Data Analyst to join our team and contribute to the development of business intelligence solutions. Required Skills and QualificationsTo be successful in this role, you will need to have a strong foundation in data analysis, with expertise in tools such as Power BI, Power Query, and DAX. Additionally, you should have excellent problem-solving skills, attention to detail, and the ability to communicate complex technical concepts to non-technical stakeholders. BenefitsThis is an exciting opportunity for a motivated and talented individual to take their career to the next level. You will have the chance to work on a wide range of projects, collaborate with a dynamic team, and develop your skills in a fast-paced environment. OthersDevelop dashboards from scratch using Power BI, incorporating data visualization best practices.Use Power Query for data transformation and shaping, ensuring data accuracy and consistency.Build well-structured analytics-ready data models using star schema design principles.Write advanced DAX formulas for KPIs, time-intelligence, and business logic, optimizing performance and accuracy.Configure row-level security (RLS), scheduled refresh, incremental refresh, and parameters in Power BI.Optimize dashboards for performance and accuracy, leveraging expertise in data modeling and visualization.Write clean, optimized queries combining multiple datasets, applying knowledge of SQL and data manipulation techniques.Build logic for de-duplication, grouping, time-based metrics, trend analysis, and other advanced analytics tasks.Perform date/time conversions, timestamp harmonization, and business-rule logic, ensuring data integrity and consistency.Clean and prepare backend datasets for Power BI, utilizing expertise in data processing and transformation.Work with operational data stored in Google Sheets, developing proficiency in sheet management and data ingestion.Apply advanced formulas in Google Sheets, including QUERY, FILTER, ARRAYFORMULA, REGEX, and others.Structure sheets for efficient ingestion into Power BI, adhering to best practices in data organization.Automate repetitive steps using Apps Script or willingness to learn quickly, enhancing productivity and efficiency.Build helper/staging sheets for data cleaning and QA, streamlining workflows and improving data quality.Integrate external systems through REST APIs (JSON, tokens, pagination), leveraging expertise in API design and implementation.Utilize automation tools like Make.com / Pipedream / Apps Script to streamline data ingestion, reducing manual effort and increasing data freshness.Normalize unstructured SaaS data into clean analytics tables, applying knowledge of data warehousing and ETL processes.Troubleshoot data flow breaks and ensure continuity of pipelines, demonstrating expertise in data debugging and issue resolution.Clean messy, real-world datasets, removing duplicates, mismatches, and missing fields, and documenting key findings.Design clear transformation logic from raw data to final model, ensuring data accuracy and consistency throughout the process.Document data definitions, modeling rules, and key assumptions, maintaining transparency and accountability throughout the project lifecycle.Provide quality checks to ensure stable reporting, guaranteeing accurate and timely insights to stakeholders. About UsWe are a cutting-edge organization dedicated to innovation and excellence. We offer a collaborative and dynamic work environment, where creativity and talent thrive. If you are passionate about data analysis and driven to make a difference, we invite you to join our team.