KBR IT Application Developer – ETL in Houston, Texas
Title: IT Application Developer – ETL
Job Number: 1054336
KBR COMPANY INFORMATION
When you become part of the KBR team, your opportunities are endless. As a leading global engineering, construction, and services company, we support the hydrocarbon and government services markets on six continents. Serving our customers through diverse business units, we offer challenging assignments on some of the world's largest and most complex projects where our customers have come to value us, because they know We Deliver.
With operations in 40 countries, KBR has more than 25,800 people delivering services to customers in over 80 countries. Together they represent an unmatched reservoir of talent and experience in a wide range of markets.
Join us and you'll be part of a dynamic, elite team of professionals who understand what it takes to get a job done and has the experience, knowledge and determination to succeed.
IT Application Developer – ETL
Position Description/Job Responsibilities
Under broad direction, often works independently and provides leadership for others functions in a senior role in ETL technical design, development, enhancement and maintenance, including preparation of requirements, specifications, estimates, unit testing, code reviews and technical documentation.
Lead or participate in the development and management of Information Architectures that meet requirements for Business Intelligence (BI) solutions; work closely with database administrators, ETL and reporting personnel to develop/use a data model throughout the whole life-cycle.
Perform data analysis and modeling for development and maintenance projects; participate in the development of standards and procedures affecting Information Management; assist in the development of task lists, project plans, and workload estimates; and provide hands-on database development and support of the physical data model. They will participate in walkthroughs of work products such as data models, implementation architecture, documentation, etc.; perform impact analysis for requested changes or additions to data structures; and consult with end-users and applications development staff to ensure conformance or recommend updates to established architectures. They will also work both independently and collaboratively within one or more project teams; and will follow established departmental standards, procedures and guidelines.
Development, maintenance, and/or support of one or more applications in an assigned technology, major system, or functional area. Participation in and providing leadership for analysis leading to requirements/specifications, estimates, and system designs for applications.
Performing and overseeing programming, quality assurance reviews, documentation, system deployment, training, and project setup/support.
Performing project setups, analyses, designs, etc., for/with customers. Similar duties are often associated with the selection, acquisition, installation and configuration of applications licensed from third parties, and interaction with vendors is required.
Interpreting and applying directions originating at a higher level.
Assistance in supervision or mentoring of staff; allocating and monitoring work.
Prepares development hours and cost estimates.
Provides input to development project plans.
Development of Data Models and processes
Conceptual schema: Understand and design of the Conceptual schema including the semantics of a domain being the scope of the model its entity classes, and relationships assertions about associations between pairs of entity classes.
Logical Database: Logical Database design which includes: Clarifies functional specifications and avoids assumption, Confirms business requirements, Facilitates business process improvement, Focuses on requirements independent of technology, Decreases system development time and cost, Facilitates data re-use and sharing, Foster seamless communication between applications, Establishes a consistent naming scheme
Build specifications for extract, transform, and load processes, following standards for Informatica to facilitate the data mart/warehouse fact and dimension models.
Work with business to design specific subset of warehouse data for producing analytical data stores. Understanding elements of the data warehouse and facilitating the build of a warehouse to produce data marts that meet the business requirements.
Responsible for time scheduling, properly building jobs with appropriate failure notifications, and properly maintaining adequately documented run books of the jobs.
Review business requests for data design and data usage. Avoid redundant extracts by understanding gap analysis of available data and working to build interfaces for new data.
Work with business to gather/analyze requirements to determine extent of reporting and/or interface needs.
Ensure warehouse and database functions in accordance with Data Governance policies as set forth by KBR policies and standards.
Collaborate with cross-functional teams to design solutions.
Maintain proper metadata tools in order to perform proper usage and impact analysis.
Perform data queries for analysis by understanding existing warehouse structures and being able to answer user questions regarding the data.
Coordinate new data development which includes the creation of new structure to meet business requirements or streamline existing processes to reduce overhead on the existing warehouse.
Ensure consistency with existing databases and warehouses, enforcement of standards and consistent processes.
Work with the release management team to ensure that proper change management process is performed, as well as planning deployment timelines to avoid emergency migrations.
Define and recommend BI standards, processes and technologies.
Researching and recommending software technology direction.
Provide after-hours support as needed.
Bachelor’s degree in Computer Science / Computer Information Systems or related field or extensive applicable experience.
A minimum of 2 years of experience working with enterprise data warehouse projects.
Strong understanding of data analysis, data and process modeling and relational database concepts.
Excellent organizational, oral, written, and presentational communication skills in order to work with all levels of staff and management.
Extensive data warehousing/business intelligence development and architecture experience.
Extensive experience designing relational (conceptual, logical, physical) and dimensional data models for data warehouse/business intelligence.
Extensive experience deploying and supporting large, complex data warehouse/business intelligence solutions.
Extensive experience with system integrations.
Extensive experience with Informatica PowerCenter.
Experience with Embarcadero or Erwin data modeling tools.
Experience with SQL Tools such as Toad/SQL Navigator.
Experience with Automic (UC4) Scheduler.
Extensive experience working with Oracle and Microsoft SQL Server databases.
SQL query and performance tuning.
Experience with project planning and management, including making operational decisions, monitoring progress, taking corrective action, and communicating results.
Candidate must have a strong customer service orientation.
KBR offers a selection of competitive lifestyle benefits which could include a 401K plan with company match, medical, dental, vision, life insurance, AD&D, flexible spending account, disability, paid time off, or flexible work schedule. We support career advancement through professional training and development.
KBR is an equal opportunity employer.
All qualified applicants will receive consideration for employment without regard to race, color, religion, disability, sex, sexual orientation, gender identity or expression, age, national origin, veteran status, genetic information, union status and/or beliefs, or any other characteristic protected by federal, state, or local law.
Job: Information Technology