Business Intelligence Analyst

Praise Tech Solutions; Northern (KY); Hybrid; USD 75,000 - 105,000; Full time

Job summary

Praise Tech Solutions in the United States seeks a Business Intelligence professional to maintain dashboards, build ETL pipelines, and support data warehousing initiatives. You will work with stakeholder requirements to ensure performance, accuracy, and timely insights.

The role involves creating SQL views in SSMS for Power BI reports, applying incremental loads, and developing Power BI Dataflows to standardize shared dimensions across projects.

Qualifications

• Experience building and maintaining Power BI dashboards and reports.
• Strong SQL skills with the ability to create views and perform data transformations.
• Experience with ETL processes and data modelling for data warehouses.
• Familiarity with SSMS and Azure SQL for data storage and retrieval.

Responsibilities

• Maintain business-critical dashboards ensuring high performance and accuracy.
• Build routine ETL logic to integrate data from multiple systems (DayForce, UKG, NetSuite).
• Create SQL views in SSMS for Power BI reports based on requirements.
• Apply incremental data loads to improve refresh performance on large datasets.
• Develop and manage Power BI Dataflows for shared Dimension tables.

Skills

Power BI

SQL

ETL

Data modelling

SSMS

Azure SQL

Data warehousing

Incremental loads

Tools

DayForce

UKG

NetSuite

Job description

• Maintain business-critical dashboards, ensuring high performance, accuracy, andalignment with stakeholder requirements.
• Build routine ETL logic to integrate data from multiple systems, including DayForce,UKG, and NetSuite, ensuring data quality and consistency.
• Use Azure SQL to create simple tables and follow instructions for introductory star-schema modelling for the data warehouse.
• Perform day-to-day tasks for the Business Intelligence function, including basicreporting, analytics, data modelling, and dashboard updates.
• Create SQL views in SSMS for Power BI reports based on clear requirements toenable clean and efficient data retrieval.
• Follow detailed steps to implement incremental data loads for large datasets to helpimprove refresh performance.
• Develop and manage Power BI Dataflows for shared Dimension tables by applyingstandard procedures.
• Apply basic SQL transformations as directed to improve dashboard load times andend-user experience.
• Update data models and SQL tables to accommodate new business fields andrequirements based on provided instructions.

Location: Anywhere in USA