Senior Data Integration & BI Analyst

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

Job summary

Praise Tech Solutions is seeking an experienced SQL BI Developer to optimize T-SQL queries, design ETL processes with SSIS, and build Power BI dashboards. You will work on performance tuning, data integration, and reporting solutions across diverse data sources.

Location is Anywhere in USA with potential remote collaboration; the role involves deploying scalable data marts, reports, and dashboards while supporting clients with robust data solutions.

Qualifications

• Strong T-SQL skills with experience optimizing long running queries.
• Proficiency in designing and developing SSIS packages for data extraction and loading.
• Experience creating Power BI visualizations and dashboards.
• Knowledge of SQL Server environments and data warehousing concepts.
• Familiarity with ETL processes and data integration across sources.

Responsibilities

• Improve performance of queries by generating execution plans and tuning indexes.
• Design and develop SSIS packages to extract data from diverse sources and load to destinations.
• Work with SSIS tasks such as For Each, Merge, Pivot, and Unpivot in workflow.
• Implement transformations including slowly changing dimensions and lookups as required.
• Create connection managers, deploy/debug SSIS packages, and update data via temp tables and joins.
• Provide logging and error handling; design data marts and parameterized reports.
• Identify dimensions and fact tables; design data marts using star schema.
• Create Power BI visualizations and deploy reports to dashboards; model and mash data from multiple sources.

Skills

T-SQL

SSIS

Power BI

SQL Server

ETL

Tools

SSRS

Job description

Praise Tech Solutions is seeking an experienced SQL BI Developer to optimize T-SQL queries, design ETL processes with SSIS, and build Power BI dashboards. You will work on performance tuning, data integration, and reporting solutions across diverse data sources.

Location is Anywhere in USA with potential remote collaboration; the role involves deploying scalable data marts, reports, and dashboards while supporting clients with robust data solutions.