Apply

Business Intelligence Architect

Posted 10 days agoViewed

View full description

💎 Seniority level: Senior, 5+ years

💸 Salary: 110000.0 - 125000.0 USD per year

🏢 Company: Vultr👥 101-250💰 Angel over 11 years agoWeb HostingCloud ComputingCloud StorageCloud Infrastructure

🗣️ Languages: English

⏳ Experience: 5+ years

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 tuningFront-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 managementMaster Data ManagementData GovernanceData 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.
Apply

Related Jobs

Apply

📍 LATAM

🧭 Full-Time

🔍 Telecommunications

  • 10+ years of experience in ETL/ELT design and development, integrating data from heterogeneous OLTP systems and API solutions, and building scalable data warehouse solutions to support business intelligence and analytics.
  • Demonstrated experience in utilizing python for data engineering tasks, including transformation, advanced data manipulation, and large-scale data processing.
  • Experience in data analysis, root cause analysis and proven problem solving and analytical thinking capabilities.
  • Experience designing complex data pipelines extracting data from RDBMS, JSON, API and Flat file sources.
  • Demonstrated expertise in SQL and PLSQL programming, with advanced mastery in Business Intelligence and data warehouse methodologies, along with hands-on experience in one or more relational database systems and cloud-based database services such as Oracle, MySQL, Amazon RDS, Snowflake, Amazon Redshift, etc.
  • Proven ability to analyze and optimize poorly performing queries and ETL/ELT mappings, providing actionable recommendations for performance tuning.
  • Understanding of software engineering principles and skills working on Unix/Linux/Windows Operating systems, and experience with Agile methodologies.
  • Proficiency in version control systems, with experience in managing code repositories, branching, merging, and collaborating within a distributed development environment.
  • Excellent English communication skills.
  • Interest in business operations and comprehensive understanding of how robust BI systems drive corporate profitability by enabling data-driven decision-making and strategic insights.
  • Develop, document, and test ELT/ETL solutions using industry standard tools (Snowflake, Denodo Data Virtualization, Looker).
  • Recommend process improvements to increase efficiency and reliability in ELT/ETL development.
  • Extract data from multiple sources, integrate disparate data into a common data model, and integrate data into a target database, application, or file using efficient ELT/ ETL processes.
  • Collaborate with Quality Assurance resources to debug ELT/ETL development and ensure the timely delivery of products.
  • Should be willing to explore and learn new technologies and concepts to provide the right kind of solution.
  • Target and result oriented with strong end user focus.
  • Effective oral and written communication skills with BI team and user community.

SQLBusiness IntelligenceData AnalysisETLSnowflakeData engineeringRESTful APIsData visualizationData modelingData management

Posted 3 months ago
Apply

Related Articles

Posted about 1 month ago

How to Overcome Burnout While Working Remotely: Practical Strategies for Recovery

Burnout is a silent epidemic among remote workers. The blurred lines between work and home life, coupled with the pressure to always be “on,” can leave even the most dedicated professionals feeling drained. But burnout doesn’t have to define your remote work experience. With the right strategies, you can recover, recharge, and prevent future episodes. Here’s how.



Posted 6 days ago

Top 10 Skills to Become a Successful Remote Worker by 2025

Remote work is here to stay, and by 2025, the competition for remote jobs will be tougher than ever. To stand out, you need more than just basic skills. Employers want people who can adapt, communicate well, and stay productive without constant supervision. Here’s a simple guide to the top 10 skills that will make you a top candidate for remote jobs in the near future.

Posted 9 months ago

Google is gearing up to expand its remote job listings, promising more opportunities across various departments and regions. Find out how this move can benefit job seekers and impact the market.

Posted 10 months ago

Read about the recent updates in remote work policies by major companies, the latest tools enhancing remote work productivity, and predictive statistics for remote work in 2024.

Posted 10 months ago

In-depth analysis of the tech layoffs in 2024, covering the reasons behind the layoffs, comparisons to previous years, immediate impacts, statistics, and the influence on the remote job market. Discover how startups and large tech companies are adapting, and learn strategies for navigating the new dynamics of the remote job market.