BI Data Engineer

Teijin Automotive Technologies
Auburn Hills, MI, United States
3 months ago

Role details

Contract type
Internship / Graduate position
Employment type
Full-time (> 32 hours)
Experience level
Starter
Experience required
0 years minimum
Working hours
Regular working hours
Job source

Tech stack

Data Analysis Microsoft Basic Data Partition Code Review Information Systems Information Engineering Data Structures Distributed Computing Environment Github Python (Programming Language) Scrum Methodology Power BI Standard Sql
+15 more
Azure Data Lake SQL Databases Scripting Azure Data Factory Kaggle Git Pandas Microsoft Fabric Pyspark Information Technology Data Analytics Star Schema Azure Synapse Analytics Software Version Control Data Pipelines

Job description

  • 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., 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

Requirements

Do you have experience in Writing skills?, 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., * 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.

About the company

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.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on indeed.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

1:22 min

Downloading and inspecting data frames via the Kaggle API

Lutske van der Meer Lutske van der Meer · WWC 2024

2:03 min

Accelerating pandas dataframes using cudf module plugins

Ankit Patel Ankit Patel · WWC 2024

6:21 min

Investigating push inefficiencies with upstream Git experts

Jonathan Creamer · Coffee With Developers

1:34 min

Bringing diverse skills to industrial data science roles

Katja Träumner

2:24 min

Setting up Python libraries and sourcing initial datasets

Lutske van der Meer Lutske van der Meer · WWC 2024

3:09 min

Balancing data science skillings alongside systems engineering rigor

Nico Schmidt · LIVE

Videos

See all

Related articles

See all