Data Engineer
Gymboree Play and Music, Pakistan

The Data Engineer is responsible for creating and maintaining an optimal data pipeline architecture and implementation of the organization’s analytical data assets. This role involves working through the BI data acquisition lifecycle. The role requires the ability to analyze unknown data sources, transforming the data to fit the target model, implementation of data auditing practices, and mentor on best practices for reporting teams and functional teams in their acceptance of BI solutions.

Responsibilities

• Assembling large, complex sets of data that meet non-functional and functional business requirements.

• Responsible for designing and implementing ETL/ELT architecture to meet corporate data management needs and business functional requirements, ensuring that solution designs address operational requirements such as scalability, maintainability, extensibility, flexibility, and integrity.

• Collaborate with data governor to implement source data into the designed target model.

• Maintain the integrity and validity of data throughout the ETL processing cycle by implementing data reconciliation processes and error handling based on source to target data comparisons.

• Facilitates code review with data governor to ensure high performance, consistency, and adherence to standards.

• Engages with cross functional teams on integration efforts for merging BI platforms with enterprise systems and applications.

• Champions code quality, integrity, and re-usability throughout the department by designing and promoting standards and best practices.

• Creates and maintains documentation of the Data Warehouse/Business Intelligence architectures, objects, standards, and best practices.

Requirements

• Bachelor’s degree in Computer Science, Information Systems, Management Information Systems, Mathematics or equivalent combination of education, training, and experience.

• Minimum of (4) years in Business Intelligence development

• Minimum of three (3) years with Data Warehousing methodologies/designs and processes (ETL, Data Modeling)

• Proven experience designing, developing, and deploying Enterprise Business Intelligence solutions to Production

• Highly proficient in SQL with the ability to write and understand complex SQL Server programmable objects such as stored procedures with Dynamic SQL.

• Understanding of systems integrations and data integrations

• Critical thinking a must. Problem solving skills with the ability to look for root causes and implementable, workable solutions

• Experience in Real Estate is a plus

• Experience in the following tools and technologies are a plus: o Power BI o Oracle PL/SQL o Cloud environments (AWS) o AWS Redshift o Bash, PowerShell, Python, Shell, or JavaScript

• Experience with different project development life cycle methodologies such as Waterfall Model, agile/scrum to iterate quickly on product changes, developing user stories, and working through backlogs

• Should be familiar with GitHub or other version control toolsRequirements

Job Rewards and Benefits