For the given job description <<Title: Sr. Data EngineerLocation: Austin, TxDuration: 6 MonthsPay Rate: $65HR - $70HR on W2
Requirements:Bachelors degree in Computer Science or related field plus 4+ years of relevant work experience or a Master's degree plus 2+ years of relevant work experience or a PhD plus 0-1 years of relevant experienceIn lieu of a degree, qualified candidates would require 8+ years of relevant professional experienceExcellent with SQLExcellent programming skills in Python and ideally demonstrating an aptitude via experience with multiple languagesExcellent understanding of patterns for data ingest into data warehouse, ingest, cleansing, standardizing, etc., in addition to different data structures like normalized, denormalized, starExcellent experience supporting Snowflake Data Warehouse, including Snowpipe (including streams), tasks, transformations, views, dynamic tables. This should include advanced skills in ensuring efficient utilization of Snowflake compute and the ability to optimize workloads and warehouseBroad experience with Cloud PaaS capabilities, ideally AWS CloudWatch, Lambda, Step Functions, SNSSQS, DynamoDB, etc.Experience utilizing reporting and data insights toolsExperience in supporting analytics teams data needs, in addition to customer and business reporting.
What you'll be doing:Provides Data Engineering support for areas such as Finance, Sales, Business Intelligence, Product Development andor other business usersWorks with data consumers and Project Managers to determine logical and physical database designs for analytics modelsCreates and maintains optimal data pipeline architecturesEnsures architectures are aligned with and support business requirements;Ensures that required data is available, can be trusted and is readily accessible by those who need itInfluences the data infrastructure roadmapIdentifies, designs and implements internal data management process improvementsPlays a key role in application development projects to evolve the companys database architecture and designWorks with internal and external data providers on data validation, providing feedback and making customized changes to data feeds and data mappings for analytical and operational useAutomates manual processes, transforming them into repeatable capabilitiesWorks with fellow team members to ensure design, development and execution align with and support adjacencies and adhere to established architectural standards.
Top 5 Must Haves:Excellent with SQLExcellent programming skills in Python and ideally demonstrating an aptitude via experience with multiple languagesExcellent understanding of patterns for data ingest into data warehouse, ingest, cleansing, standardizing, etc., in addition to different data structures like normalized, denormalized, star;Excellent experience supporting Snowflake Data Warehouse, including Snowpipe (including streams), tasks, transformations, views, dynamic tables. This should include advanced skills in ensuring efficient utilization of Snowflake compute and the ability to optimize workloads and warehouseBroad experience with Cloud PaaS capabilities, ideally AWS CloudWatch, Lambda, Step Functions, SNSSQS, DynamoDB, etc.
Thank you!>> the resume: <<SummaryI am an Automation Developer with a love for troubleshooting and electronics. This passion for automation started at Micro Center in 2017, where I began finding ways to simplify my reports to upper management. These reports took several hours to compile and took the time I could have spent guiding my agents. Eventually, I started finding ways to gather that data through an API. After discovering I could collect this information and use APIs to simplify tasks, I started programming software to do these things. This new skill helped change how I approached my team's problems & complaints and eventually led to me creating tools to improve our efficiency and productivity. Since then, my passion has grown into a career that keeps me wanting to learn more.
SkillsSystems Engineering & Lab Test TechnicianCybersecurityData EngineeringAPI Design & DeploymentSoftware Developer (Python, NodeJS, PHP, Bash, Git, Etc)Automation & Disaster Recovery
ExperienceData Engineer,06/2021to11/2023Bank Of America Corporation–Aurora,IL,Deployed Linux cloud servers and applications to meet the needs of the company (PostgreSQL, Metabase, Apache Spark, TableAU)Secured servers and applications using ACLs/ﬁrewalls/IDS/IPS and following standard security practicesBuilt several ETLs in Python/PHP/JavaScript for several ticketing platformsDesigned disaster recovery plans for our systemsConstructed complex SQL queries to aid in reporting and automationTested data regularly to ensure accurate reportingManaged several PostgreSQL databasesAutomated reports and redundant tasks through the use of APIs and databasesCreated and implemented complex business intelligence solutions.Created conceptual, logical and physical data models for use in different business areas.Adept in troubleshooting and identifying current issues and providing effective solutions.Managed performance monitoring and tuning while identifying and repairing issues within database realm.Identified, protected and leveraged existing data.Planned and installed database management system software upgrades to enhance systemic performanceTest Engineering Technician,08/2020to06/2021General Atomics–Houlka,MS,Traveled daily to integrators to provide quality assurance for PowerSpec systems and review the build processCompiled reports for integrators to log and classify defectsAnswered product questions for PowerSpec systemsRegularly assisted neighboring departments on build projects and quality controlled parts for buyersWorked directly with vendors for BIOS updates and patches on PowerSpec systemsCreated and deployed system images for PowerSpec productsBuilt extensive QC reports through rigorous testing methodologies, including benchmarking components and testing for compatibility.Performed problem solving and resolution for technical quality, inspection and customer quality issues.Developed and maintained solutions for integration and testing phases.Tested functionality, performance and compliance of each product against design specifications to maintain strong development standards and high customer satisfaction.Completed unit and regression tests on software and individual modules.Created and optimized automated testing tools for repetitive tasks.Created and maintained database of common and known testing defects.Worked with off-site teams to complete timely tests and facilitate smooth product releases.Promoted high customer satisfaction by resolving problems with knowledgeable and friendly service.Call Center Lead,01/2019to08/2020Metlife–Omaha,NE,Encouraged team members to improve productivity and service levels by modeling correct behaviors and coaching employees.Resolved team support issues with efficient approach to keep call center operating smoothly and customers satisfied with services.Routinely updated guides to reduce questions on the ﬂoorProvided accurate and detailed reports for managementHandled customer escalations and ensured they went to the appropriate teamMaintained Zendesk and the ticketing procedures to ensure both a smooth and efficient experience for my agentsWorked with management to update legacy procedures and remove redundant processes through automationManaged customer concerns with calm demeanor and knowledgeable service.Created an efficient workflow in order to provide a better experience for consumersKept records of customer interactions or transactions, thoroughly recording details of inquiries.Worked directly with stores and customer relations team to improve customer retentionBuilt and maintained call center server to house reports and automationsTechnical Consultant,09/2017to01/2019Applied Systems, Inc.–University Park,IL,Troubleshot and resolved problems with programs and systems.Utilized knowledge of applications, programming and systems functionality to assist employees with technical needs.Assisted customers with various types of technical issues via email, live chat and telephone.Handled customer service issues by providing guidance or escalating for advanced support.Served as first point of contact for escalated technical service calls, emails, and live chat.Troubleshot hardware issues and worked with service providers to facilitate repairs for end users.Developed and maintained strong relations with customers to meet quality expectations.Documented customer complaints and inquiries for use in technical documentation and bug tracking.Reviewed support cases for technical and troubleshooting accuracy and identified needed process improvements.Maintained up-to-date case documentation for future reference.Demonstrated advanced product knowledge to solve customer issues.Delivered remote assistance for technical issues using screen sharing, mouse and keyboard control and other tools.
Education and TrainingHigh School Diploma:Electronic Classroom,Expected in06/2012toElectronic Classroom of Tomorrow-Columbus, OH,GPA:>>. The result is, 

Fit assessment: Good Fit