Role:Data engineer
Location: Sunnyvale, CA
Duration: 6 months
Role Description
Data Strategy
* Understands, articulates, and applies principles of the defined strategy to routine business problems that involve a single function.
Data Transformation and Integration
* Extracts data from identified databases.
* Creates data pipelines and transform data to a structure that is relevant to the problem by selecting appropriate techniques.
* Develops knowledge of current analytics trends.
Data Source Identification
* Supports the understanding of the priority order of requirements and service level agreements.
* Helps identify the most suitable source for data that is fit for purpose.
* Performs initial data quality checks on extracted data.
Data Modeling
* Analyses complex data elements, systems, data flows, dependencies, and relationships to contribute to conceptual, physical, and logical data models.
* Develops the Logical Data Model and Physical Data Models including data warehouse and data mart designs.
* Defines relational tables, primary and foreign keys, and stored procedures to create a data model structure.
* Evaluates existing data models and physical databases for variances and discrepancies.
* Develops efficient data flows.
* Analyses data-related system integration challenges and proposes appropriate solutions.
Code Development and Testing
* Writes code to develop the required solution and application features by determining the appropriate programming language and leveraging business, technical, and data requirements.
* Creates test cases to review and validate the proposed solution design.
* Creates proofs of concept.
* Tests the code using the appropriate testing approach.
* Deploys software to production servers.
* Contributes code documentation, maintains playbook, and provides timely progress updates.
Problem Formulation
* Translates business problems within one's discipline to data-related or mathematical solutions.
* Identifies what methods (for example, analytics, big data analytics, automation) would provide a solution for the problem.
* Shares use cases and gives examples to demonstrate how the method would solve the business problem.
Applied Business Acumen
* Provides recommendations to business stakeholders to solve complex business issues.
* Develops business cases for projects with a projected return on investment or cost savings.
* Translates business requirements into projects, activities, and tasks and aligns to overall business strategy.
* Serves as an interpreter and conduit to connect business needs with tangible solutions and results.
* Recommends new processes and ways of working.
Data Governance
* Establishes, modifies, and documents data governance projects and recommendations.
* Implements data governance practices in partnership with business stakeholders and peers.
* Interprets company and regulatory policies on data.
* Educates others on data governance processes, practices, policies, and guidelines.
* Provides recommendations on needed updates or inputs into data governance policies, practices, or guidelines.
______________
Required Skills
Data Strategy
* Understanding and application of data strategy principles.
Data Transformation & Integration
* Data extraction from databases.
* Data pipeline development.
* Data transformation techniques.
* Knowledge of current analytics trends.
Data Source Management
* Requirements prioritization and service level agreement understanding.
* Data source identification.
* Data quality validation and checks.
Data Modeling
* Conceptual, logical, and physical data modeling.
* Data warehouse and data mart design.
* Relational database design.
* Primary and foreign key design.
* Stored procedures.
* Data flow design and optimization.
* Data-related system integration analysis and solutioning.
Development & Testing
* Code development.
* Test case creation.
* Proof of concept development.
* Software testing.
* Production deployment.
* Code documentation and playbook maintenance.
Analytics & Problem Solving
* Business problem translation into data-related or mathematical solutions.
* Analytics.
* Big data analytics.
* Automation-based solution identification.
Business Acumen
* Business stakeholder recommendations.
* Business case development.
* Business requirements translation.
* Strategic alignment of projects, activities, and tasks.
Data Governance
* Data governance implementation.
* Data governance documentation.
* Regulatory and company policy interpretation.
* Data governance education and training.
* Data governance policy and process recommendations