Location: Irving, TX
Term: 12 months
Day-to-Day Responsibilities:
-
Performing data cleaning, data modeling, data crunching and in-depth data analysis using SQL
-
Develop visuals, interactive reports using Power BI for effective business communication and understanding.
-
Analyze mobile app data to understand user engagement and retention.
-
Knowledge of Mix panel will be helpful.
-
Utilizing Excel advance techniques like Pivot Table, V-Lookup for analyzing data.
-
Supporting product teams through both ad-hoc requests and planned projects.
-
Analyzing customer’s data for new opportunities.
-
Providing customize reporting and recommendations in support to on-going business decisions.
-
Conducting quantitative analysis including but not limited to ROI, identification and assessment of opportunities and risk, forecasting & offer performance.
-
Performing A/B testing and test vs control analysis, market basket analysis to assist in right business decisions.
-
Extracting data from various sources (Oracle, Databricks, MongoDB) using DB queries, Designing, and implementing dashboards based on transformed data.
Is this a good fit? (Requirements):
-
Strong in SQL, Power BI, Data Analysis and Statistical concepts.
-
Strong Analytics Background with Mobile Applications using Mix panel or other tools.
-
Exposure to Python or R.
-
Strong in 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 Concepts: (Probability distributions, Confidence Intervals, Statistical Inference, Mean, Mode, Median, Hypothesis Tests).
-
Familiarity with statistical programming languages and packages (R, Python).
Even better if you have:
-
Knowledge of Machine Learning.