About
Location: Lewisville , TX
Job Type: Fulltime
If you are interested, please share your updated resume
Job Description
Must Have Technical/Functional Skills
-
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
Languages
- English
Notice for Users
This job comes from a TieTalent partner platform. Click "Apply Now" to submit your application directly on their site.