TVS Supply Chain Solutions North America, Inc.
  • 18-Nov-2019 to 17-Jan-2020 (CST)
  • Technical Support
  • St Peters, MO, USA
  • Salary
  • Full Time

Medical, Dental and Vision Benefits


Summary/Objective

As a Business Intelligence Analyst, you will be focused on the advancement of the company's BI environment to drive critical reporting and data analysis for our business. This is an opportunity to leverage your passion for analytics and business intelligence to add considerable business impact through the delivery of BI.   The BI Analyst will assist with the data warehousing efforts and be responsible for developing, maintaining ETL data feeds, BI reports, and dashboards. The BI Analyst will work closely with different department leaders to design, develop and support data structures, reports, scorecards and dashboards.

 

Essential Functions

Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

We use Microsoft's SSIS and KingswaySoft for our ETL processing, SSMS and Visual Studio for managing our data warehouse. We currently use Microsoft PowerBI heavily as our reporting toolset. This will be a unique opportunity to help move to our Power BI platform to a new level.

We are looking for someone with strong experience across the entire BI stack including: DB, Data Warehouse, ETL tools, and front-end BI tools. We are also looking for someone who is comfortable being self-managed while providing adequate updates to keep appropriate stakeholders abreast of status.

Data Warehouse Analyst/Developer:

  • Consulting with internal and external clients to model data structures.
  • Plan and execute data conversions, data structures and migrations
  • Ensure the accuracy, performance, and consistency of the data schemas
  • Oversee data warehouse capacity planning, forecasting, and tuning
  • Manage data warehouse security, and control access permissions and privileges
  • Must have strong experience with the creations of datamarts and tabular / cube structures

ETL Analyst/Developer:

  • Develop new or modify existing ETL processes to meet new needs of the business
  • Fine-tune ETL processes for optimal transactional performance
  • Must have strong experience with the development of ETL processes

Business Intelligence Analyst/Developer:

  • Work closely with senior leaders, sales and operations to deliver meaningful data in the form of BI reports and dashboards. This role liaises directly with several key members of the business and therefore has the opportunity to truly improve & transform how we deliver information.
  • Utilize, update, and manage BI tools such as SQL Server, Power BI, PowerApps.
  • Play an active role in all IT projects to ensure the BI architecture continues to align with other systems as the overall IT architecture evolves.

Daily Performance Management:

  • Perform health checks to ensure the integrity of the schema and the data
  • Perform health checks to ensure the synchronization of database replicas
  • Liaise with applications and infrastructure teams to resolve complex application performance analysis

 

Competencies

  • Problem Solving/Analysis
  • Business Acumen
  • Strategic Thinking
  • Results Driven
  • Leadership
  • Customer Focus
  • Technical Capacity
  • Communication
  • Initiative
  • Analytical Skills
  • Detail-oriented
  • Interpersonal Skills
  • Team-player

 

Physical Demands / Work Environment 

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job.

While performing the duties of this job, the employee is regularly required to talk or hear. The employee is frequently required to stand; walk; use hands to finger, handle or feel; and reach with hands and arms. The associate may occasionally be required to lift 51 pounds, anything greater than 51 pounds requires assistance. Specific vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, depth perception and ability to adjust focus.

 

Position Type and Expected Hours of Work 

Full Time. Schedule flexibility for extended or unplanned work hours is required.

 

Travel

Travel domestically and internationally

 

Required Education and Experience

  • 5+ years in related role in addition to a Bachelor's degree in Information Systems, Management Information Systems, Computer Science, Statistics or related field.  
  • 3 years' experience working in a warehouse and manufacturing environment, collaborating with the business to produce key business metrics, scorecards and dashboards.
  • Excellent interpersonal skills and ability to work with all levels of personnel individually including senior leadership. Good communication skills, both verbal and written.
  • Excellent project, organization change and financial management skills.
  • Disseminate information regarding tools, reports, or metadata enhancements.
  • Conduct or coordinate tests to ensure that data is consistent with defined needs.
  • Maintain or update business intelligence tools, databases, dashboards, systems, or methods.
  • Manage timely flow of business intelligence information to users.
  • Identify and analyze industry or geographic trends with business strategy implications.
  • Maintain library of model documents, templates, or other reusable knowledge assets.
  • Document specifications for business intelligence or information technology (IT) reports, dashboards, or other outputs.
  • Create business intelligence tools or systems, including design of related databases, spreadsheets, or outputs.
  • Generate standard or custom reports summarizing business, financial, or economic data for review by executives, managers, clients, and other stakeholders.

 

Other Duties

Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities may change at any time with or without notice.

 

TVS Supply Chain Solutions North America, Inc.
  • Apply Now

  • * Fields Are Required

    What is your full name?

    How can we contact you?

  • Sign Up For Job Alerts!

  • Share This Page
.
Logo Home About Us Solutions Locations Sectors Case Studies Careers Contact Us