AlixPartners - Southfield, MI

posted 5 months ago

Full-time - Mid Level
Southfield, MI
Professional, Scientific, and Technical Services

About the position

At AlixPartners, we solve the most complex and critical challenges by moving quickly from analysis to action when it really matters; creating value that has a lasting impact on companies, their people, and the communities they serve. We prize diversity and inclusion, the intellectually curious, the inventive, and the forward-thinking. We invite you to influence the way we work and define the way we embrace tomorrow. By understanding, respecting, and honoring the needs of our employees, clients, and communities, AlixPartners actively promotes an inclusive environment. We strongly believe in the value that diversity brings to our experiences and are committed to the perpetual enhancements of initiatives, policies, and practices. We hold ourselves accountable by providing the space for authenticity, growth, and equity for everyone. In this role, you will have the chance to create ETL workflows, scripts, statistical models, and visualizations while taking responsibility for the design, build, test, execution, and support of the data migration, cleansing, wrangling, etc. The ideal candidate will have a detailed understanding of the underlying data and data structures of multiple systems to allow in-depth analysis of existing and potential data insights. You will work with financially secure, under-performing, and distressed companies across a variety of urgent, high-impact situations. Our elite professionals are recognized experts in their respective fields, bringing to bear their skills and experience to craft measurable, improved outcomes for our clients.

Responsibilities

  • Create ETL workflows, scripts, statistical models, and visualizations.
  • Design, build, test, execute, and support data migration, cleansing, and wrangling processes.
  • Select features and build classifiers using machine learning techniques.
  • Execute machine learning projects using state-of-the-art methods.
  • Extend company's data with third-party sources of information when needed.
  • Create automated anomaly detection systems and track their performance.
  • Collect data from various corporate databases, including SQL and no-SQL databases.
  • Parse data from poorly structured XML and invalid HTML documents.
  • Use regular expressions to extract information from unstructured text documents.
  • Automate repetitive tasks with scripts.
  • Build effective, reliable, and robust ETL processes for data ingestion flow.
  • Design database models and advanced dimensional schemas to ensure data quality and consistency standards.
  • Apply modeling approaches, business intelligence patterns, and data management techniques.
  • Demonstrate advanced SQL skills to work with extensive amounts of data at various aggregation levels.
  • Review and analyze legacy code/scripts to understand data processing logic and business rules.
  • Apply statistical learning languages to build predictive models.

Requirements

  • Detailed understanding of data and data structures of multiple systems.
  • Experience with common data science toolkits such as Python, PySpark, and R.
  • Excellent understanding of machine learning techniques and algorithms, such as k-NN, Naive Bayes, SVM, Decision Forests, etc.
  • Advanced SQL skills, including CTEs and window functions.
  • Ability to deal with missing data through multiple-imputation or advanced models.
  • Understanding of cloud architectures, with knowledge in Azure, AWS, or GCP.

Nice-to-haves

  • Experience with data manipulation and automation of tasks using scripts.
  • Familiarity with various SQL databases like Microsoft, Redshift, Teradata, Oracle, Netezza, etc.
  • Knowledge of business intelligence patterns and data management techniques.

Benefits

  • Health insurance coverage
  • 401k retirement savings plan
  • Flexible scheduling options
  • Professional development opportunities
  • Paid holidays and vacation time
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service