Back to Job Search

Business Data Analyst

  • Location: Irving, 75063
  • Job Type:Contract

Posted about 1 month ago

Our client is seeking a Business Analyst strong in SQL, Alteryx, SAS, Power BI, +  Statistics for a 6+ month contract located in Irving, TX.
 

Required:

  • At-least 5-7 years of experience in Analytics (hands on)
  • Experience in business requirements gathering
  • Experienced in data management, data analysis, data extraction
  • Strong in SQL, Alteryx, SAS, Power BI, Statistics
  • Strong Analytics Background with good exposure to model development, reporting tools (Tableau, PowerBI)
  • Strong in Advance-Excel, preferably VBA
  • Patterned and Trend Analysis
  • Experience in Alteryx, Python/R
  • SQL, Spark SQL, Oracle, Microsoft Azure Databricks
  • Excel (pivots, VLOOKUP’s, basic formulae), Power Point (charts, graphs)
  • Analytics concepts: Test and Control methodology (Sales data analysis, Loyalty Program Analytics, Customer segmentation, Descriptive analysis, Cohort Analysis, Offers/Promotions data trend analysis (coupons, bonus offers, rewards, member offers)
  • Statistical Techniques (Probability distributions, Confidence Intervals, Statistical Inference, Average, Median, Time Series, Pre and Post data analysis)


KEY RESPONSIBILITES AND DUTIES

  • Performing data cleaning, data modeling, data crunching and in-depth data analysis on KPI’s and optimization of subroutine analytics of communications and data mining methodologies.
  • Develop visual, interactive reports using Tableau, Power BI for effective prediction and understanding of data analysis trends and creating automated data analysis workflows using Alteryx designer.
  • Supporting the Director of Business Planning Analytics through both ad-hoc and project work by analyzing sales data for new opportunities, providing customize reporting and recommendations in support to on-going business decisions and, conducting quantitative analysis including but not limited to ROI, trending, identification and assessment of opportunities and risk, forecasting, regressions, correlation, cannibalization and probability modeling.
  • Utilizing Excel advance techniques like Pivot Table, V-Lookup H-Lookup for mining data and performing analysis on various sources and summarizing data.
  • Implementing statistical algorithms such as Linear, Logistic Regression, and Clustering for segmentation's, Time series model (ARIMA), Factor analysis for building correlation, prediction and visualization of the model.
  • Performing A/B testing and target vs control analysis and profiling, market basket analysis to identify trends and analyze customer purchase behavior.
  • Working on Waterfall as well as Agile environment including the Scrum process.
  • Performing Dimensional Data Modeling, Process Modeling for Data Warehouse /Data Mart design, identifying Facts and Dimensions, the creation of cubes, Star Schema, and Snowflake Schema.
  • Performing exploratory data analysis and data investigation using Alteryx, SQL and Python.
  • Data management and analyses to enable customer support teams using Excel, Google Sheets, Tableau, Power BI and SQL
  • Performing descriptive, diagnostic, inferential, prescriptive, and predictive analysis of data.
  • Extensively working on the creation of customer segmentation, profiling and defining customer
  • purchase patterns using existing customer demographic/transactional data.
  • Performing A/B testing
  • Extracting data from various sources (Oracle, Databricks, MongoDB) using DB queries, Designing and implementing dashboards based on transformed data.

 

Candidates will be responsible for following the client's COVID-19 protocols. Please refer to your MATRIX representative for specifics.

About Us

At MATRIX, we expertly match talented professionals with job opportunities to elevate careers. Since 1983, we have placed thousands of professionals at innovative clients across every industry ranging from small startups to Fortune 50 companies. It’s why we’re consistently in the top 25 of all U.S. IT staffing firms and why our consultants rate us well above the industry average, earning us ClearlyRated's Best of Staffing awards year after year. People come to us for a job, and stay with us because of our top-notch consultant care.

MATRIX is and Equal Employment Opportunity employer and provides reasonable accommodations for qualified individuals.  Supporting medical or religious documentation will be required where applicable. If you are a qualified individual with a disability, you may request a reasonable accommodation under the American Disability Act (ADA) by emailing MATRIX_HR@MatrixRes.com. To ensure a quick response to your request, please use the words “Accommodation request” as the subject line of your email.