bi architect (tableau & power bi)

Role overview

The bi architect is responsible for designing, developing, and implementing scalable and efficient business intelligence (bi) solutions using tools like power bi, tableau, and modern data platforms. This role involves working closely with stakeholders to understand business needs and translating them into actionable data insights and visualizations.

Key responsibilities

·         Core bi architecture & development

·         Design and implement end-to-end bi solutions using tableau and power bi.

·         Develop semantic models, dashboards, and reports to support business decision-making.

·         Create and maintain data models, etl pipelines, and data warehouses.

·         Optimize performance of bi solutions and ensure data accuracy and consistency.

·         Ai & advanced analytics (for senior roles)

·         Integrate ai/ml features such as power bi copilot, smart narratives, automl, and natural language querying.

·         Build predictive dashboards and anomaly detection models.

·         Leverage microsoft fabric components like onelake, lakehouse, and data factory gen2 1.

·         Collaboration & governance

·         Work with cross-functional teams (finance, sales, and operations) to gather requirements.

·         Implement data governance, security, and compliance frameworks.

·         Mentor junior bi developers and analysts. 

Technical skills:

·         Power bi: semantic models, dax, paginated reports, q&a visual.

·         Tableau: desktop, server, cloud, lod expressions.

·         Strong Sql skills and experience with relational databases (sql server, postgresql, oracle).

·         Experience with etl tools (e.g., talend, informatica) and data modeling (star/snowflake schemas).

·         Familiarity with cloud platforms (azure, aws, google bigquery).

·         Bonus: python or r for data manipulation and ai/ml integration.

Soft skills:

·         Strong analytical and problem-solving abilities.

·         Excellent communication and stakeholder management.

·         Leadership and mentoring capabilities (for senior roles).

Preferred experience:

·         10+ years in bi, data analytics, or data architecture roles.

·         Proven track record of delivering enterprise-grade bi solutions.

·         Experience with devops for bi (e.g., git, alm toolkit, tabular editor).

·         Certifications in power bi, tableau, or microsoft fabric are a plus 1 2 3.