Data Analyst

  • Full-time

Company Description

From concept to design to execution, be part of the team that gets everyday products to people.

Grantek is a recognized leading provider of integrated automation, smart manufacturing and industrial information solutions in the global marketplace. Our clients are some of the worlds most respected Fortune 100 companies and recognized consumer brands: Tassimo, Brita, MillerCoors, Coca-Cola, Kraft-Heinz, to name a few

We offer a collaborative atmosphere where you can learn new technologies and have your skills and ideas valued.  Work with a range of technologies to solve real business problems.  Utilize your trouble shooting and organizational skills to drive successful implementation of new solutions.

We offer a competitive and comprehensive compensation package, retirement matching, company paid benefits, flexible work hours, and an education/career development program. For more information on what Grantek offers, visit: http://reviews.greatplacetowork.com/grantek-systems-integration

We are committed to providing a positive and healthy corporate culture, one that empowers employees, promotes knowledge-sharing, and encourages strong friendships and social connections amongst all team members. We are a team of dedicated Corporate Employees, Engineers and Designers with an average of 7 years’ tenure at Grantek. The vast majority of our employees have started off their careers at Grantek and have grown into successful senior team members who are integral to our client's manufacturing processes.

Job Description

As a key member of the Information Technology Team, you will be a liaison to other departments such as Finance, and responsible for learning their business processes and needs.  Utilize Microsoft technologies to provide functional and intuitive reports and dashboards.  Develop and document process flows, the data dictionary, and technology interfaces.  Advance towards a deep understanding of operational and financial data and promote its transformation into actionable information.  Deliver solutions around enhanced interfaces, data extract/mart, improved reporting, and analytical data platforms.  Recommend and implement technologies that make sense for the environment.

 

Primary Job Responsibilities:

  • Work with the Finance and Operations teams to validate data and determine process improvements to resolve current challenges and future needs
  • Assemble, sort, analyze, validate, and automate multi-faceted data to improve the financial reporting processes
  • Develop and automate reports utilizing SQL Server, SSRS, PowerBI, and Tableau
  • Optimizing data models for downstream consumption by BI platforms such as Tableau or PowerBI
  • Collect reporting data from multiple teams and sources, and aggregate to provide business value
  • Support changes to Reports and Dashboards to allow the business to track additional metrics as required
  • Act as liaison between IT and Finance, identifying gaps, trends, and opportunities, and providing technical assistance for improving data transformation
  • Contribute to the team in both technical and analytical aspects by sharing and adopting best practices
  • Having fun and being challenged

 

Qualifications

Technologies Used/Experience Required:

  • 2+ years of hands on experience working with databases and performing SQL functions such as select queries, data loads, joins and creating tables. 
  • Programming skills in such languages such as PHP, .NET and Java a Plus
  • Experience using SQL Server Reporting Services and SQL Server Integration Services to create reporting dashboards is required
  • Experience with developing Business Intelligence Reports using Microsoft technologies such as SSRS and PowerBI preferred
  • Experience managing SQL Server (2014 or 2016) database architecture (components and processes of the database) required
  • Expert level of Excel required including pivot tables and VLOOKUPs
  • Experience writing complex SQL queries (using joins and grouping) required
  • Ability to extract, convert and transform data files and databases from one format to another
  • Ability to create and maintain data dictionaries for existing and new databases
  • Detail oriented with excellent analytical and problem-solving skills
  • Strong written and verbal communication skills
  • Strong organizational and time management skills with the ability to work under pressure and meet tight deadlines
  • Highly organized and able to prioritize and handle a variety of tasks and responsibilities simultaneously and efficiently
  • Flexible and adaptable with a positive “can-do” attitude who gets excited about taking on new challenges.

#exploregrantek

Additional Information

We are committed to the principle of equal employment opportunity for all employees and to provide Grantekians with a work environment free of discrimination and harassment.