Sorry, this listing is no longer accepting applications. Don’t worry, we have more awesome opportunities and internships for you.

Consultant- Data Analyst

Sia

Consultant- Data Analyst

Charlotte, NC +1 location
Full Time
Paid
  • Responsibilities

    Job Description

    We are looking to meet talented candidates with at least two years of client-facing experience in information management and business analytics using data to provide meaningful, actionable insights. These insights can help inform the most impactful customer product offers, marketing campaign strategies, servicing optimization, and/or manufacturing and production improvements.

    Key Responsibilities:

    • Data Extraction and Transformation: * Extract data from various sources, including internal databases, data warehouses, ETL Tools and third-party platforms * Clean, transform, and prepare data for analysis, ensuring data quality and consistency. This includes handling missing values, outliers, and inconsistencies. * Develop and maintain ETL (Extract, Transform, Load) processes to automate data workflows. * Develop and maintain post-ETL validation tests
    • Data Analysis and Modeling:
      • Perform exploratory data analysis (“EDA”) to identify trends, patterns, and anomalies.
      • Develop and apply statistical methods to analyze data and draw meaningful conclusions - regression analysis, hypothesis testing, etc.
      • Build and maintain dashboards and reports to track key performance indicators (KPIs) and business metrics.
      • Use data visualization techniques to effectively communicate insights.
      • Develop predictive models or forecasting models as needed.
      • Experience with tools like Tableau or Power BI
    • Data Governance, Security, and Best Practices:
      • Adhere to data governance and security policies and procedures to ensure data security and privacy.
      • Maintain data documentation and contribute to the development of data dictionaries and metadata repositories.
      • Stay up to date with industry best practices and emerging trends in data analysis.
      • Understand and comply with GDPR/CCPA and data privacy, retention, and confidentiality policies.
    • Communication and Collaboration: * Present findings and recommendations to stakeholders at all levels of the organization, including senior management. * Translate complex technical concepts into clear and concise language for non-technical audiences. * Collaborate effectively with cross-functional teams – product managers, engineers, marketing managers – to understand business needs and provide data-driven solutions. * Mentor and guide more junior analysts, providing technical expertise and support.
  • Qualifications

    Qualifications

    Education : Master's degree in a quantitative field such as Statistics, Mathematics, Economics, Computer Science, Data Science, or a related area.

    Experience : 2+ years of experience in a data analysis role, with a proven track record of delivering actionable insights, and/ or consulting experience.

    Technical Skills:

    • Proficiency in SQL is essential.
    • Familiarity with current data platforms:
    • Databases: SQL Server, Oracle, PostgreSQL, DB2, or MySQL
    • Data warehouses: Snowflake, Data Bricks, Redshift, or BigQuery
    • APIs and Datasets: MS Dynamics, Oracle CRM, or Salesforce
    • ETL Tools: dbt, Airflow, StreamSets, NIFI, or Kafka or similar
    • Cloud Platforms: Azure, AWS, GCP, Oracle, or IBM
    • Source Control: Git or GitHub/Gitlab compatible platforms
    • Machine Learning Models: Regression, Decision Trees, Neural Nets, or similar
    • Basic understanding of statistical concepts such as hypothesis testing and probability (Bayesian) preferred
    • Strong experience with data visualization tools like Tableau, Power BI, or Looker.
    • Experience with programming languages such as Python or R for data analysis. Libraries like Pandas, NumPy, scikit-learn.
    • Familiarity with statistical software packages like SPSS, or SAS is a plus.
    • Experience with data warehousing concepts and technologies.

    Analytical Skills:

    • Strong analytical and problem-solving skills.
    • Ability to think critically and draw meaningful conclusions from data.
    • Solid understanding of statistical concepts and methods.

    Communication Skills:

    • Excellent written and verbal communication skills.
    • Ability to present complex information clearly and persuasively.
    • Proven ability to be a great teammate.

    Industry sector experiences:

    • Strong preference for experience in financial services including banking, brokerage, insurance, and capital markets

    Alignment with Sia’s Core Values:

    Excellence, Entrepreneurship, Innovation, Teamwork, Care & Support, Employee Well-Being

    Additional Information

    **Compensation & Benefits **

    We believe in supporting our team professionally and personally. Here’s a snapshot of the comprehensive benefits you’ll enjoy as part of Sia.

    Competitive Compensation

    • Annual base salary between $79,000-$97,000, commensurate with experience and qualifications
    • Annual performance based discretionary bonus

    Robust Health Coverage

    • 3 Medical plans
    • Dental and Vision
    • Life, AD&D and other voluntary insurance

    Tax-Advantaged Accounts

    • 401K retirement plan
    • 4% matching and 100% vested upon enrollment
    • Health Savings Account (HSA)
    • Flexible Spending Account (FSA)
    • Health, Dependent Care, Commuter

    Family Friendly Benefits

    • 100% paid parental leave for all new parents with eligible tenure
    • Building Healthy Families program if enrolled through Medical plan
    • Time Off to Recharge
    • Generous Paid Time Off (PTO) policy
    • 9 company holidays plus 1 floating holiday

    Extras that Make Life Easier

    • College savings and student loan repayment assistance
    • Monthly cell phone stipend
    • Access to wellness programs at no cost if enrolled through Medical plan, including:
    • Gym membership reimbursement
    • LiveHealth Online virtual care
    • Personalized support from a Well-being Coach
    • Employee Assistance Program at no cost
    • Free confidential counseling and emotional support services
    • On-demand access to Emotional Well-being resources (ranging from relaxation techniques to stress management)

    Diversity, Equity, Inclusion & Belonging

    At Sia, we believe in fostering a diverse, equitable and inclusive culture where our employees and partners are valued and thrive in a sense of belonging. We are committed to recruiting and developing a diverse network of employees and investing in their growth by providing unique opportunities for professional and cultural immersion. Our commitment toward inclusion motivates dynamic collaboration with our clients, building trust by creating an inclusive environment of curiosity and learning which affects lasting impact. Please visit our website for more information.

    Sia is an equal opportunity employer. All aspects of employment, including hiring, promotion, remuneration, or discipline, are based solely on performance, competence, conduct, or business needs.

    Office Workplace Guidelines

    Sia is committed to providing a flexible workplace environment that supports client, business, and market needs. Consultants located in our primary market office locations—New York City, Charlotte, Seattle, and San Francisco—are expected to live within a reasonable commuting distance and attend the office at least three days per week. For Consultants outside of our primary markets, we can offer more flexible in-person requirements in accordance with your location.

    **Work Authorization & Sponsorship **

    At this time, Sia does not intend to pursue employment with applicants who will require now or in the future visa by our company for work authorization in the United States (i.e., H1-B visa, F-1 visa (OPT), TN visa, or any other non-immigrant status).

    Sia is an equal opportunity employer. All aspects of employment, including hiring, promotion, remuneration, or discipline, are based solely on performance, competence, conduct, or business needs.

  • Locations
    Charlotte, NC • New York, NY