Career Area:
Information Technology
Job Description:
About Caterpillar
With 2021 sales and revenues of $51 billion, Caterpillar Inc. is the world's leading manufacturer of construction and mining equipment, diesel and natural gas engines, industrial gas turbines, and diesel-electric locomotives. Since 1925, we've been driving sustainable progress and helping customers build a better world through innovative products and services. Throughout the product life cycle, we offer services built on cutting-edge technology and decades of product expertise.
About SPM Oil and Gas
SPM Oil and Gas provides superior products and service solutions to Oil & Gas customers in upstream, production, transportation, refining, and related industries. The team works hard to create lifelong customer relationships, supplying comprehensive product & service solutions for the Oil & Gas industry, and setting the standard for excellence in the segment.
The BI Developer will work on the BI team to help develop BI solutions to meet business requirements. They will contribute to the design, development, deployment, support, and documentation of BI solutions. The candidate will be expected to work with both onshore and offshore team.
Key Responsibilities and Specific Accountabilities: Including but not limited to:
Work with internal/external team.
Help in the design and implementation of enterprise analytics and performance management solutions in a complex enterprise environment.
Contributes to the designing, configuring and deploying enterprise performance solution using the Microsoft SQL Server analytics technology stack.
Contributes to the data architecture and data integration with dimensional data modeling, data sourcing / mapping, and data flow within the implemented solution.
Responsible for analyzing business/data requirements, estimate, and perform data preparation.
Ability to think strategically about business, product, and technical challenges.
Support operational monitoring, maintenance, and troubleshooting for the Microsoft SQL Server & Cognos analytics platforms.
Problem solver with the desire and proven ability to create innovative solutions.
Excellent communication, organization and interpersonal skills.
Ability to manage and prioritize multiple tasks and remain flexible to changing requirements.
Additional duties as assigned by manager.
Basic Qualifications:
Bachelor's degree in Management Information Systems, Computer Science, Software Engineering, or equivalent experience
3+ years of Cognos experience
3+ years of Power BI experience
Requires 3+ years of BI experience utilizing a variety of technologies.
3+ years of relevant experience in planning and delivering enterprise-wide analytics and data warehouse solutions using proven solution delivery methodology frameworks and best practices.
Familiar with data warehousing, ETL, DAX.
Knowledge of Azure Data Factory, Azure Automation, Azure Data Lake and Azure Data Lake Analytics.
Data analysis skills, Dimensional Modeling, experiences in designing Star Schemas.
Working knowledge and experiences in data design / dimensional data modeling.
Working knowledge and experiences in SSIS, SSRS, SSAS and SQL Server development tools.
Top Candidates Will Also Have:
Experience with Agile and DevOps methods desired.
Familiar with software development life cycle.
Experience in the oil or fracturing industry is a major plus.
Preferred location is Forth Worth, TX. Other locations may be considered.
Relocation assistance is not available for this position. Any relocation costs incurred would be the responsibility of the selected applicant.
This employer is not currently hiring foreign national applicants that require or will require sponsorship tied to specific employer, such as H, L, TN, F, J, E, O. As a global company, Caterpillar offers many job opportunities outside of the U.S. which can be found through our employment website at ww w .caterpilla r .com/careers #LI
EEO/AA Employer. All qualified individuals - Including minorities, females, veterans and individuals with disabilities - are encouraged to apply.
