The #1 Site for IT and Engineering Jobs - search all IT and Engineering  jobs.
Mly6vp5zysyckqzdl9j

Senior Technical Business Analyst

Job Description

Senior Technical Business Analyst

The Intersect Group is seeking a Senior Technical Business Analyst for our client in Irving, Texas. The Senior Technical Business Analyst should be experienced in data management, data analysis, data extraction.


Responsibilities

  • Perform 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 and Power BI for effective prediction and understanding of data analysis trends and creating automated data analysis workflows using Alteryx designer
  • Support 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
  • Utilize Excel advance techniques like Pivot Table, V-Lookup H-Lookup for mining data and perform analysis on various sources and summarizing data
  • Implement statistical algorithms such as Linear, Logistic Regression, Clustering for segmentations and Time series model (ARIMA)
  • Factor analysis for building correlation, prediction and visualization of the model
  • Perform A/B testing, target vs, control analysis and profiling, market basket analysis to identify trends and analyze customer purchase behavior
  • Work on Waterfall as well as Agile environment, including the Scrum process
  • Utilize the knowledge of quantitative analytics, data mining, statistics and data visualization to present insights to the senior management to facilitate in strategic decision making
  • Work on various reporting objects like Dimensions, Measures, Filters, Calculated Fields, transformations, parameters, conditional formatting, DAX queries, Interactions, etc. in Power BI
  • Perform Dimensional Data Modeling, Process Modeling for Data Warehouse /Data Mart design
  • Identify Facts and Dimensions, the creation of cubes, Star Schema, and Snowflake Schema
  • Perform 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
  • Perform descriptive, diagnostic, inferential, prescriptive, and predictive analysis of data
  • Extensively work on the creation of customer segmentation, profiling and defining customer purchase patterns using existing customer demographic/transactional data
  • Create engagement tracking dashboards and funnel reports for the mobile app to assist the Product development team through Mix-panel and New Relic
  • Communicate insights from data analysis, influence change, generate insights and recommendations and present these to the senior management
  • Perform descriptive, diagnostic, inferential, prescriptive, and predictive analysis of data
  • Extensively work on the creation of customer segmentation, profiling, and defining customer purchase patterns using existing customer demographical/transactional data
  • Verify various offers/promotions set by the business teams with pre/post transactional data
  • Extract data from various sources (Oracle, Databricks, MongoDB) using DB queries
  • Design and implement dashboards based on transformed data

Requirements

  • The Senior Technical Business Analyst will be strong in SAS, SQ and SPSS
  • Strong Analytics Background with good exposure to model development and reporting tools (Tableau, PowerBI)
  • Strong in Advance-Excel, preferably VBA
  • Strong in basic Accounting and Finance
  • 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)

Interested candidates please send resume in Word format to Please reference job code 74707 when responding to this ad.


The Intersect Group provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics. In addition to federal law requirements, The Intersect Group complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities.

Job Requirements

 

Job Snapshot

Location US-TX-Irving
Employment Type Full-Time
Pay Type Hour
Pay Rate N/A
Store Type IT & Technical
Apply

Company Overview

The Intersect Group

At The Intersect Group, our talent is creating results. We live to help our community by connecting top talent with leading companies that need their help. Candidates and clients trust us to deliver results based on our deep expertise and proven resources within finance, accounting, and information technology. We’re a multiple ‘Best Places to Work’ award winner, have had stellar growth and 80% of Glassdoor ratings say they would recommend us to a friend! Learn More

Contact Information

US-TX-Irving
Snapshot
The Intersect Group
Company:
US-TX-Irving
Location:
Full-Time
Employment Type:
Hour
Pay Type:
N/A
Pay Rate:
IT & Technical
Store Type:

Job Description

Senior Technical Business Analyst

The Intersect Group is seeking a Senior Technical Business Analyst for our client in Irving, Texas. The Senior Technical Business Analyst should be experienced in data management, data analysis, data extraction.


Responsibilities

  • Perform 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 and Power BI for effective prediction and understanding of data analysis trends and creating automated data analysis workflows using Alteryx designer
  • Support 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
  • Utilize Excel advance techniques like Pivot Table, V-Lookup H-Lookup for mining data and perform analysis on various sources and summarizing data
  • Implement statistical algorithms such as Linear, Logistic Regression, Clustering for segmentations and Time series model (ARIMA)
  • Factor analysis for building correlation, prediction and visualization of the model
  • Perform A/B testing, target vs, control analysis and profiling, market basket analysis to identify trends and analyze customer purchase behavior
  • Work on Waterfall as well as Agile environment, including the Scrum process
  • Utilize the knowledge of quantitative analytics, data mining, statistics and data visualization to present insights to the senior management to facilitate in strategic decision making
  • Work on various reporting objects like Dimensions, Measures, Filters, Calculated Fields, transformations, parameters, conditional formatting, DAX queries, Interactions, etc. in Power BI
  • Perform Dimensional Data Modeling, Process Modeling for Data Warehouse /Data Mart design
  • Identify Facts and Dimensions, the creation of cubes, Star Schema, and Snowflake Schema
  • Perform 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
  • Perform descriptive, diagnostic, inferential, prescriptive, and predictive analysis of data
  • Extensively work on the creation of customer segmentation, profiling and defining customer purchase patterns using existing customer demographic/transactional data
  • Create engagement tracking dashboards and funnel reports for the mobile app to assist the Product development team through Mix-panel and New Relic
  • Communicate insights from data analysis, influence change, generate insights and recommendations and present these to the senior management
  • Perform descriptive, diagnostic, inferential, prescriptive, and predictive analysis of data
  • Extensively work on the creation of customer segmentation, profiling, and defining customer purchase patterns using existing customer demographical/transactional data
  • Verify various offers/promotions set by the business teams with pre/post transactional data
  • Extract data from various sources (Oracle, Databricks, MongoDB) using DB queries
  • Design and implement dashboards based on transformed data

Requirements

  • The Senior Technical Business Analyst will be strong in SAS, SQ and SPSS
  • Strong Analytics Background with good exposure to model development and reporting tools (Tableau, PowerBI)
  • Strong in Advance-Excel, preferably VBA
  • Strong in basic Accounting and Finance
  • 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)

Interested candidates please send resume in Word format to Please reference job code 74707 when responding to this ad.


The Intersect Group provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics. In addition to federal law requirements, The Intersect Group complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities.

Job Requirements

 
Sologig Advice

For your privacy and protection, when applying to a job online: Never give your social security number to a prospective employer, provide credit card or bank account information, or perform any sort of monetary transaction.Learn More

By applying to a job using sologig.com you are agreeing to comply with and be subject to the workinretail.com Terms and Conditions for use of our website. To use our website, you must agree with theTerms & Conditionsand both meet and comply with their provisions.
Senior Technical Business Analyst Apply now