Senior, Data Engineer

Position Summary What you'll do

Data Strategy Requires knowledge of Understanding of business value and relevance of data and data enabled insights decisions Appropriate application and understanding of data ecosystem including Data Management Data Quality Standards and Data Governance Accessibility Storage and Scalability etc Understanding of the methods and applications that unlock the monetary value of data assets To understand articulate and apply principles of the defined strategy to routine business problems that involve a single function

Data Source Identification Requires knowledge of Functional business domain and scenarios Categories of data and where it is held Business data requirements Database technologies and distributed data stores eg SQL No

SQL Data Quality Existing business systems and processes including the key drivers and measures of success To support 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 Transformation and Integration Requires knowledge of Internal and external data sources including how they are collected where and how they are stored and interrelationships both within and external to the organization Techniques like ETL batch processing streaming ingestion scrapers API and crawlers Data warehousing service for structured and semi-structured data or to MPP databases such as Snowflake Microsoft Azure Presto or Google Big Query Preprocessing techniques such as transformation integration normalization feature extraction to identify and apply appropriate methods Techniques such as decision trees advanced regression techniques such as LASSO methods random forests etc Cloud and big data environments like EDO2 systems To extract 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 data science and analytics trends

Tech Problem Formulation Requires knowledge of Analyticsbig data analytics automation techniques and methods Business understanding Precedence and use cases Business requirements and insights To translate coown business problems within ones discipline to data related or mathematical solutions Identifies appropriate methodstools to be leveraged to provide a solution for the problem Shares use cases and gives examples to demonstrate how the method would solve the business problem

Understanding Business Context Requires knowledge of Industry and environmental factors Common business vernacular Business practices across two or more domains such as product finance marketing sales technology business systems and human resources and indepth knowledge of related practices Directly relevant business metrics and business areas To provide recommendations to business stakeholders to solve complex business issues Develops business cases s 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 and develops domain specific artifact Serves as an interpreter and conduit to connect business needs with tangible solutions and results Identify and recommend relevant business insights pertaining to their area of work

Data Modeling Requires knowledge of Cloud data strategy data warehouse data lake and enterprise big data platforms Data modeling techniques and tools For example Dimensional design and scalability Entity Relationship diagrams Erwin etc Query languages SQL No

SQL Data flows through the different systems Tools supporting automated data loads Artificial Intelligent enabled metadata management tools and techniques To analyze 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…