BI Data Engineer

Teijin Automotive Technologies

$70K — $95K *
Information Technology
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • Bachelor's degree in a relevant field or equivalent practical experience (bootcamp, internships, certifications).
  • 0-2 years of professional experience, including internships and significant personal projects.
  • Foundational SQL skills including SELECT, JOIN, and basic aggregate queries.
  • Basic Python skills for data manipulation (e.g., using pandas).
  • Exposure to Power BI or another data visualization tool.
  • Understanding of basic data concepts such as tables, relationships, and joins.
  • Strong communication skills and a willingness to ask questions.

Responsibilities

  • Assist in building and maintaining tables and data models in Microsoft Fabric for Power BI.
  • Translate business requirements into organized data structures with guidance.
  • Write SQL queries and basic Python scripts for data transformation.
  • Document tables and data transformations clearly for team use.
  • Contribute to data pipelines bringing information into the Fabric environment.
  • Schedule and monitor data pipelines, identifying and resolving common issues.
  • Suggest improvements to enhance data quality and reduce manual work.

Benefits

  • Opportunities for training and certifications to expand your skill set.
  • Mentorship from experienced senior team members.
  • Involvement in project discussions, sprint planning, and code reviews.
  • Career growth potential within a collaborative team environment.
Full Job Description
Job Description

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

More Jobs at Teijin Automotive Technologies

  • Engineering Manager
    $100K — $130K *
    Salisbury, NC 28146 (Rowan County)
    Manufacturing & Automotive
    In-Person
  • BI Data Engineer
    $70K — $95K *
    Auburn Hills, MI 48326 (Oakland County)
    Information Technology
    In-Person
  • Program Manager
    $90K — $120K *
    Auburn Hills, MI 48326 (Oakland County)
    Manufacturing & Automotive
    In-Person
  • EHS Operations Partner
    $70K — $95K *
    Auburn Hills, MI 48326 (Oakland County)
    Manufacturing & Automotive
    In-Person
  • Controls Engineer
    $70K — $95K *
    Seguin, TX 78155 (Guadalupe County)
    Manufacturing & Automotive
    In-Person

More Information Technology Jobs

Find similar BI Data Engineer jobs: