Location: Buda, TX
Job Category: IT Generalist
Salary Interval: SALARY
Req #: 190
Pay Range: N/A
Please attach a current resume with up-to-date contact information.
Dynamic Systems, Inc. (DSI) is a family-owned mechanical and process construction contractor headquartered in Austin, Texas, with locations across the USA. Since our founding in 1988, we’ve served industries from healthcare to higher education, prioritizing employee well-being and offering comprehensive benefits, including 401(k), health insurance, and career growth opportunities within a collaborative work environment.
At DSI, we value quality, safety, and integrity, fostering a team dedicated to innovation and excellence. Join us and be part of a company that supports its employees and gives back to the communities we serve.
What You'll Do
Build lakehouse pipelines in PySpark notebooks-
- Write reusable functions that ingest REST/SQL/CSV feed
-
Model Bronze-> Silver -> Gold tables in Delta Lake
-
Handle schema drift, CDC, and idempotent upserts
Own code-first ETL in Microsoft Fabric
-
Develop Dataflows Gen2 & Spark notebooks, not drag-and-drop SSIS
-
Package pipelines with Azure DevOps CICD & IaC (YAML/Bicep_
Harden security & governance
-
Mirror ERP role perms via RLS/CLS
-
Enforce naming/cost guard-rails; automate lineage & documentation
Enable analytics + AI
-
Expose Gold view to PowerBI and upcoming Copilot/ML wokloads
-
Optimize for cost/performance (partitions, Z-Order, cache)
Iterate like a startup
-
Ship small, gather feedback, refactor-two steps forward, one back
-
Participate in code reviews, lunch-and-learns, and design spikes
Tech You'll Touch Every Day
-
Python 3 / PySpark 3.5 in Fabric notebooks
-
Microsoft Fabric (Lakehouse, Dataflows Gen2, Warehouse, Pipelines)
-
Delta Lake / Medallion Architecture
-
Azure DevOps (Git repos, CI/CD YAML, work items)
-
REST / GraphQL APIs, SQL (T-SQL or Spark SQL), Parquet
-
Power BI (consumer focus), React portal in early design
This is an in-office position.
Dynamic Systems, Inc. is an equal opportunity employer regardless of race, creed, color, gender, age, religion, disabilities, national origin or veteran status.
Must-Have
-
3+years building code-driven data pipelines (PySpark, Spark, or dbt-Python)
-
Solid SQL plus Python unit-testing habits
-
Comfort with Git workflows & PR driven reviews
-
Clear Verbal+written explanation of medallion / lakehouse concepts
Nice-to-Have
-
Experience with Microsoft Fabric or Synapse
-
Construction, ERP, or manufacturing domain exposure
-
React or TypeScript interest for future self-service portal
-
Familiarity with Copilot Studio, Azure, OpenAI, or MLflow
Why You'll Like It Here
-
Green-field influence- we still debate folder names, your voice shapes standards
-
Startup pace, enterprise stability- iterate fast with the backing of a 2,500-employee firm
-
Career runway- grow toward architecture, AI engineering, or team leadership as the group scales
PIbdfedd7b4602-25404-37817564
