Icon hamburger
US
What job do you want?
Apply to this job.
Think you're the perfect candidate?
Apply Now
Thumsup

You’re being taken to an external site to apply.

Enter your email below to receive job recommendations for similar positions.
Icm86d67xmkzmy8zysx

Data Engineer

Information Technology Group LLC Kansas City Full-Time
$11,800.00/ year
Apply Now

Data Engineer


Key aspects of this position include:

  • Provide production support of Extract, Load, & Transform (ELT) workflows
  • Support the acquisition and documentation of data\
  • Create and execute the ELT data pipeline for a columnar based data warehouse
  • Contribute to the design of new data warehouse components and/or data marts
  • Automate data quality processes

 

Key Activities:

 

  • Perform complex data migration tasks to transform, create new variables, and merge data.
  • Develop and support self-monitoring, robust, scalable data pipeline ELT jobs using Python/SQL and a combination of other languages to implement pre-defined business rules, quality checks and metrics, ensuring scalability and data quality in data warehouse processes
  • Ensure data pipeline ELT jobs are well tested and monitored
  • Conduct data profiling to ensure data quality and data integrity are maintained at all times
  • Provide documentation (Data Mapping, Technical Specifications, Production Support, data dictionaries, test cases, etc.) for all projects
  • Provision data structures such as fact and dimension tables and other objects as needed
  • Manage database supporting elements including schemas, tables, views, etc.
  • Manage permissions to ensure data accessibility, reliability and integrity
  • SQL Query development and Optimization
  • Data Modeling

Qualifications:

 

  • Bachelor’s degree from an accredited college or university in related field or equivalent combination of education and experience
  • 3+ Years writing PL/SQL procedures and functions
  • 3+ Years Unix/Linux/Python scripting
  • Ability to diagnose complicated data warehouse ETL processes, data flows and business logic failures, and quickly resolve issues
  • Strong performance-tuning skills
  • Strong understanding of dimensional modeling and other data warehousing techniques
  • Keen attention to detail
  • Good organizational, project management and problem-solving skills
  • Strong oral and written communication skills. Ability to explain complex technical information to technical and nontechnical contacts
  • Strong interpersonal skills, including the ability to work effectively in a team environment; motivate and work through others to accomplish tasks; and deal honestly and directly with others 

Skills: 

  • Proficient in SQL, Linux, Python, and Bash
  • Competent in Extract, Load, & Transform techniques
  • Competent in Data Analytics, Data Modeling, and Data Quality
  • Competent in git / code management

Recommended skills

Alu
Backhaul
Ip
Ip Aggregators
Microwave
Microwave Radio

Location

Salary Details

This salary was provided in the Job Posting.
$11,800
Yearly Salary
This salary is below the average salary range of $55,000-$165,000 for this role in this location
Apply to this job.
Think you're the perfect candidate?
Apply Now

Help us improve CareerBuilder by providing feedback about this job: Report this job

Report this Job

Once a job has been reported, we will investigate it further. If you require a response, submit your question or concern to our Trust and Site Security Team

CAREERBUILDER TIP

For your privacy and protection, when applying to a job online, never give your social security number to a prospective employer, provide credit card or bank account information, or perform any sort of monetary transaction. Learn more.

By applying to a job using CareerBuilder you are agreeing to comply with and be subject to the CareerBuilder Terms and Conditions for use of our website. To use our website, you must agree with the Terms and Conditions and both meet and comply with their provisions.