Previous Job
Previous
Data Engineer
Ref No.: 19-09272
Category: Experienced Professional
Location: Kansas City, Missouri
Position Type:Direct Placement
Start Date: 12/03/2019

Genesis10 is actively seeking a Data Engineer for direct hire fulltime opportunity.  The client is located in Kansas City, MO working within the financial industry. 
 
Overview:

  • Our Kansas City client is seeking a Data Engineer to provide data services with their (MPP) data warehouse
  • 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
Responsibilities: 
  • 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 
Requirements:
  • 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
  • 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
  • US Citizenship  or permanent residency is required
  • Must be local or willing to relocate to Kansas City, MO.
  • Sponsorship is unavailable for this opportunity. 
  • C2C candidates or 3rd parties will not be considered.   

If you have the described qualifications and are interested in this exciting opportunity, apply today!
 
About Genesis10:
Genesis10 is a Professional Technology Services Firm providing Staffing, Workforce Optimization and Domestic Outsourcing Solutions. If you are a high performing business or IT professional with solid, referenced experience, we want to meet you. Genesis10 recruiters and delivery professionals are highly accomplished career advocates, who get to know you beyond your resume to position you with the opportunities that fit your skills, experience and aspirations. We have benefit options to fit your needs and a support staff that works with you from placement throughout your engagement – project after project. To learn more about Genesis10 and to view all our available career opportunities, please visit us at www.genesis10.com  “Genesis10 is an Equal Opportunity Employer, M/F/D/V”