Sr. Data Engineer
Posted on: 29 Jan 2021
Nashville, TN
Job Description
Career Area:
Information Technology
Job Description:
JOB SUMMARY:
Responsible for gathering business requirements and architecting solutions to create efficient data models that support self service as a strategic reporting and business intelligence initiative.
PRINCIPAL DUTIES AND RESPONSIBILITIES:
Responsibilities vary, but may include various combinations of the following duties.
1. Provides data mart development, integrations and/or support, including independently performing problem identification and resolution.
2. Ensure database designs efficiently support Business Intelligence and end user requirements
3. Collaborates with business partners to gather requirements for technical solutions and troubleshoots system related issues.
4. Analyzes and translates business needs into long-term solution data models.
5. Updates and optimizes metadata models.
6. Provides support and input to projects, including task planning and execution.
7. Enables and empowers business stakeholders to utilize self service Business Intelligence and reporting tools.
8. Works independently on projects that may span multiple functional areas.
9. Responsible for maintenance of data accuracy and integrity.
10. Identifies and works to automate tasks and processes with scripting and automation tools.
12. Ensures availability when necessary for off-shift and weekend support functions.
13. Incorporates enterprise security standards into functional area.
14. Understands the Harassment policy of the company and is responsible for its application in all aspects of employment.
JOB REQUIREMENTS:
SKILLS, ABILITIES, AND KNOWLEDGE:
1. Working ability to work independently or as part of a team.
2. Strong written and verbal communication skills
3. Prior experience working with financial data
4. Strong working knowledge of SQL and Business Intelligence tools (Business Objects/Tableau preferred)
5. Ability to Morph relational databases into fact and dimension tables using a star schema format.
6. Working knowledge of and ability to independently apply SDLC, ITSM or related methodologies.
7. Thorough knowledge of data warehouse design and implementing concepts of fact and dimension modeling.
8. Demonstrated ability to troubleshoot and recommend process changes that improve the overall implementation, maintenance and support of applications.
9. Demonstrated knowledge of and ability to apply basic math and data analysis skills.
10. knowledge of Data Warehouse Schema Design, Query Optimization, and Data Migration and Integration.
Desired Technical knowledge: SQL, Tableau, Business Objects, Snowflake, GITHUB, Active Batch
EDUCATION/EXPERIENCE:
A 4-year college or university degree in Information Technology, Computer Science or related field of study and a minimum of 3 to 4 years of enterprise technology experience is recommended. Equivalent experience may be substituted for education.
EEO/AA Employer. All qualified individuals - Including minorities, females, veterans and individuals with disabilities - are encouraged to apply.
Not ready to apply? Submit your information to our Talent Network here.
Caterpillar
Deerfield, IL
Caterpillar Inc. manufactures and sells construction and mining equipment, diesel and natural gas engines, and industrial gas turbines. Its Construction Industries segment offers asphalt pavers, compactors, cold planers, feller bunchers, harvesters, motorgraders, pipelayers, road reclaimers, skidders, telehandlers, and utility vehicles; backhoe, knuckleboom, compact track, multi-terrain, skid steer, and track-type loaders; forestry and wheel excavators; and site prep and track-type tractors.
The company’s Resource Industries segment provides electric rope and hydraulic shovels, draglines, rotary drills, hard rock vehicles, track-type tractors, mining trucks, longwall miners, wheel loaders, off-highway and articulated trucks, wheel tractor scrapers, wheel dozers, landfill and soil compactors, machinery components, electronics and control systems, select work tools, and hard rock continuous mining systems.
Its Energy & Transportation segment offers reciprocating engine powered generator sets; reciprocating engines and integrated systems for the power generation, marine, oil, and gas industries; turbines, centrifugal gas compressors, and related services; remanufactured reciprocating engines and components; and diesel-electric locomotives and components, and other rail-related products.
The company’s Financial Products segment provides operating and finance leases, installment sale contracts, working capital loans, and wholesale financing; and insurance and risk management products. Its All Other operating segment manufactures filters and fluids, undercarriage, ground engaging tools, fluid transfer products, precision seals, and rubber sealing and connecting components; parts distribution; integrated logistics solutions and distribution services; and digital investments services.
The company was formerly known as Caterpillar Tractor Co. and changed its name to Caterpillar Inc. in 1986. The company was founded in 1925 and is headquartered in Deerfield, Illinois.
-
IndustryManufacturing
-
No. of Employees104,000
-
Website
-
Jobs Posted1597
