We're on the lookout for exceptional individuals to join our team as Principal Data Engineers. As a part of our team, you'll be driving change and making a significant impact in the gaming industry.
- Lead the design, development, and maintenance of end-to-end data analytical solutions using Microsoft on-premises and cloud technologies.
- Engage in collaborative requirement elicitation activities with our valued clientele.
- Mentor and guide junior team members in the field of data engineering.
- Showcase your expertise by delivering innovative analytical solutions to our clients and contributing to knowledge transfer within the organization.
- 5+ years of experience as a data engineer.
- Familiarity with analytical architectures including Data Warehouses, Data Lakes and Data Lakehouses.
- Knowledge of Microsoft relational engines available – both on-premises (MS SQL Server) and on the cloud (Azure SQL, Azure Synapse Analytics Dedicated Pools).
- Knowledge of query and workload optimization.
- Knowledge of administrating and managing analytical solutions both on premises and on the cloud.
- Knowledge of NoSQL offerings on Azure (e.g. CosmosDB).
- Knowledge of setting up Data Lakes on ADLS gen 2 and Azure Synapse Analytics.
- Knowledge of using SSIS and Azure Data Factory to set up ETL jobs.
- Knowledge of setting up OLAP solutions using SSAS.
- Familiarity with Azure Data Catalog to manage data lake metadata.
- Knowledge of governance over Azure based analytical solutions including using tools such as Purview, Active Directory, Key Vault, Azure DevOps, etc.
- Knowledge of using Azure Stream Analytics to capture and analyze data in real time.
- Knowledge of setting up data warehouse solutions both on-premises (using MS SQL Server) and on the cloud (using Azure Synapse Analytics).
- Knowledge of Dimensional Modeling (Dimensions, Facts, Slowly Changing Dimensions, Outriggers, Role Playing Dimensions, Junk Dimensions, Degenerate Dimensions, Multi-valued Dimensions, Transactional Facts, Periodic Snapshot Facts and Accumulating Snapshot Facts).
- Knowledge of implementing common ETL patterns to support data warehouse workloads.
- Knowledge of using U-SQL, PolyBase and Azure Data Lake Analytics to perform federated querying.
- Knowledge of PowerBI.
- Familiarity with SSRS.
- Snowflake Experience: Experience with Snowflake is required.
Nice to Have:
- An MSc in Computer Science or other relevant field.
- Familiarity with Azure Databricks.
- Familiarity with DataOps
- Familiarity with Azure Cognitive Services.
- Familiarity with Azure ML.
- Familiarity with MLOps.
- Familiarity of containerization tools and frameworks (Docker, Kubernetes, etc.)
- Familiarity with Azure HD Insight.
- Familiarity with the Hadoop ecosystems, including tools like Hive, Spark and Kafka.
- Familiarity with Azure Functions to perform lightweight transformations.
- Salary paid in USD
- Six-month career advancing opportunities
- Supportive and friendly work environment
- Premium medical insurance [employee +family]
- English language development courses
- Interest-free loans paid over 2.5 years
- Technical development courses
- Planned overtime program (POP)
- Employment referral program
- Premium location in Maadi
- Social insurance
Top Skills
What We Do
Integrant, Inc. is a custom software development company focused on providing tailor made software solutions to fit your needs to a tee. We strive to uncover your pain points and identify how our team can seamlessly integrate with you and your business for a one-team approach.
Our guiding principle is to always do the right thing for our customers and employees.
Some days this means happy news of a “hit on the mark” demo, successful launch, or challenging problem solved.
Other days this means making hard decisions, asking tough questions, or working more than we planned.
Every day, it means doing our best to provide the highest quality service to each of our customers. We do that by investing our people in you and inspiring a people-to-people connection so when we say, “we share your goals,” we truly mean it.
