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

Business Intelligence Engineer

Enterprise Solutions Inc

Business Intelligence Engineer

Irvine, CA
Full Time
Paid
  • Responsibilities

    Job Description

    Duties

    • Provide analytics support to all business units. This involves collaborating proactively with various business and technical units to identify business opportunities and designing innovative solutions to optimize processes and promote informed decision-making.
    • Apply scientific knowledge on data modeling, data analytics, predictive algorithms, and other data science principles to create concepts, develop prototypes, and generate insight from data
    • Prepare and integrate large and various types of data (structured/non-structured)
    • Implement machine learning models, data mining methods, and statistical analysis using Python.
    • Using optical character recognition (OCR) to retrieve specific data from "free text" fields within databases.
    • Create dashboards and visualizations of processed data to identify trends
    • Dump, clean, and research historical data to ensure accuracy and make sure it is easily accessible and works smoothly by writing complex queries to optimize the performance of Edwards big data ecosystem.
    • Leverage advanced visualization tools/packages to create powerful representations of results.
    • Effectively communicate findings to business partners and executives
    • Enable data-driven insights to be formulated into decisions and actions by telling a convincing story.
    • Working on challenging and research-based initiatives using advanced machine learning methods
    • Run ETL to create big data warehouses to be used for reporting.
    • Advanced level of SQL Experience, should be able to write Complex SQL queries, function, stored procedures and query optimization techniques.
    • Dashboarding/ Power BI (other tools equivalent of power BI).
    • Automating PowerPoint Generation.
    • Work autonomously in a fast-paced environment

    Skills

    MUST HAVE SKILLS

    Data Modelling/Data Warehousing Developing ETL pipelines Python (equivalents okay too) Text Parsing Proficiency in SQL Dashboarding/ Power BI (other tools equivalent of power BI, i.e. Tableau)

    Excellent communication skills - needs to be able to present updates to leadership team

    All Desired Skills:

    • Experience as a data engineer with strong coding ability with NOSQL/SQL DATABASE
    • Ability to construct queries to retrieve data from enterprise databases
    • Experience as a Business Intelligence with strong coding ability with PYTHON
    • Parsing text data using Python
    • Regular Expressions
    • Artificial Intelligence / Machine Learning
    • Familiarity with the Anaconda distribution of Python
    • Experience in MICROSOFT POWER BI DEVELOPMENT
    • Constructing data models from data loaded into Power BI from various data sources
    • Creating relationships between queries loaded into Power BI
    • Knowledge of DAX, Microsoft's native formula and query language for Power BI
    • Creating measures
    • Creating calculated columns
    • Creating tables/queries from tables/queries that have been loaded into Power BI
    • Creating different types of visualizations
    • Experience with various enterprise-level APPLICATION PROGRAMMING INTERFACES (APIS)
    • Experience in BUILDING MACHINE LEARNING MODELS (Supervised/Unsupervised) and
    • Experience with NATURAL LANGUAGE PROCESSING (NLP) and text analytics methods and packages
    • Strong DATA PROFILING, CLEANING, MINING and technical documentation by extracting data SQL database or Oracle platform systems i.e. ERP, MRP, JDE.
    • Experience in developing Power Bi dashboards.
    • Experience building the end-to-end pipeline and deploying prediction models
    • Experience with BIG DATA TECHNOLOGIES parallel processing techniques and APACHE SPARK (PYSPARK), HADOOP ECOSYSTEM.
    • Software Validation experience
    • EU MDR Regulation Knowledge
    • RPA Knowledge
    • Familiar with Linux environment, shell scripting, and GIT

    Education/Experience

    Bachelor's Degree in Computer Science, Statistics, Mathematics, or relevant fields, 3+ Years related experience Required OR Master's Degree in computer science or related field, 2+ Years related experience Required

    Computer Science background tends to make the candidate most successful and is Preferred