BI Solutions Architect Lead Engineer

We are looking for a highly experienced BI Solutions Architect Lead Engineer who can design, develop, and optimize enterprise business intelligence and analytics solutions. This role requires a strong understanding of data modeling, BI platforms, data integration, cloud environments, and modern analytics frameworks. The ideal candidate will collaborate with business leaders, technical teams, and data professionals to deliver scalable BI architectures that support strategic decision-making.

• Lead the design and development of enterprise BI and analytics architecture.

• Create scalable data models, semantic layers, and multi-layered BI frameworks.

• Define architectural standards, best practices, and roadmap for BI solutions.

• Evaluate and select BI tools, technologies, and platforms.

• Oversee development of dashboards, visualizations, reporting solutions, and data models.

• Build and optimize ETL/ELT pipelines supporting the BI ecosystem.

• Implement data governance, metadata management, and data quality frameworks.

• Ensure BI solutions meet performance, availability, and security requirements.

• Partner with business teams to translate requirements into BI solutions.

• Work with data engineering, analytics, cloud, and application teams for end-to-end delivery.

• Lead technical discussions, design reviews, and solution workshops.

• Mentor BI developers, data engineers, and analysts.

• Provide technical direction for BI projects and cross-functional initiatives.

• Prepare documentation, architectural diagrams, and development standards.

• Architect BI solutions on cloud platforms (AWS, Azure, or GCP).

• Leverage modern BI architectures such as data lakes, lakehouses, and real-time analytics.

• Integrate machine learning or predictive analytics where applicable.

• 12+ years of experience in BI architecture, data engineering, and analytics delivery.

• Expertise in BI platforms such as Power BI, Tableau, Qlik, Looker, or similar.

• Strong experience with SQL, data modeling, dimensional modeling, and star/snowflake schemas.

• Hands-on experience building ETL/ELT solutions using tools like Informatica, Talend, SSIS, Data Factory, or similar.

• Proficiency in cloud ecosystems (Azure, AWS, or GCP) and cloud-native BI services.

• Strong understanding of data warehousing, OLAP, semantic models, and query optimization.

• Experience working with modern data platforms such as Snowflake, Databricks, Redshift, BigQuery, or Synapse.

• Excellent communication and collaboration skills.

• Ability to lead technical teams and manage multiple workstreams.

• Strong problem-solving, analytical thinking, and decision-making skills.

• Ability to work in a fast-paced environment with minimal supervision.

• Experience with real-time analytics and streaming technologies.

• Knowledge of Python, Spark, or other analytics-related programming tools.

• Experience implementing BI governance and enterprise-wide standards.

• Consulting or enterprise-scale project experience.