Data Engineer/Modeler
iFive
Full-time
On-site
Pasig City, Metro Manila, Philippines
Highlights
-
Competitive compensation and benefits packages
-
Continuous professional development and learning opportunities
-
Regular engagement activities and events
- We offer Php 50,000 Sign on bonus!
_____________________________________________________________________________
DATA ENGINEER
Work for our global clients and immerse in our rich and diverse company culture where you can thrive, grow and be #DecidedlyDifferent!
ROLE OVERVIEW
We are looking for a Data Engineer to be part of our team.
-
He/She is accountable for the maintenance and modernization of the company’s data architecture including legacy SSRS and modern Sql Server and Power BI environments.
-
He/She will work within the data team to help identify data of value, manage the ETL of this data to the data warehouse, model the data appropriately and work with data analysts to develop dashboards.
- He/She will work to continuously improve the company’sdata ecosystem. This role will work cross functionally to document and understand business requirements and operational goals associated with the data and work to ensure those goals are realized.
MAIN RESPONSIBILITIES
-
Ensures all data loads to the data warehouse occur according to schedule and remediates any issues
-
Ensures all data warehouse data is modeled in an appropriate schema to achieve business goals.
-
Maintains accurate documentation and a data dictionary associated with all data in the data warehouse.
-
Works cross functionality to identify and incorporate operational changes that have downstream data impacts.
-
Works cross functionally to develop requirements for new data loads. Ensures data models are constructed and builds, tests, automates, and monitors ETL packages using best practices.
-
Works to promote data governance within the organization.
-
Works to ensure data security requirements are met.
-
Develops ad hoc data queries using SQL and tests for accuracy.
-
Maintain legacy SSRS reports.
-
Provide expertise in usage of Power BI.
- Ensures optimal performance of the SQL Server environment.
Requirements
-
Bachelor's degree in Information Technology, Business Administration or another related field preferred
-
5+ Years SQL and Data Modeling experience in both standard normalized data structures, star schema, and other BI related patterns.
-
Experience developing and managing ETL processes/jobs.
-
2+ Years experience using Python in a data environment.
-
Working knowledge of DAMA DMBOK is a plus.
-
Experience leading data governance.
-
Deep understanding of data Mastering.
-
Experience with Master Data Management.
-
Experience with Metadata Management.
-
Hands on experience administering SQL Server.
-
Excellent verbal, written, and interpersonal communication skills
-
Willing to work remotely
- We accept candidate who are outside Metro Manila
v