refresh

트렌딩 기업

트렌딩 기업

채용

채용Johnson Controls

Procurement Data Engineer Associate

Johnson Controls

Procurement Data Engineer Associate

Johnson Controls

San Pedro Garza Garcia-Nuevo Leon-Mexico

·

On-site

·

Full-time

·

1w ago

What will you do?

Join us in the Procurement Execution Center as a Data Engineer Associate. In this role, you will support the design, development, and maintenance of scalable data solutions by building and optimizing data pipelines, integrating multiple data sources, and ensuring high data quality and availability to enable data-driven decision-making.

The Data Engineer Associate is expected to assist in analyzing data requirements, developing and automating ELT processes, enhancing data models, validating data accuracy, and supporting analytics and reporting use cases in a timely and reliable manner.

How will you do it?

1. Deploy data ingestion processes through Azure Data Factory to load data models as required into Snowflake. 2. Build, design and support ETL/ELT processes with Azure Data Factory (ADF) and/or Python, which once deployed, will require to be executed daily and weekly. 3. Assemble large data sets that meet functional / non-functional business requirements. 4. Develop data models that enable Data Viz, Reporting and Advanced Data Analytics, striving for optimal performance acro

ss all data models. 5. Maintain conceptual, logical, and physical data models along with corresponding metadata. 6. Utilizes the DevOps pipeline deployment model, including automated testing procedures. 7. Executes data stewardship and data quality across our data marts, to cleanse, enrich and correct issues in our data, using knowledge bases and business rules. 8. Performs the necessary data ingestion, cleansing, transformation, and coding of business rules to support annual Procurement bidding activities. 9. Other Data Engineering duties as assigned.

Qualifications

  • Bachelor’s degree in related field (Engineering, Computer Science, Data Science or similar)

  • 1+ years of relevant experience in data analytics roles, data engineering, software

  • Engineering or other relevant data roles.

  • SQL knowledge and experience working with relational databases.

  • Knowledge in DW/DL concepts, data marts, data modeling, ETL/ELT, data quality/stewardship, distributed systems, and metadata management.

  • Knowledge on building and optimizing data pipelines, architectures, and data sets.

  • ETL/ELT development experience (1+ years). SSIS or ADF are preferred.

  • Ability to resolve ETL/ELT problems by proposing and implementing tactical/Strategic solutions.

  • Experience with object-oriented function scripting languages: Python, Scala, R, etc.

  • Experience with NoSQL databases is a plus to support the transition from On-Prem to Cloud.

  • Excellent problem solving, critical thinking, and communication skills

  • Relevant experience with Azure DevOps (CI/CD, git/repo management) is a plus

  • Due to the global nature of the role, proficiency in English language is a must

총 조회수

0

총 지원 클릭 수

0

모의 지원자 수

0

스크랩

0

Johnson Controls 소개

Johnson Controls

Johnson Controls International plc is an American-Irish multinational conglomerate headquartered in Cork, Ireland, that produces fire, HVAC, and security equipment for buildings. As of mid-2019, it employed 105,000 people in around 2,000 locations across six continents.

10,001+

직원 수

Cork

본사 위치

리뷰

4.0

10개 리뷰

워라밸

3.2

보상

3.8

문화

4.1

커리어

3.4

경영진

3.1

72%

친구에게 추천

장점

Good benefits and compensation

Supportive team culture and friendly coworkers

Flexible work arrangements and remote options

단점

Work-life balance challenges and heavy workload

Management responsiveness issues

Limited career advancement opportunities

연봉 정보

271개 데이터

Junior/L3

Mid/L4

Senior/L5

Junior/L3 · Data Analyst

0개 리포트

$136,240

총 연봉

기본급

-

주식

-

보너스

-

$115,804

$156,676

면접 경험

2개 면접

난이도

2.5

/ 5

소요 기간

14-28주

합격률

50%

경험

긍정 50%

보통 50%

부정 0%

면접 과정

1

Application Review

2

Recruiter Screen

3

Hiring Manager Interview

4

Technical Interview

5

Offer

자주 나오는 질문

Technical Knowledge

Behavioral/STAR

Past Experience

Problem Solving

Industry Knowledge