The data analytics field is booming as businesses rely on real‑time insights to stay competitive. Companies are hunting for analysts who can blend SQL mastery with modern BI tools and automation. This contract role offers a chance to showcase end‑to‑end data solutions while working locally in Lewisville.

Job Summary

We are seeking a skilled Data Analyst to design, write, and optimize complex SQL queries, build and maintain Power BI dashboards, and leverage Python for data cleaning, transformation, and advanced analytics. The candidate will ensure data accuracy, performance, and relevance across multiple data sources, delivering actionable insights for business stakeholders.

Top 3 Critical Skills Table

Interview Preparation

1. Explain how you would write a recursive CTE to calculate hierarchical data.
   What the interviewer is looking for: Understanding of recursion, proper use of CTE syntax, and performance considerations.
2. Describe a scenario where you optimized a slow query using window functions.
   What the interviewer is looking for: Ability to replace sub‑queries or self‑joins with window functions to improve efficiency.
3. Walk me through the steps you take to build a Power BI dashboard from raw data.
   What the interviewer is looking for: End‑to‑end process knowledge – data sourcing, modeling, DAX measures, visual design, and performance testing.
4. How do you handle data cleaning in Python for a large CSV file that contains missing and malformed entries?
   What the interviewer is looking for: Proficiency with pandas, handling nulls, data type casting, and scalable techniques (e.g., chunking).
5. What techniques do you use for query performance tuning in SQL Server?
   What the interviewer is looking for: Index strategy, execution plan analysis, statistics updates, and query rewrite tactics.

Resume Optimization

• SQL
• Advanced SQL
• CTEs
• Window Functions
• Query Performance Tuning
• Power BI
• Dashboard Development
• Python
• Data Cleaning
• Data Transformation

Application Strategy

When emailing the recruiter, start with a friendly greeting, attach your updated resume, and clearly reference the role. Make sure to mention related skills you possess, such as Advanced SQL, Power BI dashboard creation, and Python automation. Highlight any projects where you built end‑to‑end data pipelines or optimized complex queries, and map those achievements directly to the responsibilities listed in the job description.

Career Roadmap