Job description:
role: lead data engineerlocation: remoteduration: long term 8 to 10 years of experience working in data engineering, business intelligence or related field delivering large scale data platforms and services. ideal candidate will have the following skills: a successful history of manipulating, processing and extracting value from large, disconnected datasets. expertise in data modeling, data access and data storage techniques. the candidate should have foundational knowledge of dimensional modeling to build a data warehouse strong experience building transformational logic using sql on relational sql and nosql databases. skills using dbt framework for data transformation is plus robust programming skills and strong experience with python to ingest, transform and load the data experience building and optimizing big data data pipelines, architectures and data sets using tools like airflow. experience with aws cloud services: ec2, emr, rds, redshift

Resume:
<<professional summaryhaving been employed with cps energy for the past 9 years and just recently receiving my bachelor's degree, i am ready to advance my career within the company. i am highly motivated and determined to obtain a position at cps energy that enables me to utilize and maximize my experience for advancement in the company. skill highlights-course completion, experience, and proficient in microsoft word, excel, access, power point, windows, office, and works -filing and organizational skills -proficient on 10-key keyboard ­excellent customer service skills and experience -data entry and efficient typing skills -efficient performance of any/all assigned duties -self developed in organization and time management professional experience 01/1tocurrentdata control clerklake charles memorial hospital– ,duties and responsibilities include: -daily completion of accelerated gas and electric work orders in work manager -take applications for customers requesting new electric and/or gas service -collecting payment from customers for new services -creating work request orders in sap, work manager, and online in the cps energy web portal -communicate by phone and email with foremen, home builders, customer service representatives, and cps energy customers on a daily basis -assisting builders and developers with the customer engineering process -research account information in sap database -research address information and job status in sap and work manager -interpret construction schedules and any needed information to customers -review plats for residential gas and electric meter locations -enter and complete ciac for construction orders in work manager -monitor reports in work manager to ensure construction jobs are completed in a timely manner -monitor and print notifications in sap for residential representatives duties and responsibilities include: ­dispatch gas leak repair crews, gas troublemen, gas meter shop, and welders to emergency/routine work by phone, radio, and computer -verify and obtain city and txdot permits -communicate with formen, troublemen, customer service representatives, and cps energy customers on a daily basis -create orders in the sap and mobile data database -data entry of daily paperwork -maintain databases for the leak repair department -create, complete, and submit texas railroad -commission damage reports for third party damages -submit monthly reports to our analyst of completed gas orders -check/verify troublemen meter removals, replaces, and installations -run daily reports in the cognos database for supervisors -create weekly route sheets for the gas troublemen -research account information in the sap database -relief substitute for the leak survey, pressure control, and gas meter shop departments -coordinate cps energy repair jobs with various utility companies -coordinate utility locates through digtess for emergency and routine work orders -replenish office supplies as needed duties and responsibilities include: -entered daily timesheets for the leak survey, gas services, leak repair, pressure control, gas meter shop, tool repair shop, welders, and gas inspector departments. timesheets were entered through the sap system using zcat and cat2 -monitored the weekly 40 hour and 80 hour time entry reports and corrected any errors or discrepancies -resolved timesheet and paycheck descrepancies for field representatives -maintained databases for the leak repair department for leak survey orders, work requests, and other various documents -completed meter removal/meter replacement cards through mobile data and mobile dispatch systems -retrieved daily leak repair job packages from service districts and the engineering department through the work manager database -obtained and verified permits from the city of san antonio and txdot -obtained and verified micro-station job sketches -communicated with planners and engineers on a daily basis inquiring on status of jobs and finding resolutions so that job packages are completed in a timely manner -scheduled appointments for job packages with cps energy customers that require work with plumber orders ­completed tasks in the work manager database and entered as­built information when closed out work orders for job packages that have been completed by in-house crews and contractors. -created service entry sheets for payment invoices from contractors through the sap business workplace system. including verification of bonds and retainages -reported monthly to analyst completed gas installation and services for the in-house crews and contractors -relief substitute for leak survey, pressure control, and leak repair dispatcher -replenish office supplies as needed 04/2004to 07/2005customer service representativelynden incorporated– ,duties and responsibilities include: -completed car rental agreements -performed vehicle inspections for returned cars -provided telephone customer service including rental reservations, answering questions and complaints, assisting customers during rental car breakdowns and accidents -detailed/cleaned returned vehicles when needed -assisted managers with inventory of vehicles -repossessed delinquent rental vehicles when required -delivered rental vehicles to customers at their hotels & body shops -research for competitive prices of our competition -helped with general office duties when needed education and trainingexpected intotobachelor of arts:psychologytexas a&m university-san antonio,txgpa:bachelor of arts: psychology 12/2013 texas a&m university - san antonio － skills customer service, receptionist, retail sales, basis, database, sap, plats, web portal, databases, dispatch, dispatcher, office supplies, txdot, coda, cognos, data entry, ibm cognos, railroad, answering, customer service representative, general office, general office duties, inspections, inventory, telephone customer service, clerk, engineering department, invoices, access, excel, excellent customer service skills, filing, microsoft word, organizational skills, typing, word.