BI Data Analyst

Tech Inc

New York, United States of America

3 days ago

Role details

Contract type

Temporary to permanent

Employment type

Full-time (> 32 hours)

Working hours

Regular working hours

Languages

English

Experience level

Junior

Compensation

$ 198K

Job location

Remote

New York, United States of America

Tech stack

Query Performance

Data analysis

Big Data

Data Mining

Python

NumPy

Performance Tuning

Power BI

SQL Stored Procedures

PL-SQL

SQL Databases

Freeform SQL

Sql Optimization

Analytic Functions

Powerquery

Pandas

Job description

Design, write, and optimize complex SQL queries to extract, transform, and analyze data from multiple sources

Develop and maintain Power BI dashboards and reports, ensuring data accuracy, performance, and business relevance
Use Python for data cleaning, transformation, automation, and advanced analytics
Strong hands on experience with SQL (joins, CTEs, subqueries, performance optimization)
Strong hands on experience with Advanced SQL, including:

Window functions (ROW_NUMBER, RANK, LAG/LEAD)
CTEs and recursive queries
Query performance tuning and optimization
Advanced aggregations and conditional logic

Roles & Responsibilities

Design, write, and optimize advanced SQL queries involving:
Complex joins
Common Table Expressions (CTEs)
Window/analytic functions
Subqueries and correlated subqueries
Perform data analysis on large, complex datasets to identify trends, patterns, and anomalies
Optimize query performance using indexes, execution plans, and query refactoring
Develop and maintain SQL based data models, views, and stored procedures
Support data extraction and transformation for reporting and analytics use cases

Requirements

Role Descriptions: We are seeking a highly skilled Data Analyst with strong expertise in SQL| Python| and Power BI to analyze complex datasets| build insightful dashboards| and support data-driven decision-making. The ideal candidate will work closely with business and technical stakeholders to transform raw data into meaningful insights- Strong proficiency in SQL (joins| subqueries| CTEs| window functions| performance tuning) - Strong hands-on experience with Python (Pandas| NumPy| data analysis libraries) - Extensive experience with Power BI (DAX| Power Query| data modeling| dashboard creation) - Strong analytical and problem-solving skills Essential Skills: We are seeking a highly skilled Data Analyst with strong expertise in SQL| Python| and Power BI to analyze complex datasets| build insightful dashboards| and support data-driven decision-making. The ideal candidate will work closely with business and technical stakeholders to transform raw data into meaningful insights- Strong proficiency in SQL (joins| subqueries| CTEs| window functions| performance tuning) - Strong hands-on experience with Python (Pandas| NumPy| data analysis libraries) - Extensive experience with Power BI (DAX| Power Query| data modeling| dashboard creation) - Strong analytical and problem-solving skills Desirable Skills: Keyword: Skills: Digital : Python~Digital : Microsoft Power BI~PL/SQL Experience Required: 8-10

Benefits & conditions

$95.00 per hour Join a dynamic network of Business Intelligence Analysts where you can connect with leading AI labs and companies seeking your expertise. This opportunity allows you to engage in f…
2 days ago, Power BI Data Analyst - Contract | Fully Remote Pay: $75/hr.- $100/hr., DOE Hours: Full-time, 40 hours/week, M-F, 8am-5pm Duration: 9-12 months We are seeking a Contract Power…
11 days ago