data engineer resume example with 10+ years of experience
JessicaClaire
, San Francisco, CA94105, resumesample@example.com
Experience
07/2021 to CurrentData EngineerLockheed Martin | China Lake, CA,
Build automated data solutions and dashboards to enable the team to self-service 80% of data needs
Scope, build and own technical data warehouse processes to help the business scale
Identify, develop, manage, and execute analyses to uncover areas of opportunity that will shape the future of Alexa Shopping
Report key insight trends, using statistical rigor to simplify and inform the larger team of story lines that impact the business
Collaborate with software engineering, product management, marketing and UX as a leader of quantitative analysis and develop solutions that utilize the highest standards of analytical rigor and data integrity
Using AWS Lambda built functions in python to manipulate data base on particular events and later upload data to S3 bucket
Hands on experience in building Tableau, Looker and Quicksight dashboard to achieve self-service data needs
Worked on statistical and quantitative analytics, built forecasting model using python and performed multivariate testing (A/B testing)
08/2019 to 07/2021BI DeveloperPanjiva | Virtual, AZ,
Client, Created optimal technical solutions to user needs through research and in-depth system analysis
Devised high-quality database solutions ranging in size and complexity, increasing productivity and data sharing
Developed complex ETLs using SQL scripts and PLX workflows
Performing data profiling, gap and impact analysis related to switching data sources
Interacting with business stakeholders to understand their decision-making parameters, analyzing the available data to build tableau dashboards and managing the delivery, tested it for data accuracy and functionality
Participated in regular technical reviews with business stakeholders throughout the project life cycle
Leveraged advanced features of tableau such as calculated fields, parameters, and sets to support data analysis
02/2018 to 07/2019Data Warehouse DeveloperActivision | Bellevue, WA,
Analyzed business requirements and worked closely with the business users to understand business requirements
Detailed study and data profiling of all the underlying information security application systems and understood the information security data models
Identified and captured the right metadata from source systems
Analyzed and performed data mapping which involved identifying the source data fields, identifying target entities and their lookup table ids and translation rules
Designed the error-handling strategy for loads process
Created SSIS packages to load data into Data Warehouse using various SSIS tasks like execute SQL task, bulk insert task, data flow task, file system task, script task, execute package task
Built SSIS packages to implement slowly changing dimensions of type 2 to populate current and historical data into dimensions
ETL solution validated incoming data and sent notifications when jobs are done.
07/2012 to 02/2018Database DeveloperApex Systems | Detroit, MI,
Expertise in writing SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors
Created Complex ETL Packages using SSIS to extract data from staging to partitioned tables with incremental load
Experience in SSIS script task, look up transformations and data flow tasks using T- SQL and C# scripts
Used Collections in Python for manipulating and looping through different user defined objects
Written Python scripts to parse XML data and load into databases
Used SQL Server Analysis Services (SSAS) to design cubes for summary reports using SSRS and Tableau
Developed 40 plus SSRS reports to handle the reporting needs of executive team.
Education
Expected in 2012 to to Master | Computer Science, , GPA:
Expected in 2009 to to Bachelor | Information TechnologyMumbai University, , GPA:
Summary
I am an experienced professional in the field of Data Analytics and Data Engineering. I enjoy the challenges of combining disparate data sources and building scalable data architectures to enable stakeholders and analysts make rational, data-driven decisions.
Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.