Business Intelligence Architect

Vultr

9d • $125,000 - $135,000 • Remote

About The Position

Vultr is seeking a highly skilled and experienced Business Intelligence (BI) Architect to design, develop, and maintain business intelligence solutions using Power BI. The ideal candidate is an expert in common data stores such as MySQL, BigQuery, Clickhouse, with proven experience maintaining, managing and manipulating systems and data for presentation to meet business needs in PowerBI. This is a highly visible role in a high-growth technology company, which will require interaction with executive team members across multiple functions. This is your opportunity to join our fast growing team and leave your mark on Constant and the future of Cloud Infrastructure.

Requirements

• 5+ years of hands-on development experience with Microsoft Business Intelligence stack / Power BI and BigQuery
• At least 3 years experience building business, accounting, and Finance-focused visualizations and user interfaces
• Background building ETL pipelines
• Demonstrates proficiency in the development and administration at least one of the following areas: Back-end data integration and architecture including dimensional data modeling, database design, data warehousing, ETL development, and performance tuning
• Demonstrates proficiency in the development and administration at least one of the following areas: Front-end reporting and analytics platforms including OLAP cube design, tabular data modeling, Performance Point, Power Pivot, Power View, Power BI Report and Dashboard development
• Extremely strong SQL skills
• Experience with Several DB Ops tools
• Foundational knowledge of the following areas: Metadata management
• Foundational knowledge of the following areas: Master Data Management
• Foundational knowledge of the following areas: Data Governance
• Foundational knowledge of the following areas: Data Analytics
• Foundational knowledge of the following areas: Security and compliance minded workflows
• Demonstrated track record of prioritizing, multitasking, and managing multiple projects/assignments simultaneously in a fast-paced environment with tight deadlines
• Strong analytical skill set and ability to translate business processes and data into insights and solutions
• Strong problem solving, critical thinking skills and a high attention to detail a must.
• Strong organizational, interpersonal and communication skills, as well as the ability to work proactively, both individually and as a team.
• Ability to thrive in a fast-paced, dynamic, client-facing role where delivering solid work products to exceed high expectations is a measure of success

Responsibilities

• Own, and architect, and build internal datasets for business intelligence reporting
• Manage existing infrastructure such as ingestion of data from MySql database to Big Query, Curation of semantic layer between raw source data and Power BI,, internal CRM database, Power Query (M Language), Salesforce, etc.
• Build automated, accurate reporting dashboards
• Designing, developing, and maintaining business intelligence solutions using Power BI
• Manage consumption and access of Power BI reporting across the company
• Manage and improve existing data models and relationships
• Create DAX based calculations and resolve issues
• Resolve any issues related to loops and hierarchy
• Create and review models and KPIs
• Create and review visualizations
• Mature BI model to allow for users to build their own reports (self service)
• Work cross-functionally to improve business intelligence architecture and reporting
• Troubleshoot and resolve issues related to performance, environments, monitoring and operability of Power BI reports.
• Build and manage relationships with key stakeholders across business and IT organizations.
• Implement enterprise grade best practices in data ingestion, semantic layer, and reporting layer

Benefits

• 100% company-paid insurance premiums for employee medical, dental and vision plans.
• 401(k) plan that matches 100% up to 4%, with immediate vesting
• Professional Development Reimbursement of $2,500 each year
• 11 Holidays + Paid Time Off Accrual + Rollover Plan
• Increased PTO at 3 year and 10 year anniversary + 1 month paid sabbatical every 5 years + Anniversary Bonus each year
• $500 stipend for remote office setup in first year + $400 each following year
• Internet reimbursement up to $75 per month
• Gym membership reimbursement up to $50 per month
• Company paid Wellable subscription

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed