Senior Engineer, Software

Must Have:PythonSnowflake Cortex AISQLJOB DESCRIPTIONMax Bill Rate: ***Location: RemoteInterview Process: Video Teams MeetingJob SummaryThe Data Engineer/AI Engineer will be responsible for developing ETL and data pipeline using AWS, Snowflake, Snowflake Cortex AI & DBT. The ideal candidate is an experienced data pipeline builder using ELT methodology . They must be self-directed and comfortable supporting the data needs of multiple teams, systems, and products.Essential Duties and ResponsibilitiesBuild the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using Cloud Integration ETL Tools, Cloud Data Warehouse, SQL, and AWS technologies understanding of REST API GraphQL.Design and develop ELT, ETL, Event drivern data integration architecture solutionsWork with the Data Analysts, Data Architects, BI Architects, Data Scientists, and Data Product Owners to establish an understanding of source data and determine data transformation and integration requirementsTroubleshoot and tune complex SQLUtilize On-Prem and Cloud-based ETL platforms, Cloud Datawarehouse, AWS, GitHub, various scripting languages, SQL, querying tools, data quality tools, and metadata management tools.Develop data validation processes to ensure data qualityDemonstrated ability to work individually and as a part of the team in a collaborative mannerQualificationsThe requirements listed below are representative of the qualifications necessary to perform the job.Education and ExperienceBachelor's degree (or foreign equivalent) in Computer Science, Computer Engineering, or a related field.8+ years of experience with Data Engineering, ETL, data warehouse/data mart development, data lake developmentAdvanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.Experience working with Cloud Datawarehouse like Snowflake, Google BigQuery, Amazon RedshiftExperience with AWS cloud services: EC2, S3, Lambda, SQS, SNS, etc.Experience with Cloud Integration Tools like Matillion, Dell Boomi, Informatica Cloud, Talend, AWS GlueExperience with GitHub and its integration with the ETL tools for version controlExperience with Informatica PowerCenter, various scripting languages, SQL, querying toolsFamiliarity with modern data management tools and platforms including Spark, Hadoop/Hive, NoSQL, APIs, Streaming, and other analytic data platformsExperience with object-oriented/object function scripting languages: Python, Java, Scala, etc., a plus.Experience with Agile/Scrum is valuable.Other Knowledge, Skills, or Abilities RequiredMust Speak English.Ability to work with business as well as IT stakeholders.Strong written and oral communication skills with the ability to work with users, peers, and management.Strong interpersonal skills.Ability to work independently and as part of a team to successfully execute projects.Highly motivated, self-starter with problem-solving skills.Ability to multitask and meet aggressive deadlines efficiently and effectively.Extraordinary attention to detail and accuracy.