Data Engineer - Analytics

Client Resources, Inc. • Full-time • Omaha, NE, US • 2d ago

Senior Data Engineer-Analytics Group: Enterprise Technology Group

Division: Architecture & Development

I. SCOPE OF JOB: Under the direction and minimal guidance of the manager, designs, develops, tests, and maintains the scripts and jobs that are required to extract, transform, clean, and move data and metadata so that it can be loaded into a data warehouse, data mart, or operational data store. Mentors less experienced developers and serves as a project technical data lead for some data projects. Trains, coaches and mentors team members.

II. Preparation Required

Bachelor’s degree in Computer Science, MIS or related field with 8 years of experience or Master’s with 6 years of experience or an equivalent combination of education and experience is required.
Experience required in data warehousing or operational data stores, relational database management systems or multi-dimensional database management systems.
Post graduate degree or coursework a plus.

III. Customer Focus & Impact

It is our goal to exceed our customer’s expectations for the products we market and the services we provide. This must be accomplished for the Company to be successful. Every employee must understand this goal and how their job assists the Company in its achievement. Further, the accuracy and timeliness of the information produced will have a direct impact on critical corporate decisions on products we market and customers we market to. For this position this means:

Focus: To ensure accurate, timely and actionable information is produced by utilizing the appropriate data warehousing architecture, implementing appropriate data marts and data lake implementation, as well as supporting structured/semi-structured file transformation.

Standards: Ensures data warehousing and operational functionality is consistent with the overall Corporate Data architecture.

IV. Conditions Of Work And Quantifiable Data

Physical Environment: Standard office environment; approximate PC use (over 90%).
Travel: Travels out of town to attend seminars, workshops, etc. (1 to 2 times per year).
Work Schedule: Standard work schedule (40.0 hours per week). Will be required to be on-call evenings and weekends on an assigned basis. May need to work in excess of standard work schedule.

V. JOB QUALIFICATIONS (Knowledge, Skills, Abilities And Personal Characteristics)

Strong experience in data engineering with a total of 8 years’ experience using ETL tools such as Informatica, DataStage or ELT tools such as DBT.
4 - 6 year’s experience with programming languages such as Python or Shell scripting is essential.
6 - 8 years of SQL programming.
2 - 4 years of Snowflake, Databricks, Redshift or similar cloud data warehouse technology required.
2+ years of experience developing or deploying data solutions in any cloud such as AWS, Google or Azure required.
5 - 6 years of Demonstrated knowledge of designing dimensional modelling or relational data modelling or 5-6 years of Demonstrated experience using Data Warehousing data population techniques.
6 - 8 years of Demonstrated experience of source to target mappings.
6 - 8 years of Demonstrated experience relational database knowledge; possesses a broad understanding of the current and prospective data architecture, and database performance tuning.
Strong verbal and written communication skills. Has ability to establish and maintain effective working relationships with external and internal personnel. Must be customer focused and excel in coordination of problem resolution.
Flexibility to work in a changing, fast-paced environment and work with a sense of urgency and accountability.
Experience with Agile methodologies is desirable.
Ability to effectively provide work direction to team members and delegate tasks; ability to train, mentor and provide constructive feedback to team members to meet or exceed performance in their job responsibilities.
Demonstrated project management skills are desirable.

VI. Summary Of Duties

1/15% DATA ANALYSIS

Maps source system data to data warehouse models or other file transformations (source to target mappings).
Works with program delivery and business team members to understand source systems data and data quality.
Performs data quality analysis.
Defines and captures rules associated with ETL processes.
STANDARDS: Data quality issues and risks are identified and mitigated early in the development cycle.

2/25% DATA DESIGN

Creates ETL processes / Data pipelines and is responsible for creating and maintaining High Level Design documents.
Employs cost effective techniques in design of ETL processes / Data pipelines to meet immediate and future business needs.
Conducts Data pipeline design / sizing estimates for data projects or other file transformations
Designs data solutions to satisfy business information needs and receive design acceptance.
STANDARDS: ETL processes comply with standards and architecture.

3/30% ETL DEVELOPMENT AND TESTING

