Vacancy expired!
Job Description: Need a Data Engineer to support our client's DM&BI team.
Essential Functions
Develop high quality, reliable, and fault-tolerant data solutions based on internal and external customers/users requirements, applying best practices and new trends/technologies all along the solution lifecycle.
ETL tool of preference is Pentaho Data Integration (PDI).
Integration of external data into data warehouses using REST API and web services among others
Delivery of data to internal customers and external vendors through different data formats (CSV, Excel, XML, JSON) and delivery methods (ex. Email, SFTP, S3, etc.), including REST API.
Provide daily monitoring, management, troubleshooting, and issue resolution to existing and new data solutions and systems interfaces affected by them.
Follow and implement Agile Best Practices for Data Warehousing.
Support the Business Intelligence team through the delivery of reliable and timely data.
Required:
5+ years of Data Engineering experience.
Proficiency with SQL DML (Data Manipulation Language) with special focus on query
tuning/performance.
Experience with AWS ecosystem (Data Lake Formation, Glue, Data Pipelines, EC2, Redshift, S3,
Glacier, DynamoDB, Lambda, etc.)
Background on Data Modeling and Data Warehouse design (Methodologies: Kimball, OLAP, EDW).
Proficiency with ETL programming tools (preferably Pentaho PDI), jobs and scheduling management.
Nice to have:
Experience with Python is a plus.
Experience on NoSQL or non-relational DBMS is a plus.Required Skills: DATA MODELING, DATA WAREHOUSE; SQL DML, ETL, AWS, PENTAHO, Python. Don't hesitate! Submit your resume today. SMCI is an EEO employer. All qualified applicants will receive consideration without regard to race, color, religion, sex, sexual orientation, national origin, disability, age, genetic information, marital status, military, and veteran status. Members of minority groups, Vietnam Era Veterans and individuals with mental or physical disabilities are encouraged to contact us regarding employment opportunities. In addition, in order to support the provision of business to minority-owned and Women-owned businesses (MWBE), such MWBE are encouraged to contact us regarding subcontracting business opportunities with our firm. (No third parties, please)(H1 sponsorship currently unavailable)(Local candidates only, please)
Vacancy expired!