Jr Data Engineer

The main function of a data engineer is to ensure that the data assets of an organization are supported by an architecture that supports the organization in achieving its strategic goal. A typical data engineer is responsible for setting enterprise standards for databases, data integration, and the means to get to the data.

Responsibilities:
Test programs or databases, correct errors and make necessary modifications.
Modify existing databases and database management systems or direct programmers and analysts to make changes.
Write and code logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions.

Required Skills:
Verbal and written communication skills, problem solving skills, customer service and interpersonal skills.
Basic ability to work independently and manage one s time.
Basic knowledge of logical data modeling and physical data modeling.
Basic knowledge of computer software, such as SQL, Visual Basic, Oracle, etc.

Education/Experience:
Associate's degree in computer programming or a relevant field required. Bachelor's degree preferred.
2-4 years experience required

Position s Contributions to Work Group:
Power BI report development and back-end SQL/Database/ETL support for TIS analytics projects

Why this Role?
The Technical Information Solutions?(TIS) team, within? Global Service (Americas Distribution Service & Marketing),?creates and delivers? the? technical? parts and service information? critical for the repair and service of Caterpillar products. Not a part gets sold, nor a machine or engine repaired,? without? using the? information created, managed, and delivered by? this? team.?

As a Data Engineer within the TIS Strategy and Commercial team, you will assist in the design, development, testing, and deployment of business analytics data for some of the most used applications at Caterpillar and across our dealer network. With over 200,000 users worldwide and 2 million page views every day, our systems are the backbone of dealer and customer product support operations. Through your expertise and insights, you will identify and interpret trends and patterns to influence strategic and application development decisions. This position also offers the opportunity to work with and influence our dealer network in their key service business decisions.

Typical task breakdown:
Develop and maintain Power BI dashboards, performing tasks such as report design, back-end development, data validation, front-end visualization, and publication with proper security credentials
Work with various business partners to understand data needs and devise the appropriate solution whether that is a dashboard, a one-time report, an automated report, or something else
Collaborate with the team to solve challenging problems and independently manage projects to meet expectations and deadlines from partners

Interaction with team:
Global team interacting with internal/external stakeholders

Team Structure
Three-person analytics team

Work environment:
Office facility

Education & Experience Required:
Years of experience: 2-4
Degree requirement: Associate's degree in computer programming or a relevant field required. Bachelor's degree preferred (or relevant experience).
Do you accept internships as job experience: No
Are there past or additional job titles or roles that would provide comparable background to this role: Business Intelligence Analyst, Data Scientist

Top 3 Skills
SQL fluency
Power BI or Tableau experience
Data pipeline design and architecture, with experience using common ETL tools

Additional Technical Skills Required:
Technical writing and documentation experience
Experience with common database/warehouse environments such as Snowflake, Azure, Oracle, DB2, PostgreSQL

Technical Skills Desired:
Python programming experience
UX/UI experience

Soft Skills Required
Excellent verbal and written communication skills, customer service, and problem-solving skills
Ability to work independently