Data Analyst

This international industry leader has an immediate 6+ month contract opportunity in Spring, TX for a Data Analyst. This position requires working onsite Monday-Friday. Will be part of the Analytics team within the Budgeting, Planning & Scheduling Systems organization. Will be responsible for writing advanced SQL queries, performing data visualization/reporting, using Excel for Analysis, performing data cleaning/transformation, and more!

Contract Duration: 6+ Months

Required Skills & Experience

• 3-5 years experience with SQL (Structured Query Language) including:
• Writing advanced T-SQL queries (joins, subqueries, CTEs)
• Window functions, aggregations, and conditional logic
• Stored procedures, scalar/table-valued functions
• Query optimization and indexing
• 3-5 years experience with Data Visualization & Reporting including:
• Power BI (import and direct query modes)
• DAX for calculated columns, measures, and KPIs
• Designing interactive dashboards and visual reports
• 3-5 years experience with MS Excel for Analysis, including:
• Power Query to connect and transform data
• PivotTables, advanced formulas (XLOOKUP, INDEX/MATCH)
• Charts and dashboards for quick insights
• 3-5 years experience with Data Cleaning & Transformation including:
• Handling NULLs, duplicates, outliers, and inconsistent formats
• Using views, temp tables, and CTEs for structured transformations
• Applying business rules for data standardization
• Strong understanding of Basic Statistics & Analysis Techniques including:
• Descriptive statistics (mean, median, standard deviation, distribution)
• Correlation and trend analysis
• Time-based comparisons and grouping (e.g., YOY, MOM)

Desired Skills & Experience

• Prefer experience with Scripting / Automation including:
• Python for ad hoc analysis (Pandas, NumPy, Matplotlib)
• Automating reporting or data extraction pipelines

What You Will Be Doing

• Write advanced SQL queries
• Perform data visualization/reporting
• Use Excel for Analysis
• Perform data cleaning/transformation
  
  

Posted By: Scott Price