BI Data Engineer

Continental Structural Plastics

  • Auburn Hills, Michigan
  • 30+ days ago

    Highlights

    Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, Mathematics, or a related field - OR equivalent practical experience (bootcamp, internships, certifications, or hands-on projects). Assist senior team members in building and maintaining tables, schemas, and data models inside Microsoft Fabric to support Power BI dashboards.

    Numbers & Facts

    LocationAuburn Hills, Michigan

    Description

    Teijin Automotive Technologies is an innovative and full-service Tier One supplier with a global presence and emphasis in development for lightweight technologies. Teijin Automotive offers employees the opportunity to join a leading edge company within the composite material industry and enjoy the benefits offered by a growing company in North America and internationally.

    What You'll Do

    Learn the Data Environment

    • Assist senior team members in building and maintaining tables, schemas, and data models inside Microsoft Fabric to support Power BI dashboards.
    • Help translate business requirements (provided by the BI Business Analyst) into clean, well-organized data structures, with guidance from senior engineers.
    • Write SQL queries and basic Python scripts to transform and clean data, learning best practices along the way.
    • Document tables, transformations, and pipelines clearly so the team can rely on your work.

    Support Pipeline Development

    • Contribute to data pipelines that bring information from source systems (such as ERP and other business platforms) into our Fabric environment.
    • Help schedule and monitor pipelines, learning how to identify and troubleshoot common failures.
    • Suggest small improvements to reduce manual work and improve data quality.

    Build Reporting Skills

    • Work with the team to maintain semantic models and datasets used by Power BI report developers.
    • Practice writing DAX measures and calculated columns under the guidance of senior team members.
    • Learn data modeling fundamentals such as star schema design and the medallion architecture (Bronze / Silver / Gold layers).

    Collaborate and Grow

    • Participate in sprint planning, code reviews, and design discussions - your questions are welcome.
    • Communicate progress, blockers, and questions clearly to teammates and stakeholders.
    • Take advantage of training, certifications, and mentorship to expand your skills over time.

    Skills We're Looking For

    We do not expect candidates to be experts in every area. Foundational knowledge - from coursework, bootcamps, internships, or personal projects - is enough for required skills. Preferred skills are nice-to-haves and can be learned on the job.

    Skill / Technology

    Expected Level

    Classification

    SQL

    Foundational

    Required

    Python

    Foundational

    Required

    Power BI & DAX

    Beginner / Exposure

    Required

    Microsoft Fabric

    Willingness to learn

    Required

    Data Modeling Concepts

    Beginner / Coursework

    Required

    PySpark

    Exposure

    Preferred

    Git / Version Control

    Familiarity

    Preferred

    ERP Systems

    Awareness

    Preferred

    Qualifications

    Required

    • Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, Mathematics, or a related field - OR equivalent practical experience (bootcamp, internships, certifications, or hands-on projects).
    • 0-2 years of professional experience. Internships, capstone projects, and significant personal projects count.
    • Foundational SQL skills - comfortable writing SELECT, JOIN, GROUP BY, and basic aggregate queries.
    • Basic Python skills for working with data (e.g., pandas, simple scripts, notebooks).
    • Some exposure to Power BI or another visualization tool, even if only through coursework or self-study.
    • Understanding of basic data concepts such as tables, relationships, and joins.
    • Strong written and verbal communication skills, and a willingness to ask questions.
    • Eagerness to learn Microsoft Fabric, DAX, and modern data engineering practices on the job.

    Preferred (Nice to Have)

    • Coursework, certifications, or hands-on practice with Microsoft Fabric, Azure Synapse, Azure Data Factory, or Azure Data Lake.
    • Familiarity with PySpark or distributed data processing concepts.
    • Awareness of ERP systems and how business data is typically structured.
    • Experience using Git for version control.
    • Microsoft certifications such as DP-900 (Azure Data Fundamentals), PL-300 (Power BI Data Analyst), or DP-600 (Fabric Analytics Engineer).
    • Personal projects, GitHub portfolio, Kaggle work, or contributions to open-source data projects.

    Similar Jobs