热门公司

招聘

职位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