Job Summary
ETL DeveloperEXPECTED SERVICES1. Contractor will develop new features / enhancements, refactor legacy ETL code andfix bugs for the Business Intelligence and Analytics team . This can include, but is notlimited to, data mart design/development2. Contractor will own tasks through the entire software development life cycle fromconcept to release to production including: helping to document businessrequirements, documenting development approach, implementing code changes,testing, gathering approvals and migrating code3. Contractor will develop code changes, unit tests, integration tests and performancetests pursuant to the development standards and best practices as documented byGoogle4. Contractor will develop code changes based on functional requirements defined viabusiness requirement documents (BRDs), functional specification design documents(FSDs),Technical Design Documents (TDDs), or other written / verbal instructions5. Contractor will work with Google business analysts, program managers and othercontractors (including contractors from other vendors) to determine functional &technical requirementsSkills● Experience in delivering Business Intelligence solutions - Mandatory○ Preferably experienced in multiple BI aspects○ Strong SQL skills in complex queries and data manipulation a must● Experience in developing ETL / building data pipelines with ETL tools or programminglanguages - Mandatory○ Experience in databridge○ Python programming, shell scripting, java scripting experience a plus● Owns data integration delivery tasks from development through support including:documenting data modeling / development approach, implementing code changes,testing, gathering approvals, migrating code, and support / enhancement of codepost-production● Owns report/dashboard delivery (PLX) tasks from development through supportincluding: documenting development approach, implementing code changes, testing,gathering approvals, migrating code, and support/enhancement of code post-production● Will provide support for new and existing data models, ETL pipelines and data marts● Will create and maintain detailed documentation via Google Docs / Sheets / Slides forassigned design / development and testing tasks as prescribed by BI team● Has supply chain experience background in above mentioned areaQualificationsMinimum qualifications:● 5 or more years of experience in Data engineering projects● Experience with SQL or equivalent database querying language● Working knowledge of relational databases, including BigQuery, MySQL and large-scaledistributed systems● Analytical skills with the experience identifying, quantifying, and effectively raisingbusiness risks associated with data quality or non-compliance● Strong communication and collaboration skills with capability to execute with businessstakeholders
Key Responsibilities
ETL DeveloperEXPECTED SERVICES1. Contractor will develop new features / enhancements, refactor legacy ETL code andfix bugs for the Business Intelligence and Analytics team . This can include, but is notlimited to, data mart design/development2. Contractor will own tasks through the entire software development life cycle fromconcept to release to production including: helping to document businessrequirements, documenting development approach, implementing code changes,testing, gathering approvals and migrating code3. Contractor will develop code changes, unit tests, integration tests and performancetests pursuant to the development standards and best practices as documented byGoogle4. Contractor will develop code changes based on functional requirements defined viabusiness requirement documents (BRDs), functional specification design documents(FSDs),Technical Design Documents (TDDs), or other written / verbal instructions5. Contractor will work with Google business analysts, program managers and othercontractors (including contractors from other vendors) to determine functional &technical requirementsSkills● Experience in delivering Business Intelligence solutions - Mandatory○ Preferably experienced in multiple BI aspects○ Strong SQL skills in complex queries and data manipulation a must● Experience in developing ETL / building data pipelines with ETL tools or programminglanguages - Mandatory○ Experience in databridge○ Python programming, shell scripting, java scripting experience a plus● Owns data integration delivery tasks from development through support including:documenting data modeling / development approach, implementing code changes,testing, gathering approvals, migrating code, and support / enhancement of codepost-production● Owns report/dashboard delivery (PLX) tasks from development through supportincluding: documenting development approach, implementing code changes, testing,gathering approvals, migrating code, and support/enhancement of code post-production● Will provide support for new and existing data models, ETL pipelines and data marts● Will create and maintain detailed documentation via Google Docs / Sheets / Slides forassigned design / development and testing tasks as prescribed by BI team● Has supply chain experience background in above mentioned areaQualificationsMinimum qualifications:● 5 or more years of experience in Data engineering projects● Experience with SQL or equivalent database querying language● Working knowledge of relational databases, including BigQuery, MySQL and large-scaledistributed systems● Analytical skills with the experience identifying, quantifying, and effectively raisingbusiness risks associated with data quality or non-compliance● Strong communication and collaboration skills with capability to execute with businessstakeholders