Data Analyst 2

4 weeks ago


Southfield Michigan, United States Epsilon Full time
Job Description

Summary:

The Analytic Consulting Group partners with both internal and external clients, and data providers, leveraging various analytics to drive strategic thought and effective decision making. The Data Analyst 2 is responsible for conducting data analyses using SQL and other tools in support of a variety of analytic solutions.

Roles & Responsibilities:

Collaborate with internal/external stakeholders to manage data logistics – including data specifications, transfers, structures, and rules

Access and extract data from a variety of sources of all sizes (including client marketing databases) via Python, Excel, SQL, etc.

Master and perform all steps required to create analysis-ready data sets; including data integration/merging (SAS data step), variable preparation, and quality control (QA/QC)

Develop and execute SQL (or related) programs with detailed direction and supervision

Provide problem solving and data analysis, derived from programming experience

Demonstrate proficiency with desktop and UNIX toolsets (SAS, SAS ODS, SQL, MS Office) to create pivot tables and/or report content such as tables, reports, graphs, etc. (some positions require proficiency in digital analytic tools including Google and/or Adobe Analytics and familiarity with digital data, in addition to or in lieu of SAS/SQL)

Document and articulate steps taken in an analysis to project managers

Answer questions about data sets and analyses

Follow all policies and procedures for programming, project documentation, and system management

Become familiar with…all offerings outlined in the Insider’s Guide to ACG

various statistical offerings and methods (CHAID, logistic/multiple regression, cluster analysis, factor analysis)

Epsilon data assets

the SAS macro library

Participate in the design, planning & execution of projects

Effectively manage time and resources in order to deliver on time / correctly on a limited number (1-4) of concurrent projects

Proactively communicate with supervisor regarding workload and the status of assignments

Prepare basic report content (Word, Excel, PowerPoint) in support of deliverables

Perform two tasks related to the role of Sr. Data Analyst during the year

Minimum Qualifications:

Bachelor’s degree in a quantitative discipline (e.g., Statistics, Economics, Mathematics, Marketing Analytics) or significant relevant coursework

1-2 years of experience in the marketing analytics field

Some positions require a minimum of 1 year of experience conducting digital analytics

Demonstrated proficiency in SQL programming; minimum 2 years of experience

Strong analytic thought process and ability to interpret findings

Acute attention to detail (QA/QC)

Working knowledge of MS Office; including PowerPoint, Word, Excel and Outlook

Ability to work on multiple assignments concurrently

Excellent verbal and written communication skills

Highly motivated and collaborative team player with strong interpersonal skills

Effective organization and time management skills

Desirable Qualifications: 

Advanced degree (Master’s/PhD) in Statistics, Economics or other quantitative discipline

Database marketing experience/knowledge

