Data Analyst - Troy, United States - Kyyba

    Kyyba
    Kyyba Troy, United States

    1 month ago

    Default job background
    Description

    QUALIFICATIONS
    Education - Required:
    Bachelor's Degree in Business, Engineering, Statistics, Computer Science, Mathematics,

    Supply Chain or equivalent combination of education and experience
    Education - Preferred:
    Master's Degree or equivalent combination of education and experience

    Years of Experience:
    Minimum three (3) years of related experience required

    Supervisory Experience:
    None


    Licenses and Certifications:
    None

    Other Skills/Experience - Required:

    ⎯
    ⎯ Expert in SQL
    ⎯ Excellent analytical thinking for translating data into informative visuals and reports
    ⎯ Expertise in using advance level calculations on the data sets
    ⎯ In-depth understanding of database management systems, online analytical
    processing (OLAP) and ETL (Extract, transform, load) framework

    Other Skills/Experience - Preferred:


    Additional Requirements:
    ⎯ Demonstrate the ability to document steps in a process and make technology
    recommendations to improve the process
    ⎯ Knowledgeable of statistical methods such as regression, probability analysis, risk
    analysis, statistical process control, and clustering is desired
    ⎯ Able to implement row level security on data and understand application security
    layer models
    ⎯ Data and business analysis background
    ⎯ Proficient with Microsoft Office applications, specifically Excel, Word and
    PowerPoint
    ⎯ Familiarity with BI technologies (ex., Microsoft Power BI, AWS Quicksight, Qlikview)
    ⎯ Familiarity with one or more programming languages (ex: Python, R, JavaScript, C#,
    Java, etc.)


    ESSENTIAL DUTIES
    ⎯ Collaborate closely with stakeholders and other analysts to develop new and unique data-driven solutions using Big
    Data platforms, creative analytical methods, and data visualization techniques (Data Modeling etc.)
    ⎯ Connect and build pipelines between various data sources
    ⎯ Support operational improvement and business decision making through ad-hoc statistical analysis of curated
    enterprise data and self-constructed data sets
    ⎯ Leading BI software development, deployment, and maintenance
    ⎯ Documenting contents in a data warehouse and meta-data storage
    ⎯ Creating technical documentation for BI tools
    ⎯ Data modeling
    ⎯ Develop KPI dashboards
    ⎯ Perform additional duties as assigned
    ⎯ Act with honesty and integrity and make ethical business choices in accordance with Magna's Compliance Policies and
    Procedures