Power BI / Data Analyst

VC5 Consulting
Houston, United States of America
24 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Houston, United States of America

Tech stack

Big Data
Databases
Data Governance
ETL
Data Structures
Data Warehousing
Relational Databases
Dimensional Modeling
PostgreSQL
Microsoft Dynamics
Microsoft SQL Server
Netsuite
Oracle Applications
Power BI
SQL Databases
Freeform SQL
Database Performance
Data Lake

Job description

This role is focused on bridging the gap between an organization''s core ERP system and its Power BI reporting environment. The individual will be responsible for transforming large datasets from the ERP into clean, automated, and actionable dashboards that will guide business leadership. Collaboration with various teams will be essential to ensure that the data structures are optimized for performance and that reports load quickly, without impacting the ERP system''s production performance., * Design and implement robust ETL pipelines to extract and load data from the ERP system into Power BI.

  • Develop complex Power BI data models that support interactive visualizations and reporting for business stakeholders.
  • Optimize database performance to ensure reports load instantly, enhancing the user experience for business leadership.
  • Troubleshoot slow-running reports by rewriting SQL views and optimizing Power BI models for efficiency.
  • Collaborate with cross-functional teams to understand data requirements and ensure data governance and security., Join a critical initiative to enhance data governance and security within the organization while leveraging advanced Power BI tools to create impactful dashboards. This position offers a unique opportunity to design and implement robust ETL pipelines that will directly influence business decision-making.

Requirements

  • Strong background acting as a Database Administrator (DBA) or Data Engineer with experience in Relational Database Management Systems (RDBMS) such as Microsoft SQL Server, Oracle, or PostgreSQL.
  • Highly proficient in writing advanced SQL queries, with a proven ability to optimize for performance.
  • Experience navigating and understanding complex database schemas of enterprise ERP systems like NetSuite or Microsoft Dynamics.
  • Deep hands-on experience in building Power BI data models and managing workspaces to create interactive reports.
  • Solid understanding of data warehouse concepts, including dimensional modeling and data lake architectures.

Apply for this position