Senior BI Analyst
Summary
Senior BI Analyst at Algoworks who evaluates and selects enterprise BI platforms (Power BI, Tableau, Looker), then designs data models and semantic layers, builds dashboards and reports, validates data quality, and optimizes performance. Requires 4–6+ years in BI/analytics with strong SQL; remote nearshore role based in Ecuador or Colombia.
- Evaluate and compare BI platforms such as Power BI, Tableau, Looker, or similar enterprise BI tools.
- Assess BI platforms based on business requirements, usability, scalability, integration capabilities, and cost.
- Support proof-of-concepts and recommend suitable BI platforms based on defined requirements.
- Perform hands-on setup, configuration, and validation of selected BI tools.
- Conduct comparative assessments and document findings and recommendations.
- Design and build scalable data models and semantic layers.
- Develop dimensional models, measures, KPIs, and reusable reporting structures.
- Ensure data models support reporting, analytics, performance, and scalability requirements.
- Validate data accuracy, relationships, calculations, and business logic.
- Apply BI data modeling and semantic layer best practices.
- Build interactive dashboards, reports, and visualizations for business and operational users.
- Develop meaningful KPIs and reporting solutions based on business requirements.
- Connect BI platforms to databases, cloud data warehouses, APIs, and enterprise data sources.
- Troubleshoot data connectivity, reporting, and dashboard performance issues.
- Optimize dashboards and reports for usability, performance, and data accuracy.
- Partner with business stakeholders, data engineers, and architects to understand and translate reporting requirements.
- Convert business requirements into scalable BI solutions.
- Collaborate with technical teams on data availability, source systems, and integration requirements.
- Define BI standards and best practices for data modeling, dashboard design, performance, governance, and data accuracy.
- Support implementation activities from BI platform evaluation through production delivery.
- Perform data quality validation and reconciliation across BI reports and underlying data sources.
- Identify and troubleshoot data inconsistencies and reporting issues.
- Conduct BI performance analysis and implement optimization recommendations.
- Support testing of BI solutions, including functional, data, and performance validation.
- Ensure BI solutions meet defined business and technical requirements.
- 4–6+ years of experience in BI, analytics, or reporting.
- Strong hands-on dashboard development and data modeling experience.
- Strong hands-on experience with Power BI, Tableau, Looker, or comparable enterprise BI platforms.
- Strong SQL skills with experience working with cloud data warehouses and enterprise data sources.
- Experience with semantic modeling and dimensional modeling.
- Strong understanding of KPIs, measures, and dashboard development.
- Experience evaluating BI tools and supporting tool selection, setup, and implementation.
- Experience working with business and technical stakeholders.
- Strong understanding of BI reporting, data validation, and performance optimization.
- Power BI, Tableau, Looker, or similar BI platforms.
- Strong SQL.
- Data Modeling.
- Semantic Modeling.
- Dimensional Modeling.
- Dashboard Development.
- Reporting & Analytics.
- KPI and Measures Development.
- BI Tool Evaluation and Selection.
- Data Validation.
- Performance Optimization.
- Business and Technical Stakeholder Management.
- Snowflake or other cloud data warehouses.
- Power BI DAX.
- Power Query.
- Advanced Tableau calculations and modeling.
- dbt.
- Modern data transformation tools.
- Azure, AWS, or GCP.
- Experience conducting BI tool proof-of-concepts.
- Comparative BI platform assessments.
- Data quality validation.
- BI performance tuning.
- Strong analytical and problem-solving skills with a hands-on approach.
- High attention to detail with a strong focus on data accuracy and usability.
- Effective communicator who can translate business requirements into practical BI solutions.
- Strong stakeholder collaboration and relationship-building skills.
- Comfortable working in a fast-paced, distributed environment with evolving priorities.
- Strong ownership mindset and ability to independently drive BI evaluation and implementation activities.
- Proactive approach to identifying opportunities for BI improvement and optimization.
- Strong focus on delivering scalable, reliable, and user-friendly BI solutions.