Business Intelligence Architect

Summary

Join Vultr as a Business Intelligence (BI) Architect to design, develop, and maintain business intelligence solutions using Power BI. You will own and architect internal datasets for reporting, manage existing infrastructure (MySQL, BigQuery, etc.), and build automated reporting dashboards. This highly visible role requires interaction with executive team members. The ideal candidate has 5+ years of experience with Microsoft BI stack/Power BI and BigQuery, including building ETL pipelines and visualizations. Strong SQL skills and experience with database operations tools are essential. Vultr offers excellent benefits, including 100% company-paid medical, dental, and vision premiums, a 401(k) match, professional development reimbursement, and generous paid time off.

Requirements

• 5+ years of hands-on development experience with Microsoft Business Intelligence stack / Power BI and BigQuery
• At least 3 years experience building business AND Accounting & 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
• 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 Several9s DB Ops tools
• Foundational knowledge of the following areas
• Metadata management
• Master Data Management
• Data Governance
• Data Analytics
• 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, architect, and build internal datasets for business intelligence reporting
• Manage existing infrastructure such as our Production MySQL cluster, internal CRM database, BigQuery, Power Query (M Language), Salesforce, etc
• Build automated, accurate reporting dashboards
• Designing, developing, and maintaining business intelligence solutions using Power BI
• Developing visual reports, dashboards, and KPI scorecards using Power BI desktop
• Create the data model and establish relationships
• Create the DAX based calculations and resolve issues
• Resolve any issues related to loops and hierarchy
• Create and review models and KPIs
• Create and review visualization
• Establish data level security and object level security
• Establish model used for self-service BI
• Work cross-functionally to improve business intelligence architecture and reporting
• Troubleshooting and resolving issues related to performance, environments, monitoring and operability of Power BI reports
• Build and manage relationships with key stakeholders across business and IT organizations

Benefits

• Excellent Medical Benefits w/ 100% company-paid premiums for employee only plan + 100% company-paid dental & vision premiums
• 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 + take your birthday off
• Commitment matters to Vultr! Increased PTO at 3 year & 10 year anniversary + 1 month paid sabbatical every 5 years + Anniversary Bonus each year
• $500 first year remote office setup + $400 each following year for new equipment
• Internet reimbursement up to $75 per month
• Gym membership reimbursement up to $50 per month
• Company-paid Wellable subscription