BI Data Analyst: Power BI & SQL Insights Leader

ImpetusIT; New York (NY); On-site; USD 55,000 - 75,000; Full time

Job summary

ImpetusIT is seeking a BI Analyst for a trading software company in New York. You will design and maintain BI dashboards, model and cleanse data, and write complex SQL queries to support accurate reporting.

The role requires strong analytical skills, experience with Power BI/Tableau, and collaboration with data engineers to improve data accessibility. Proficiency in Python or R for automation is a plus.

Qualifications

• Design, develop BI dashboards for reporting and insights
• Perform data modeling, cleansing, and transformation for accuracy
• Write complex SQL queries for data extraction and performance tuning
• Collaborate with data engineers to improve data infrastructure
• Monitor KPIs and provide actionable insights

Responsibilities

• Design, develop, and maintain BI dashboards using Power BI, Tableau.
• Perform advanced data modeling, cleansing, and transformation for accurate reporting
• Write complex SQL queries for data extraction and performance tuning
• Collaborate with data engineers to enhance data infrastructure and improve accessibility
• Monitor KPIs and provide actionable insights
• Automate reporting processes using Python, R, or other scripting tools
• Strong experience with BI tools (Power BI, Tableau, QlikView, or similar)
• Proficiency in SQL for data querying and manipulation
• Experience with Snowflake, Databricks, Azure/AWS
• Understanding of Python or R for data analytics and automation
• Excellent analytical, problem-solving, and communication skills

Skills

SQL

Analytical skills

Communication

Problem solving

Automation scripting

Tools

Power BI

Tableau

QlikView

Snowflake

Databricks

Azure

AWS

Job description

ImpetusIT is seeking a BI Analyst for a trading software company in New York. You will design and maintain BI dashboards, model and cleanse data, and write complex SQL queries to support accurate reporting.

The role requires strong analytical skills, experience with Power BI/Tableau, and collaboration with data engineers to improve data accessibility. Proficiency in Python or R for automation is a plus.