Computer Programming Intern -Workforce Analytics Team (WD30037579219)
Johnson Controls is a global diversified technology and multi industrial leader serving a wide range of customers in more than 150 countries. Our 130,000 employees create intelligent buildings, efficient energy solutions, integrated infrastructure and next generation transportation systems that work seamlessly together to deliver on the promise of smart cities and communities. Our commitment to sustainability dates back to our roots in 1885, with the invention of the first electric room thermostat. We are committed to helping our customers win and creating greater value for all of our stakeholders through strategic focus on our buildings and energy growth platforms. For additional information, please visit or follow us @johnsoncontrols on Twitter.
Position Summary & Responsibilities
Looking for desirable work experience and an opportunity to learn new skills in a hot analytics discipline? Johnson Controls has a function within their Human Resources organization focused solely on Workforce Analytics. You will help drive data-driven people decisions and tell the underlying story behind the data for our strategic reporting capabilities and predictive analytics. The mission: create an evidence-based culture that endorses analytics at the highest levels. The vision: Drive competitive advantage by linking people programs and initiatives to workforce outcomes and business results as well as provide standardized, efficient, user-friendly strategic reporting that drives action.
Under the direction of a Workforce Analytics & Strategy Manager, the Workforce Analytics Intern will compile and analyze HR and financial data to provide decision support to HR Business Partners, HR Centers of Excellence (CoEs) and Business Leaders. The role will have responsibility for successfully obtaining, standardizing and analyzing employee and financial data.
Specific responsibilities may include but is not limited to the following:
Assist in integrating disparate data from multiple systems and tool.
Assist in implementing processes and procedures to support, standardize, streamline, and in some cases automate data and reporting services using SSIS and SAS software
Ensure timely and accurate execution of monthly reporting activities (including: metrics, scorecards, and dashboards) as well as define and design ad-hoc reporting as needed
Assist in creating reports of analytical findings - both written and graphical
Assist in development of tools and applications as needed
Required Experience & Qualifications
- Experience using relational databases
- Experience completing routine and ad-hoc data requests
- Strong attention to detail
- Strong Microsoft Excel, Access, and PowerPoint skills
- Ability to multitask and change direction quickly
- Ability to take direction and follow-through on tasks within parameters of project and timeline
- Current sophomore or junior undergraduate or 1st year graduate student in IT, Information Management, or similar
- Available to work 15-30 hours/week during the semester and FT during the summer
Desired Experience & Qualifications
- Experience with database design, integration and management projects
- Able to use SQL efficiently
- Software development experience
- Experience developing reports in Workday and PeopleSoft
- Experience with BI and data visualization tools (preferably Tableau)
Johnson Controls is a global multi-industrial company with core businesses in the automotive, building and energy storage industries. Our 170,000 employees create quality products and services to optimize energy and operational efficiencies of buildings, energy storage and interior systems for automobiles. Through our growth strategies and by increasing market share we are committed to delivering value to shareholders and making our customers successful.Johnson Controls, Inc. is an equal employment opportunity and affirmative action employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, age, protected veteran status, status as a qualified individual with a disability or any other characteristic protected by law. If you are an individual with a disability and need assistance or accommodation during the application process please call 414-524-8999 and press option #0 or email HR_Recruitment@jci.com.