Job Description :
Hi,
Hope you are doing great!
Role: Data Engineer/Data Architect
Location: Bellevue, WA
JD:
Position Summary:
The role of the Senior Data Engineer is to extract data from multiple sources and create something similar to a data lake
Responsibilities:
Work closely with various business and IT functions, understand key business needs and develop data solutions
Design, and develop end to end data solutions/pipelines using both On-Premise and Cloud technologies delving into the detail level data architecture
Build data solutions to integrate data from a variety of data sources and frequencies (batch and near real time)
Works to improve the process, product and performance of data and BI landscape
Collaborates with others to lead to the best solutions that fits the business needs and transform Pharmavites data organization in accordance with the Data Strategy and Roadmap
Works closely with various functional teams to translate business requirements into optimized reporting systems and design, and develop appropriate data and presentation layers
Develop strategies and standards to acquire, ingest, enrich, and publish data keeping data quality intact
Build and implement data integration standards using ETL frameworks
Develop multidimensional data repository implementing using Kimball''s methodologies
Create conceptual, logical and physical data model and de-normalize data as needed to create greater performance
Successfully engage in multiple initiatives simultaneously.
Experience:
7+ years of experience in the areas of data architecture, data engineering, data management, data warehousing, and data quality
Solid understanding/experience working with Near-real Time (NRT), Batch, Change Data Capture (CDC), Data Lake, Columnar Database, REST API concepts
Big Data or Data Lake technologies such as Spark, EMR, S3, Kafka, Hive, Apache Drill or equivalent Microsoft Azure technologies
Well versed in using both ETL tools and Hands-on coding
At least one ETL tool experience is required
At least one programming language experience is required- i.e. Java, Scala, .CNet, Python
Background in master data management, metadata management, information lifecycle design, and development
Experience using relational and columnar databases (Oracle, MS SQL Server, AWS Redshift, MySQL, etc
Experience in developing ETL/ELT process with various systems