BI Engineer

Job Summary:

BWE is a company focused on optimizing data reporting and insights. The BI Engineer role involves designing and developing dashboards and visualizations to enhance decision-making and performance analysis across teams.

Responsibilities:

• Design and develop reusable dashboards, scorecards, and visualizations to surface key metrics and performance indicators with focus on real-time data updates and interactive analytics.

• Design and maintain a centralized enterprise visualization dashboard and landing page, serving as the primary analytics hub for BWE.

• Partner with stakeholders to define business requirements and translate them into actionable insights while identifying opportunities for predictive analytics and automated reporting.

• Optimize data models and queries for performance and scalability ensuring efficient data processing and fast dashboard load times.

• Manage and improve BI platform configurations, access controls, and dataset refreshes with automated scheduling and exception monitoring.

• Ensure reporting consistency and standardization across teams and departments through reusable templates and governance frameworks.

• Support BWE’s community development initiative by servicing as an internal SME for distributed visualization developers across the enterprise, providing guidance on design and functionality, answering technical questions, delivering training, and encouraging user-led development.

• Contribute to BWE’s Intelligence Platform initiative by defining BI requirements, data visualization standards, and user experience specifications.

• Work with business partners to deliver a comprehensive suite of reusable BWE dashboards for top priorities with documented user guides and refresh schedules.

• Analyze current dashboard performance and implement specific improvements to load times, interactivity, or data accuracy with measurable results.

• Document and present at least three specific opportunities where automated insights, predictive analytics, or AI-enhanced reporting can significantly improve decision speed, reduce manual effort, or provide competitive advantage.

• Establish baseline metrics for dashboard usage, performance, and user satisfaction with monthly reporting and continuous improvement process.

• Research and recommend AI-powered BI tools for future implementation, including natural language processing for queries and automated insight generation, with cost-benefit analysis.

• Create standardized dashboard templates and governance guidelines that other team members can use for consistent reporting across the organization.

Qualifications:

Required:

• Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or related field, or equivalent practical experience.

• 3+ years of experience in business intelligence, data analysis, or data engineering roles.

• Proficiency in BI and visualization tools such as ThoughtSpot, Power BI, Tableau, or Looker; familiarity with cloud-native or AI-powered BI platforms.

• Strong SQL skills with experience in optimizing queries and building performant data models.

• Familiarity with data warehousing concepts, ETL/ELT pipelines, and relational database systems.

• Experience translating business requirements into effective dashboards, reports, and analytics solutions.

• Solid understanding of data governance, access controls, and maintaining reporting consistency across teams.

• Excellent communication and collaboration skills to work effectively with both technical and non-technical stakeholders.

Preferred:

• Master’s degree in Data Analytics, Computer Science, or related discipline.

• 5+ years of experience designing and maintaining enterprise BI solutions in a corporate environment.

• Hands-on experience with ThoughtSpot, including live boards, search-based analytics, and SpotIQ; advanced knowledge of Power BI (DAX, Power Query, dataflows), or equivalent advanced expertise in Tableau/Looker.

• Experience with cloud data platforms (e.g., Azure Synapse, Snowflake, BigQuery, or Redshift).

• Familiarity with predictive analytics, AI-powered BI, or natural language query tools.

• Experience working with APIs and connecting diverse data sources for integrated reporting.

• Strong knowledge of performance tuning for large datasets, real-time dashboards, and interactive reporting.

• Exposure to data governance frameworks and compliance standards (e.g., SOC 2, GDPR, ISO).

• Experience mentoring end users or delivering training programs for self-service analytics adoption.

Company:

BWE stands as a national, full-service commercial and multifamily mortgage banking company committed to elevating real estate financing. Founded in 2008, the company is headquartered in Cleveland, USA, with a team of 201-500 employees. The company is currently Growth Stage.