Ability to program in newer and emerging languages such as R and Python; working knowledge of Hadoop and other big data technologies


  • Data Analyst

    1 month ago


    Michigan City, United States Atechstar Full time

    Job DescriptionData Analyst Responsibilities Managing master data including creation updates and deletion. Managing users and user roles. Provide quality assurance of imported data working with quality assurance analysts if necessary. Commissioning and decommissioning of data sets. Processing confidential data and information according to guidelines....

  • Business Analyst

    4 weeks ago


    Auburn Hills, Michigan, United States iSoftTek Solutions Inc Full time

    Job Title: Business Analyst (Data Governance and Data Quality Management) Location: Auburn Hills, MI.  Must be local or relocation (out of pocket from day 1).  No exceptions.  HEAVY preference for locals in this group.  NO West Coast candidates (PST) will be considered Duration:  Long-term    Job Type: Contract – W2 Work Type: Hybrid/Onsite...


  • Southfield, United States UHY LLP Full time

    A great UHY client is seeking a Senior Financial Analyst to join their team. The ideal candidate will have budgeting/forecasting experience, consolidations experience (using Oracle or Hyperion preferred), and advanced Excel skills including modeling. The Senior Financial Analyst role is an onsite position. This is a client direct hire position. Senior...

  • Data Architect

    6 days ago


    Southfield, United States illumety Full time

    About illumetyillumety is a data platform and analytics firm based in MI. Our focus is on building solutions for our clients by understanding their unique digital transformation needs. We offer end-to-end solutions that provide the strategy, tools, and insights necessary for informed decision-making and the elevation of their business for employees,...

  • Data Architect

    6 days ago


    Southfield, United States illumety Full time

    About illumetyillumety is a data platform and analytics firm based in MI. Our focus is on building solutions for our clients by understanding their unique digital transformation needs. We offer end-to-end solutions that provide the strategy, tools, and insights necessary for informed decision-making and the elevation of their business for employees,...


  • Southfield, United States Tenneco Full time

    Responsible for collecting relevant demand data from Sales & Marketing (Mid to long term) Conduct monthly Demand Review Meetings between Planning and Commercial Team Analyze historical data to continuously improve forecast accuracy (Past sales, trend Supply Chain, Supply Chain Analyst, Planner, Analyst, Forecasting, Manufacturing, Transportation


  • Southfield, United States Attendant Care Companies Full time

    Job DescriptionJob DescriptionDescriptionSign on bonus available!We are seeking a highly motivated and skilled Board Certified Behavior Analyst (BCBA) to join our team. The BCBA will play a key role in developing and implementing individualized behavior intervention programs, conducting assessments, and providing ongoing support and training to our clients...


  • Southfield, United States UHY LLP Full time

    A great UHY client is seeking a Treasury & Risk Insurance Analyst to join their team. The ideal candidate will have at least 3 years of Treasury experience, a bachelors degree in a related field, and experience with insurance. The Treasury & Risk Insurance Analyst role is an onsite position. This is a client direct hire position. Treasury & Risk Insurance...

  • Tax Analyst

    3 weeks ago


    Southfield, United States Global Information Technology Full time

    Job DescriptionJob DescriptionJob Title: Tax AnalystJob Location: RemoteJob Type: Full TimeJob Requirements:Strong knowledge of accounting and tax principles.Oracle, Alteryx, and/or Vertex experience a plus.Proficient in Microsoft Office w/ advanced Excel skills.Tax examination experience required.Bachelor's degree in accounting or related field and a...

  • Tax Analyst

    3 weeks ago


    Southfield, United States Global Information Technology Full time

    Job DescriptionJob DescriptionJob Title: Tax AnalystJob Location: RemoteJob Type: Full TimeJob Requirements:Strong knowledge of accounting and tax principles.Oracle, Alteryx, and/or Vertex experience a plus.Proficient in Microsoft Office w/ advanced Excel skills.Tax examination experience required.Bachelor's degree in accounting or related field and a...

  • Data Analyst

    23 hours ago


    Michigan City, United States Atechstar Full time

    Job descriptionExperince 3-5 years of experience in data Quality and Analysis. Working knowledge on SQL skills. Expert in Excel. Team player - shares his/her job knowledge. High level communication and interpersonal skills. Thrives in a challenging fast paced environmen.Key Skills SQL. Structured Query Language. Statistical programming. Machine...

  • Data Scientist

    6 days ago


    Detroit, Michigan, United States Publicis Collective Full time

    Job Description Job Description Supports all phases of data analytics, (data extraction, analysis, manipulation, synthesis & interpretation, and summary) along with the development, validation, testing, and maintenance of analytic tools, models, and algorithms for client projects and operational initiatives identified by Publicis Collective. Enjoys...

  • Business Analyst 5

    3 weeks ago


    Southfield, United States Global Information Technology Full time

    Business Analyst 5Job Location: Lansing, MI (Hybrid)Job Type: ContractJob Description:Reviews, analyzes, and evaluates business systems and user needs.Triage user requests and tickets, assign priority and severity, and communicate effectively to all stakeholders.Maintain and prioritize CRM inbox communications.Formulates systems to parallel overall business...

  • Data Scientist

    4 weeks ago


    Dearborn, Michigan, United States McCulloh Consulting Full time

    Are you a Data Professional with Engineering experience and a desire to work in Data Science? Do you possess a strong background in providing data solutions with R or Python? Do you want to live in the Detroit area and find out what all the buzz is about!? If so, keep reading about this amazing opportunity. Responsibilities: Leverage advanced data...


  • Southfield, United States Tekwissen Full time

    Title: Sr. Health Care Analyst Work Location: Southfield, MI 48075 Duration: 12 Months Job Type: Contract Work Type: Remote Pay Rate: $50-50.00/hrENGAGEMENT DESCRIPTION: Responsible for planning, organizing, directing, implementation, and leading department assignments. Position operates within broad objectives to ensure optimum utilization of manpower and...

  • Business Analyst

    7 days ago


    Michigan Center, United States LanceSoft Full time

    Top Three Skills: 1. Lead healthcare payor JAD sessions using both waterfall & agile methodologies, manage requirements and be able to communicate clearly/effectively (5 years) 2. Perform high-level systems analysis work based on a defined set of requirements (5 years) 3. Analyze and document information and data required to achieve business goals (5 years)...

  • Business Analyst 5

    5 days ago


    Southfield, United States Global Information Technology Full time

    Business Analyst 5 Job Location: Lansing, MI (Hybrid) Job Type: ContractJob Description:Reviews, analyzes, and evaluates business systems and user needs. Triage user requests and tickets, assign priority and severity, and communicate effectively to all stakeholders. Maintain and prioritize CRM inbox communications. Formulates systems to parallel overall...

  • Business Analyst 5

    4 weeks ago


    Southfield, United States Global Information Technology Full time

    Job DescriptionJob DescriptionBusiness Analyst 5Job Location: Lansing, MI (Hybrid)Job Type: ContractJob Description:Reviews, analyzes, and evaluates business systems and user needs.Triage user requests and tickets, assign priority and severity, and communicate effectively to all stakeholders.Maintain and prioritize CRM inbox communications.Formulates systems...


  • Southfield, United States Clarience Technologies Full time

    Senior financial Analyst is responsible for financial planning, analysis, and reporting within the organization. This role involves collaborating with various departments to gather financial information, conducting financial analysis to identify trends, opportunities, and risks, and providing actionable insights to senior management to support...

  • Business Analyst 5

    11 hours ago


    Southfield, United States Global Information Technology Full time

    Job DescriptionJob DescriptionBusiness Analyst 5Job Location: Lansing, MI (Hybrid)Job Type: ContractJob Description:Reviews, analyzes, and evaluates business systems and user needs.Triage user requests and tickets, assign priority and severity, and communicate effectively to all stakeholders.Maintain and prioritize CRM inbox communications.Formulates systems...