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:
<<summaryseasoned data architect adept at understanding mandates, developing plans and implementing enterprise-wide solutions. complex problem-solver with an innovative approach. ready to bring 1o-plus years of progressive experience and take on a challenging new role with growth potential. skills data managementorganizational skills critical thinkingteam managementproblem resolutioncustomer servicerelationship buildingteam buildingsupervision & leadershipplanning & organizingfriendly, positive attitude experience 08/2016tocurrentsr. data engineer architecthoneywell– ,used statistical software to analyze and process large data sets.followed industry innovations and emerging trends through scientific articles, conference papers or self-directed research.distilled data to devise solutions related to budgeting, staffing and marketing decisions.recommended data analysis tools to address business issues.provided global thought leadership in analytics solutions to benefit customers.captured and shared best-practice knowledge amongst developers community.cleaned and manipulated raw data.created graphs and charts detailing data analysis results.managed performance monitoring and tuning while identifying and repairing issues within database realm.developed new functions and applications to conduct analyses.assisted solution providers with definition and implementation of technical and business strategies.tested, validated and reformulated models to foster accurate prediction of outcomes.contributed to maintaining azure-sql sever and db2 databases in conjunction with data development and software engineering teams.adept in troubleshooting and identifying current issues and providing effective solutions.promoted customer success in building and migrating applications, software and services on azure platform.collaborated with solution architects to define database and analytics engagement strategies for operational territories and key accounts. 01/2016to 08/2016sr. etl developermillennium health–city,state,assessed code during testing stage to determine potential glitches and bugs.conferred with project managers and other stakeholders to fully understand software design specifications and plan optimal development approaches.employed integrated development environments (ides).devised automation, backup and recovery protocols to preserve and safeguard data.analyzed user needs and software requirements to determine design feasibility.collaborated with support team to assist client stakeholders with emergent technical issues and develop effective solutions.applied security measures into systems development, supporting final products' resistance to intrusion and exploitation.designed customized technical solutions to meet functional specifications outlined by millennium health database customers.worked closely with systems analysts, engineers and programmers to understand limitations, develop capabilities and resolve software problems.collaborated with architects to define data extraction methodologies and data source tracking protocols.utilized established design patterns to expedite novel software creation and support consistent performance results.integrated object-oriented design and development techniques into projects to support usability goals.analyzed code and corrected errors to optimize output.identified opportunities for process improvements to decrease in support calls.defined and documented ssis etl data mapping plans using windows powershell scripting and custom solution from vendors (i.e. pragmatic works).resolved customer issues by establishing workarounds and solutions to debug and create defect fixes.programmed applications and tools using object-oriented languages with goals of code abstraction, stability and reuse.assisted in user acceptance testing for millennium customers, verifying etl jobs complied with assigned parameters, achieving success during execution phasescombined root-level authentication and authorization technologies with ongoing system design to harden finished solutions.applied prescribed policies to programming syntax in compliance with internal language policies.modified existing software to correct errors, adapt to newly implemented hardware or upgrade interfaces.leveraged agile methodologies to move development lifecycle rapidly through initial prototyping to enterprise-quality testing and final implementation.developed software for embedded systems, coding solutions for both new installations and in-situ hardware.performed troubleshooting of post-release software faults to support live service and installed software patch design.developed requirements for system modifications and new system installations.recommended improvements to facilitate team and project workflow.coordinated testing and validation procedures through software development lifecycle.managed end-to-end operations of etl data pipelines, maintaining uptime of 96%.improved and corrected existing software and system applications.applied conceptual, logical and physical & dimensional/relational model designs to etl tasks. 05/2013to 10/2015sr. database app bi developertranscanada corporation–city,state,analyzed and developed technical and functional specifications for databases.developed and updated all documentation related to database technologies for department.built integrations from multiple data sources, including salesforce and pardot.identified databases not reaching peak performance and determined ways to solve concerns.applied various skills to evaluate, design, implement and optimize databases and database applications.managed financial management systems, customer and production databases and inventory, production equipment and editing systems.provided support to clients in understanding and manipulating data to obtain value through sql and etl technical processes and visual analytics tools.managed all levels of internal analytics practice, including etl, database administration, report development and integration.produced complex database project with zero issues due to effective troubleshooting.developed, designed and optimized data structures for analysis.partnered with project management teams on development of scope and timelines.assisted clients in understanding and manipulating data to gain value through sql and etl technical processes and visual analytics tools.developed data models and database designs to plan projects.developed and implemented security initiatives to protect important company data.constructed database and warehouse, streamlined disparate data sources and unverified queries into main source.wrote scripts and processes for data integration and bug fixes.planned, designed and streamlined data structures for analysis.supervised all levels of internal analytics practice, including etl, database administration, report creation and integration.built database and warehouse, including consolidating disparate data sources and unverified queries into central source.created integrations from various data sources, including salesforce and erd systems. 02/2011to 04/2013database application developerbarclays plc–city,state,modified existing software to correct errors, adapt to newly implemented hardware or upgrade interfaces.utilized established design patterns to expedite novel software creation and support consistent performance results.employed integrated development environments (ides).developed logic flowcharts and diagrams to use in program coding and workflow planning.developed software for embedded systems, coding solutions for both new installations and in-situ hardware.identified opportunities for process improvements to decrease in support calls.analyzed code and corrected errors to optimize output.liaised with clients to clarify business challenges and objectives to optimize performance of existing systems.trained and coached new hires and junior developers and shared insight into ways to meet tight deadlines and improve overall efficiency.coordinated testing and validation procedures through software development lifecycle.combined root-level authentication and authorization technologies with ongoing system design to harden finished solutions.identified, debugged and fixed system bottlenecks and problems.resolved customer issues by establishing workarounds and solutions to debug and create defect fixes.devised automation, backup and recovery protocols to preserve and safeguard data.applied innovative approaches to application design through creative inception and planning.contributed to requirements gathering and design development meetings.improved and corrected existing software and system applications.leveraged agile methodologies to move development lifecycle rapidly through initial prototyping to enterprise-quality testing and final implementation.assessed code during testing stage to determine potential glitches and bugs.worked closely with systems analysts, engineers and programmers to understand limitations, develop capabilities and resolve software problems.conferred with project managers and other stakeholders to fully understand software design specifications and plan optimal development approaches.applied prescribed policies to programming syntax in compliance with internal language policies.recommended strategies to maximize performance and lifespan of equipment involved in software installations.developed requirements for system modifications and new system installations.performed testing on user defined functions and triggers.utilized best practices to identify and remedy bugs in applications within specific timeframe.recommended improvements to facilitate team and project workflow.optimized application process flow to improve performance.programmed applications and tools using object-oriented languages with goals of code abstraction, stability and reuse.updated software upon release of vendor patches to mitigate vulnerabilities.monitored equipment function to verify conformance with specifications.analyzed user needs and software requirements to determine design feasibility.applied application product support to contractors located internationally.worked closely with brand and marketing teams across organizations to promote specific applications.increased efficiency through task automation.applied security measures into systems development, supporting final products' resistance to intrusion and exploitation.assessed project scope to identify necessary requirements.established clear system performance standards and wrote specifications.collaborated with support team to assist client stakeholders with emergent technical issues and develop effective solutions.integrated object-oriented design and development techniques into projects to support usability goals.reviewed project requirements to identify customer expectations and resources needed to meet goals.performed troubleshooting of post-release software faults to support live service and installed software patch design. education and trainingexpected in 07/2006totobachelor of science:electrical electronics engineeringuniversity of leicester-leicestershire, england,gpa:.