Data Analyst

Data Analyst

Location: Lewisville, TX

Duration: Fulltime

Salary: $100,000-$115,000 /Year

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

Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.