Power BI / Data Analyst

VC5 Consulting

Houston, TX, United States

about 2 months ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Working hours

Regular working hours

Job source

dice.com

Tech stack

Big Data Databases Data Governance Extract Transform Load (ETL) Data Structures Data Warehousing Relational Databases Dimensional Modeling PostgreSQL Microsoft Dynamics Microsoft SQL Server Netsuite

+6 more

Oracle (Applications) Power BI SQL Databases Freeform SQL Database Performance Data Lakes

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.