### Job_Dedcrip:
Our direct client is looking to hire TWO Data Engineers for their Data Analytics Team for a "direct hire/perm" role.....This is a REMOTE role, however, the client wants someone who lives within 2-hours of Overland Park, Kansas.....Must be located within 120 miles of Overland Park, Kansas   Full-Time/Direct Hire Role...Working for the largest food wholesaler to independently owned supermarkets, serving over 1,100 member companies and over 3,400 locations throughout 31 states from 9 wholesale Divisions. The consolidated sales are $10.8 billion...Working with a GREAT BOSS and team!!....Client is transforming their business intelligence, Analytics and Data Automation Capabilities...They want to level up data warehousing and data management capabilities, including curated and cleansed data sets, certified data models and sources...We are adapting to cloud-based data automation for data cleansing, extraction, loading, and transformations...Another goal is to expand storage and compute capacity for ingestion of structured and unstructured data. In addition, we are hardening security constraints, in the areas of role-based access, anonymized data sets and intrusion prevention constraints....As a Data Analyst/Engineer on the Data Analytics Team, you will be integral on this journey...Your primary area of responsibility will be building a strong data ecosystem which supports a new company-wide business intelligence and analytics environment...You will assist in the design and development of standardized datasets derived from multiple systems of record...A key area of success for this role is developing or applying existing development and scripting skills in process automation to orchestrate data pipelines from business systems, data lakes and third-party data repositories...You will be creating and loading dimensional models that will be used for analysis and reporting. As you work on projects and enhancements you will assist in refining data governance within business processes and the technical tool chain. A key to success in this role is to quickly learn the meaning of business data and understand the business domain. Your skills will be leveraged to accurately identify key data and build the system processes which will extract, transform, and load the data that is used in key business decisions......___________________________________________________-....Position Requirements:..Must be able to read/write SQL in one or more of the following environments (SQL Server, Oracle, DB2).   Must have completed at least one full cycle of building a data lake and/or a data warehouse.   Experience working with one or more columnar storage systems (Snowflake, Redshift, Big query, etc).   Experience working in cloud data environments (AWS, Azure).   Knowledge and skills with Power BI will be important, not critical.   Exposure to data streaming tools and technologies like Kafka, TensorFlow or similar.   Strong business communications skills for requirements gathering and development.......Qualifications:.(May have some Wiggle room for the below skills):...5+ years overall data warehouse and/or data lake methodologies, and data solution deliveries.   5+ years of experience as a data engineer and/or software engineer.   3+ years of experience building ETL processes   3+ years of experience working with AWS or Azure workflow orchestration tools   Bachelor's Degree or equivalent professional experience....Position Responsibilities:....Collaboration/Communication (25%)..Work directly with Project Management and Manager in communication of planning, status reporting, issue notification and resolution.   Collaborate with business teams to identify data models and data sets for analytical consumption.   Mentor/Lead lesser experienced engineers.   Take ownership of deliverables.   Practice and contribute to the standard solution deliverable model.....Development (50%)..Build real-time and batch data integrations from disparate source systems into the data lake/data warehouse.   Build and maintain scalable ETL processes using workflow automation tools.   Provide documentation for installations and deliverables.   Design dimensional models and be able to cleanse and transform raw data into structured format.   Administer and maintain data pipelines used for loading data into the data warehouse or Lakehouse.   Scale and tune data pipelines, data sets and SQL queries.   Responsible for Unit testing, support of Integration testing and User Acceptance Testing...Support (15%)..Provide on-call production support for integration and transformation pipelines, legacy systems, and modernization.   Maintain documentation for legacy systems, pipelines and modernization implementation...Development Governance (10%)..Follow defined data governance framework and enterprise data models.   Apply standard methodologies to analyze, design, develop, test and deploy data management solutions.   Participate in agile story authoring, sizing, and demo sessions for developed features.   Participate in code reviews and provide feedback to the team.....PLUS SKILLS ONLY:.....Nice To Have:...Proficiency with Excel including building macros.   Worked with or built Data Lakes, Data Warehouse in a hybrid environment (cloud / on-premises).   Experience working with CRM systems like Salesforce.   Experience with end-to-end supply chain or merchandising.   Experience working in an IBM DB2, SQL Server or Oracle environment.   Experience working with Analytical Tools/Languages (SAS, Python, R, Spark, etc.)....For immediate consideration please respond with your resume in Word format, along with daytime contact information....Client is unable to provide H-1B Visa sponsorship at this time. All submittals will be treated confidentially. Selected candidate may be asked to complete a comprehensive background, credit and/or drug screening. Principals only, no third parties please...""

### Response:

Position Requirements:- Must be able to read/write SQL in one or more of the following environments (SQL Server, Oracle, DB2).- Must have completed at least one full cycle of building a data lake and/or a data warehouse.- Experience working with one or more columnar storage systems (Snowflake, Redshift, Big query, etc).- Experience working in cloud data environments (AWS, Azure).- Knowledge and skills with Power BI will be important, not critical.- Exposure to data streaming tools and technologies like Kafka, TensorFlow or similar.- Strong business communications skills for requirements gathering and development.Qualifications:- 5 years overall data warehouse and/or data lake methodologies, and data solution deliveries.- 5 years of experience as a data engineer and/or software engineer.- 3 years of experience building ETL processes- 3 years of experience working with AWS or Azure workflow orchestration tools- Bachelor's Degree or equivalent professional experience.Position Responsibilities:- Collaboration/Communication (25%)- Development (50%)- Support (15%)- Development Governance (10%)Plus Skills Only:- Proficiency with Excel including building macros.- Worked with or built Data Lakes, Data Warehouse in a hybrid environment (cloud / on-premises).- Experience working with CRM systems like Salesforce.- Experience with end-to-end supply chain or merchandising.- Experience working in an IBM DB2, SQL Server or Oracle environment.- Experience working with Analytical Tools/Languages (SAS, Python, R, Spark, etc.).