Water Engineer intern or co - op working on water engineering projects in Pittsburgh. Involved in planning, design, and construction administration for various water management initiatives.
About the role
- Data Modeling Engineer at Aramark building dimensional models and BI data products in Snowflake. Collaborating with data engineering and BI teams to ensure data accuracy and reliability.
Responsibilities
- Build dimensional models and Business Vault structures in Snowflake based on approved architectural designs
- Apply approved business logic and KPI definitions
- Partner closely with data engineering teams
- Ensure accurate, reliable, and consumption-ready modeled data
- Focus on implementation and build execution within Snowflake
- Build architect-approved star schemas and subject-area dimensional models
- Implement bridge tables resolve many-to-many relationships, hierarchies, and allocation logic
- Deliver business-friendly semantic layers optimized for Power BI consumption
- Validate modeled outputs for accuracy and completeness
- Support SDLC and SOC 1 evidence requirements through clear documentation
Requirements
- Strong hands on experience with Snowflake
- Familiarity and comfortability with Data Vault 2.0 methodology
- Advanced SQL expertise, including complex joins, window functions, and performance tuning.
- Strong understanding of dimensional modeling concepts including SCDs, surrogate keys, and conformed dimensions.
- Experience encoding business logic and KPI definitions into curated semantic views.
- Experience supporting semantic models and datasets consumed by Power BI and other BI tools
- Familiarity with Snowflake governance features including data masking and sensitivity tagging.
- Experience supporting production data models through SDLC and incident resolution.
- Strong communication and documentation skills.
Benefits
- medical
- dental
- vision
- work/life resources
- retirement savings plans like 401(k)
- parental leave
- disability coverage
Job title
Job type
Experience level
Salary
Degree requirement
Tech skills
Location requirements
Civil Engineer PE in Cincinnati overseeing site development and redevelopment projects. Joining Arcadis to deliver innovative civil engineering solutions within a collaborative environment.
Senior Water Resources Engineer managing complex water resource planning projects for Stantec. Leading client engagement and cross - disciplinary strategy development in California and the Western US.
Principal Water/Wastewater Engineer managing water and wastewater treatment and conveyance projects. Engaging clients and leading project teams in California water market.
Senior Project Engineer guiding technical design and managing project engineers for data center projects. Overseeing quality and client relations in mission critical facilities with a focus on innovative solutions.
Intermediate Surface Mining Engineer executing mining engineering projects for various commodities. Collaborating with clients and engineers to deliver safe and innovative mining solutions in a hybrid setup.
CAE Engineer leading virtual design and optimization of vehicle exterior components through advanced analysis methods. Collaborating with cross - functional teams to meet performance requirements.
Engineer Associate performing intermediate level engineering activities and leading specialized projects in Texas at AEP, committed to delivering innovative energy solutions.
Maintenance Engineer I responsible for maintaining high hotel standards and maximizing guest satisfaction. Collaborating with team members to resolve maintenance issues efficiently and professionally.
Pool Technician maintaining pools and other water bodies at JW Marriott. Ensure safety compliance and excellent guest service in all operations.