Develops complex ETL processes.
Creates ETL processes that supports business functionality, performs well, and is easily supported.
Creates scripts when necessary.
Follows ETL standards, goals, and objectives.
Works with teammates to define and resolve complex data warehouse or file transformation project issues.
Adapts extraction, transformation, and load (ETL) processes to accommodate changes in source systems and new business user requirements
Completes work according to the iteration plan or release plan.
Participates in ETL Code Reviews, receives acceptance of code by peers at review. Responsible for code reviews for other developers.
Tests (unit level, integration level, system level, and user acceptance level) complex ETL processes / Data pipelines.
Works with testing team in order to assist them with their testing processes.
Assists with testing upgrades; identifies errors or inconsistencies with vendors’ software applied to Company’s data environment.
STANDARDS: ETL processes /Data pipelines are developed according to project schedule with a high level of quality.

4/20% ETL CHANGE/CONFIGURATION MANAGEMENT AND PRODUCTION SUPPORT

Follows Change Management/Configuration Management processes for the deployment of code into test and production environments.
Troubleshoots data problems. Identifies, coordinates and helps resolve the root cause of day to day data production issues.
Supports client areas in their analytical functions; corrects errors/resolves problems associated with data warehouse processes and other file transformations.
Provides rotational on-call support, responding quickly to production issues.
STANDARDS: ETL code is moved according to the standard process and all development audit points are delivered. Production systems are given the priority needed to keep them stable and issues are resolved quickly.

5/10% TRAINS, COACHES AND MENTORS TEAM MEMBERS

Works collaboratively with the application development resources, all data team resources, systems analysts, and with client areas.
Leads teammates to define and resolve complex data warehouse or file transformation production issues.
Develops relationships though a team environment by creating vertical and horizontal communication avenues to ensure cooperative efforts are established.
Train, mentor and coaches staff to perform their responsibilities by providing processes, tools and deliverables related to their job. Acts as a subject matter expert to the team.
Assists team members with complex and critical tasks and determines the impact to existing systems. Makes formal recommendations to manager.
Ensures alignment between corporate and ETG goals, Business Council prioritization, and the work that his/her team performs.
STANDARDS: Team relationships are essential in a fast-paced, Agile environment. Verbal and written communication skills assist in these team relationships. Coaching and mentoring is provided in such a way that encourages long term learning. Simply providing solutions to problems must be balanced with providing enough direction to enable peers to discover solutions on their own. In addition, project quality and schedule must also be considered in this balance.

Performs other duties as assigned.

Never Miss a New Opportunity

Subscribe and get the latest jobs directly to your inbox

Get a

email of new

jobs

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Related Jobs

Senior Data Engineer

Mosaic • Full-time • Omaha, Nebraska, United States • $103.48k - $139.85k / year • 7h ago

Data Engineering

7h ago

Apply

Data Engineer

Farm Credit Services of America • Omaha, Nebraska, United States • $112.14k - $173.82k / year • 6d ago

Data Engineering

6d ago

Apply

Sr. Data Engineer, Data Engineering

CONAGRA • Full-time • Omaha, Nebraska, United States • $93.20k - $135.70k / year • 3w ago

Data Engineering

3w ago

Apply

Data Engineer

CONAGRA • Full-time • Omaha, Nebraska, United States • $72.50k - $107k / year • 1m ago

Data Engineering

1m ago

Apply

Sr. Data Engineer, Palantir

CONAGRA • Full-time • Omaha, Nebraska, United States • $93.20k - $135.70k / year • 1m ago

Data Engineering

1m ago

Apply

Senior Data Engineer

Emergent Software • Full-time • Remote (Omaha, Nebraska, United States) • $115k - $150k / year • 2m ago

Data Engineering

2m ago

Apply

Data Engineer - Palantir

CONAGRA • Full-time • Omaha, Nebraska, United States • $72.50k - $107k / year • 2m ago

Data Engineering

2m ago

Apply

Data Engineer I

WoodmenLife • Full-time • Omaha, Nebraska, United States • $74.67k - $129.60k / year • 2m ago

Data Engineering

2m ago

Apply

Analytical Frameworks

General Dynamics Information Technology • Full-time • Offutt A F B, Nebraska, United States • $148.75k - $201.25k / year • 1d ago

Data Science

1d ago

Apply

Secure AI/ML Delivery

General Dynamics Information Technology • Full-time • Offutt A F B, Nebraska, United States • $148.75k - $201.25k / year • 5d ago

Data Science

5d ago

Apply