Back

Strategic Student Program: STS Business Intelligence Intern (Spring 2023; REMOTE)

Job Description

Siemens Industry Software Inc.
Strategic Student Program (SSP) 

We are a leading global software company dedicated to the world of computer aided design, 3D modeling and simulation— helping innovative global manufacturers design better products, faster!  With the resources of a large company, and the energy of a software start-up, we have fun together while creating a world class software portfolio. Our culture encourages creativity, welcomes fresh thinking and focuses on growth, so our people, our business, and our customers can achieve their full potential.  
 
We’re currently recruiting students for our Spring 2023 Strategic Student Program. Our intern positions will allow you to find a career path that most inspires you. Here, you will apply your education to solve real-world problems, and turn theory into practice. At Siemens, our goal is to empower our students to become the next leaders of our company.  

Baseline Requirements: 
  • Currently enrolled as a university undergraduate or master's student 
  • Minimum 3.0 GPA
  • Able to commit to part-time work in the spring and full-time work in the summer
  • Preferred for candidate to be in Eastern Time Zone
Perks: 
  • Paid volunteer time off 
  • Employee discounts at our top customer sites 
  • Networking with our global leaders 
  • Mentorship from senior engineers
  • Individual career development planning  
  • Professional and technical workshops 
  • Energetic student community 
  • Leadership opportunities 
  • Potential for full time offers after university graduation and completion of the program 
Simulation and Testing Solutions Group
Business Intelligence Intern 
We’re currently recruiting a Business Intelligence (BI) Intern for Simulation & Testing Solutions (STS) business segment within Siemens. As a BI Intern, you will be directly responsible for working within the process & architecture team to load and migrate the data into our data warehouse from variety of business systems, develop new dashboards as well as improve our existing production dashboard functions

Responsibilities:
  • Migrate data from our existing on-premise data warehouse Vertica to cloud-based data warehouse solution Snowflake
  • Apply critical thinking to ensure data integrity and quality control is applied to each dataset, model, and other analysis prior to presenting to the internal customers
  • Develop ETL (Extract, Transform and Load) pipelines with Pentaho Data Integration
  • Migrate existing Tableau Dashboards to Snowflake
  • Develop new Tableau Dashboards according to the business requirements
  • Extract data from various data sources not limited to relational databases (PostgreSQL, MySQL etc.), JSON, MongoDB, CSV files, structured and unstructured files and REST APIs
Organization Requirements:
  • Studying for a degree in Computer Science, Data Analytics, or related field
  • Solid understanding of DBMS concepts such as relations, keys, and views
  • Commanding grasp on SQL (DDL, window functions, CTEs etc.)
  • Working knowledge of at least one ETL Tool (Pentaho, Alteryx, Talend, Informatica etc.)
  • Working knowledge of Tableau Desktop and Tableau Server (>2021)
  • Ability to perform Data Cleaning and Data Visualization
  • Sharp and tenacious troubleshooting skills
  • Effective verbal and written communication skills
  • Dedicated team player who enjoys working closely with others
Nice to have:
  • Prior experience with Data Warehouses
  • Understanding of Star and Snowflake Schemas
#DISW
#LI-PLM
#LI-Remote

Organization: Digital Industries

Company: Siemens Industry Software Inc.

Experience Level: Student (Not Yet Graduated)

Full / Part time: Part-time temporary



Equal Employment Opportunity Statement
Siemens is an Equal Opportunity and Affirmative Action Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to their race, color, creed, religion, national origin, citizenship status, ancestry, sex, age, physical or mental disability unrelated to ability, marital status, family responsibilities, pregnancy, genetic information, sexual orientation, gender expression, gender identity, transgender, sex stereotyping, order of protection status, protected veteran or military status, or an unfavorable discharge from military service, and other categories protected by federal, state or local law.

EEO is the Law
Applicants and employees are protected under Federal law from discrimination. To learn more, Click here.

Pay Transparency Non-Discrimination Provision
Siemens follows Executive Order 11246, including the Pay Transparency Nondiscrimination Provision. To learn more, Click here.

California Privacy Notice
California residents have the right to receive additional notices about their personal information. To learn more, click here.

Can't find what you are looking for?

Let's stay connected

Can't find what you are looking for?