Data Engineer  

As Data Engineer, he or she is expected to be the technical lead on data engineering of Business Intelligence projects he or she is involved in and responsible for overseeing the data management works and business intelligence dashboards in the said projects. The Data Engineer is also expected to lead in the crafting of data warehouse and business intelligence project proposals together with the assigned project manager. The Data Engineer is expected to supervise younger and new data analysts or data associates towards the goal of forming the competencies and expertise of the latter.

The Data Engineer is expected to be proficient in data processing tasks (data modeling, ETL, visualization) using data manipulation language/tool (e.g., SQL, pandas) and proficient in using general purpose programming language (e.g., python and R) in performing custom data transformations and information retrieval. He or she is expected to process data from unstructured and/or noSQL data sources (e.g., mongoDB). He or she will work on on-prem virtual machines and cloud technologies. The Data Engineer is expert on the use of standard tools in doing ETL, data modeling, and analysis services He or she is expected to develop data warehousing solutions and other data backend support. Furthermore, he or she will be expected to be proficient on Enterprise Resource Planning systems such as the Dynamics 365 platform.

Responsibilities

• Works closely with the business intelligence team in the planning, research, implementation, testing, and maintenance of both current and future system/s and in the design of business intelligence platform
• Works on data processing tasks such as data modeling, ETL, dashboards, data visualization, and reports automation.
• Performs information retrieval tasks from SQL, noSQL, and other unstructured data sources.
• Performs work on on-prem virtual machines and cloud technologies.
• Prepares technical slides to help articulate the methods used to deliver solutions to clients.
• Performs advanced ETL/ELT, Data Warehousing, Cubes/OLAP, ERP
• Knows how to locate and correctly use resources to sufficiently equip themselves with the knowledge needed in each client project
• Any additional responsibilities that may be assigned from time to time

As In the idea, character, or condition of, limiting the view to certain attributes or relations More (Definitions, Synonyms, Translation)

Graduate of Computer Science, Information Technology, Management Information Systems, Mathematics, Geodetic Engineering, Industrial Engineering, Management Engineering, Mechanical Engineering, or related programs.

Technical Requirements

• Knows Structured Query Language and how to create SQL procedures and SQL functions
• Knows how to do information retrieval and data manipulation on databases hosted in an SQL DBMS and noSQL DBMS
• Knows how to use a BI reporting tool (MS Power BI, Tableau) in developing interactive dashboards
• Preferably with experience in Git and user testing
• Applied knowledge on PowerQuery, PowerPivot, SSIS, SSAS, Azure Data Factory, Azure Analysis Services, Dynamics 365, MS SQL Server, PostgreSQL, mySQL, mongoDB, SQL Studio, mySQL workbench, Azure Cloud, AWS, on-prem VM and cloud VM
• Proficient in office productivity tools (word processing, electronic spreadsheet, presentation preparation).

Non-Technical Requirements

• Creativity - Designing new approaches to solving problems and implementing solutions.
• Communication - Good command of language in both oral and written communication.
• Collaboration - Able to work well with a diverse set of people to deliver excellent results.

Others:

Knowledge of the following is advantageous: Data Lakes, Hadoop, Cloudera, pySpark

Personal Attributes

• Highly analytical and intelligent. Intellectually curious
• Ability to exercise sound judgment and make decisions based on accurate and timely analyses.
• High desire to succeed.
• Positive, resourceful, and agile.
• Strong sense of personal commitment
• Energetic; strong capability to energize others
• Independent and self-motivated learner, open and eager to learning new skills
• Dynamic and flexible
• Strong interpersonal skills, ability to communicate (English and/or Filipino) well
• Strong problem solving and creative skills and the ability to exercise sound judgment
• High level of integrity and dependability with a strong sense of urgency and results-orientation