Koch
Join our Talent Network
Skip to main content

Data Analyst

 

Description

POSITION NAME:

Data Analyst / BI Developer

DIVISION OR CORPORATE FUNCTION:

DSS

REVISION DATE:

Sep 21st, 2022

LOCATION:

Bangalore

REPORTS TO:

Prasanna Ramaswamy

SUPERVISES:

None

CONTACTS:

Internal (all levels of the organization)

PRIMARY PURPOSE:

We at Molex, looking for a Data Analyst / BI developer who can develop automated reports and dashboards with the help of Power BI

DUTIES & RESPONSIBILITIES:

1.

Translate ideas and design into running codes.

2.

Have knowledge of database fundamentals such as multidimensional database design, relational database design, and more

3.

Build automated reports and dashboards with the help of Power BI and other reporting tools

4.

Be experienced in tools and systems on MS SQL, Tableau, Power BI, and DAX

5.

Have knowledge of database fundamentals such as multidimensional database design, relational database design, and more

6.

Developing visual reports, KPI scorecards, and dashboards using Power BI desktop.

7.

Capable of implementing row-level security on data along with an understanding of application security layer models in Power BI.

8.

Compare data that has been extracted from the source system (ex: SAP) and loaded into the target system, identifying data variances and differences.

9.

Able to create & execute data testing scripts used to compare source to target data.

10.

Preferably an end user of the Nx / ECTR system being migrated to Teamcenter

11.

Basic knowledge of engineering and manufacturing terms: Material Master, BOM, CAD drawing, Plant, etc.

12.

Must be familiar with data in the system that is being transferred. This would include engineering, quality, & product specific design data.

13.

Must understand the product development process of the business unit.

14.

Strong verbal and written communication skills

SCOPE:

· Works independently reporting the activity and results are reviewed on an agreed upon basis with management

· Position has a global reach through work with other Molex teams.

· Position involves creative thinking, problem-solving, organizational, and communication skills.

EDUCATION:

REQUIRED:

· Bachelor's degree in Computer Science / Mechanical Engineering / Information Systems or related discipline is desired.

PREFERRED:

· Bachelor's degree in Computer Science / Mechanical Engineering / Information Systems or related discipline is desired.

WORK EXPERIENCE:

REQUIRED:

· 3+ years of experience with Power BI.

· Must have 3-4years of experience in data analytics.

· Strong understanding of software development life cycle.

· Strong Analytic & Problem-Solving skills.

· Expert level knowledge of R, Python, DAX & Power Query.

· ETL process understanding.

o Data Modeling

o Data Cleaning

o Data Pre-processing

· Experience in Agile work environments.

· Excellent people and communication skills

· Flexibility in work schedule to meet testing schedules.

PREFERRED:

· Experience in Microsoft visual studio.

· Experience in SAP ECC / HANA.

· Experience in writing DAX queries for Power BI.

 

SKILLS & ABILITIES:

REQUIRED:

· Proficient with R, Python, DAX & Power Query.

· Power BI

· SQL

· Relational DB experience (SQL or Oracle Server).

· Ability to solve problems creatively and effectively.

· Likes to get things done

· Up to date on the latest web technologies

PREFERRED:

· Microsoft visual studio.

    Sign up for our talent network.

    Not ready to apply? Take a minute to sign up to receive notifications on opportunities that match your interests.

    Sign Up Now