BI Data Engineer

CSP is the industry leader in the formulation and molding of lightweight, advanced composite components for the transportation industries. As an innovative, full-service Tier One supplier, we offer an entrepreneurial environment where you’re only limited by your own imagination. In addition to our team-focused environment, we provide industry-leading benefits, called BENEfits4U. Our comprehensive offering includes: affordable medical, dental, and vision care; flexible spending accounts; life insurance; 401k with company match and much, much more.

Job Description

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.

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

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.

If you enjoy innovation, and an opportunity to learn and contribute to a growing organization, CSP is the place for you!