Data Engineer
TEKsystems•Columbia City, IN
•$80,000 - $112,000•Onsite
About The Position
The Data Engineer at Structural will own and evolve our modern data stack, moving data from diverse sources into trusted, analytics-ready models that power decision making across the business. You’ll design and operate pipelines, shape semantic models in Power BI / Fabric, optimize and manage our Azure Stack. This role will also involve optimizing our ERP data structures and ETL services.
Requirements
- Bachelor’s degree in Data Engineering, Computer Science, or related field.
- 3-5 years of professional data engineering experience in a production environment.
- Hands-on experience with orchestration tools.
- Proficiency with a modeling framework (such as Dagster, Airflow/Prefect.
- Intermediate Python (data access, transformations, packaging/venv, type-safe code, unit tests, etc).
- SQL Expertise (advanced T-SQL, PL/SQL), window functions, performance tuning, query plans, indexing strategies, partitioning.
- Azure Data Lake, Data Factory, and other data-centric toolsets.
- Working knowledge of Microsoft Fabric and Power BI semantic modeling (dimensional design, DAX measures).
- Linux/Bash skills.
- API/application integrations experience (REST/JSON, OAuth2/Keys, Odata).
- Version control with Git and collaborative workflows (PR’s, code reviews, etc).
- Strong communication, documentation, and stakeholder partnership skills.
- Interactive Data Visualization Design and Implementation.
Responsibilities
- Design, build, and maintain ETL pipelines, currently with SSIS.
- Design and implement Azure data assets.
- Build and maintain Power BI semantic models, optimizing for refresh and query performance.
- Leverage Microsoft Fabric for end-to-end analytics workflows, governance, and distribution.
- Manage integrations with external APIs/Applications such as Power BI, Azure DevOps, SalesForce CRM, Princeton TMX.
- Administer and optimize On-Prem SQL, Oracle, Azure SQL objects, ensuring data quality and reliability.
- Partner with end users and business stakeholders to gather requirements, perform testing and QA, and ensure smooth handoff of deliverables.
- Monitor, troubleshoot, and continuously improve pipeline reliability, cost, and performance.
- Data design and preparation for use with AI tools
Benefits
- Medical, Dental and Prescription Insurance
- Vision and Hearing Coverage
- Flexible Spending Accounts
- Health Savings Accounts
- Castlight Health Navigation Platform
- Well-Being Program
- Life/AD and D Coverage
- Disability Coverage
- Profit Sharing and Retirement Savings
- Stock Benefits
- Educational Assistance
- Dependent Child Scholarships
- Paid Vacations and Holidays
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
Upload and Match Resume
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
