Openings >> Operations Analyst
Operations Analyst
Summary
Title:Operations Analyst
ID:4741UB
Location:Burr Ridge, IL
Description
Company

BGRS develops and implements comprehensive talent mobility solutions for corporate and government clients worldwide. With deep industry experience and unparalleled insights on the future of talent mobility, we enable our clients to craft mobility programs that will empower them to attract, retain and develop top performers.

Business Intelligence Analyst
This position is an integral part of the Operational Excellence team and is responsible for providing meaningful data, reports and developing self-serve dashboards for our internal customers. This role will support BGRS' operational teams by providing data and building dashboards for internal performance management. In addition, this position will be responsible for assisting the Operational Excellence team with other projects and partnering with team members to assist in delivery of information around our internal time-tracking tools. The Analyst will work closely with the business by assisting in requirements gathering, and assessing the day-to-day needs of reporting and data analysis, with an aim to achieve highest standard with accuracy and timeliness.

Responsibilities
  • Design, develop, enhance, support and maintain Standard and Ad-hoc reports achieving the highest standard of accuracy and timeliness using best practices
  • Design, develop, enhance, support and maintain Automated reporting processes/jobs usingT-SQL, SQL, Microsoft BI Tools, MS Access databases, ServiceEngine Databases and other tools to reduce manual intervention and to achieve increased productivity
  • Quality control of reporting performed by department to ensure that reports are meeting the requests of the operational areas
  • Liaise with internal customers, validate and document reporting requirements and provide appropriate reporting solutions
  • Understand the needs of internal partners to produce accurate and timely standard and ad-hoc reports
  • Prepare and present analytical data and recommendations to internal and stakeholders as well as BGRS Management
  • Identify, analyze, and interpret trends or patterns in complex data sets
  • Proactively identify, support and coordinate report automation opportunities
  • Proactively identify, recommend and communicate Innovative reporting opportunities
  • Develop the testing, implementation and validation, in addition to after-installation validation of reports
  • Partnering directly with stakeholders within the organization to gather requirements and translating requirements into solutions

Essential Skills & Experience
  • BS/MS in Information Technology, Business or the equivalent and/or very strong related work experience, including business experience
  • 2 or more years experience writing queries using T-SQL or other SQL variant
  • Experience creating reports and preforming data analysis using SQL, Excel or other database tools and technologies
  • Experience working with MS SQL Server 2005 or higher
  • Clear understanding of Relational Database concepts with a proven track record of working with one or more DBMS/RDBMS Databases (i.e. Oracle, MS SQL Server, DB2, MySQL, PostgreSQL)
  • Adept at writing complex queries using SQL/T-SQL for reporting purposes
  • Experience in structured report development utilizing various data sources and back-end databases while applying best practices
  • Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy
  • Adept at queries, report writing and presenting findings to internal and external stakeholders
  • Experience with Microsoft Office Suites euro;“ Excel, Access databases
Preferred Skills & Experience
  • Experience working in large data warehouse environment with multiple data sources and dimensional data marts
  • Experience working with both structured and unstructured data sources
  • Experience with creating interactive dashboards using Power BI, SSRS Mobile Reports or other visualization tools
  • Knowledge and/or experience working with SQL Server Analysis Services (SSAS)
  • Knowledge and/or experience working with SQL Server Reporting Services (SSRS)
  • Knowledge and/or experience working with PowerPivot and Excel VBA
  • Knowledge and/or experience working with PowerQuery or data transformation
  • Knowledge and/or experience working with DAX
  • Knowledge and/or experience working with MDX
  • Knowledge and/or experience working with Report Builder
  • Knowledge and/or experience working with Visual Studio
  • Knowledge and/or experience working with VBA/Macros and Advanced Excel functionality

Key Competencies
  • Excellent oral and written communication skills
  • Strong organizational and time management skills coupled with an exceptional attention to detail
  • Logical thinker with good analytical skills
  • Excellent team player with an ability to work using own initiatives and as part of a team
  • Ability to analyze complex problems involving multiple facets and variables in non-standardized situations
  • Ability to prioritize and manage conflicting requirements
  • Adaptability to changing environment, and stress tolerance
  • Mobile relocation industry knowledge a plus


As an Equal Opportunity Employer, BGRS embraces diversity and, as such; is dedicated to considering all qualified applicants without regard to race, color, gender, religion, national origin, disability, age, sexual orientation, marital status, pregnancy and parenting status, protected veteran status and any other characteristic protected by law. Employment may be subject to additional background checks, drug testing and fingerprint processing.
This opening is closed and is no longer accepting applications
ApplicantStack powered by Swipeclock