Data Engineer (with MSF Stack)

Who Are We?

SDG Group is a global consulting firm specialized in Data & Analytics. We are committed to unlocking organizations’ potential and hidden value by offering in-depth analytics expertise that empowers our clients’ business models to become successful data-driven enterprises. Innovation is in our DNA. We constantly innovate our value proposition with cutting-edge laboratories and transformational models to provide the ultimate analytics practices and solutions.

SDG Group works on the pillars of a Triple Expertise, incorporating business process skills by domain with a technological knowledge and a partnership with the most important and innovative software providers. Our portfolio also features cutting-edge laboratories and the development of Advanced Analytics & AI technologies.

Why Join Us?

We’re looking for problem solvers, innovators, and collaborators who want to be a part of the mission to help us to further grow our company! You will have the ability to learn the latest technologies in the market and build strong relationships with technical and business leaders, all while deepening your expertise and enhancing your skills. We will work with you to create customized career plans which will allow you to grow independently, as well as with your colleagues. If you value inclusivity and want to join a culture that empowers you to show up as your authentic self, join us. Our goal is to move through the interview process in a timely manner while staying highly communicative. We are committed to ensuring that you are equipped with a comprehensive understanding of SDG Group and the role you have applied to.

What You’ll Be Doing

-Lead end-to-end data projects within complex client environments, ensuring timely delivery of high-quality Microsoft Cloud data solutions (Azure and/or Fabric).

-Architect innovative, robust, and scalable solutions leveraging Microsoft Azure data services and/or the Microsoft Fabric platform to address modern data challenges, including:

-Designing and implementing migrations from on-premises or other cloud platforms to Microsoft Azure or consolidating into Microsoft Fabric.

-Developing efficient data processing pipelines for large datasets using Azure services (like Azure Data Factory, Azure Synapse Analytics, Azure Databricks) or within Microsoft Fabric (e.g., Fabric Data Factory Pipelines, Dataflows Gen2, Fabric Spark).

-Automating complex data integrations across diverse systems leveraging Azure Data Factory, Logic Apps, Fabric Data Factory Pipelines, and other relevant tools.

-Modeling and implementing data structures (e.g., relational, dimensional, Lakehouse medallion architecture) optimized for Azure data storage (Azure SQL DB, Synapse Analytics, ADLS Gen2/OneLake) or Fabric artifacts like the Lakehouse and Warehouse.

-Designing and building backend solutions within the Microsoft Cloud ecosystem to effectively support analytics and visualization technologies, particularly Microsoft Power BI (standalone or integrated within Fabric).

What We Look For

-Relevant Bachelor’s Degree (Computer Science, Engineering, Mathematics, Physics, Business Technology, Information Systems, etc.).

-3+ years of hands-on experience with Relational Database Management Systems (RDBMS), particularly Microsoft SQL Server, Azure SQL Database, or concepts within Fabric Warehouse/Lakehouse.

-3+ years of relevant work experience focused on Microsoft Business Intelligence and/or Azure/Fabric Data Platforms in challenging enterprise environments.

-Strong understanding of modern data modeling techniques and their application within Azure and Fabric environments (including Lakehouse concepts).

-Deep understanding and hands-on experience architecting and implementing-solutions using core Microsoft Azure data services and/or Microsoft Fabric components, including:

-Microsoft Fabric (understanding its unified nature, OneLake, Lakehouse, Warehouse, DirectLake mode, etc.)

-Azure Data Factory (ADF) and/or Fabric Data Factory (Pipelines, Dataflows Gen2)

-Azure Synapse Analytics (SQL Pools, Spark Pools) and/or Fabric Warehouse/Lakehouse/Spark

-Azure Databricks

-Azure SQL Database / Managed Instance

-Azure Data Lake Storage (ADLS Gen2) / OneLake

-Power BI (Data modeling, DAX, reporting, integration with Fabric/Azure)

-Proven ability to recommend best practices and develop innovative, sustainable solutions using the Microsoft data stack (Azure & Fabric).

-Outstanding oral and written communication skills, with the ability to explain complex technical concepts to diverse audiences.

-Based in or willing to commute to the Bedminster, NJ office, with willingness and ability to travel to client sites throughout the NY, NJ, and PA area as needed.

Desired Skills & Experience

-Hands-on experience implementing end-to-end solutions using Microsoft Fabric (demonstrating knowledge of Lakehouse, Warehouse, Data Factory, Spark, and Power BI integration).

-Experience with Azure Synapse Analytics is also highly valued.

-Experience with Azure Analysis Services or Power BI Premium features for semantic modeling.

-Familiarity with Infrastructure as Code (IaC) concepts and tools (e.g., ARM templates, Bicep, Terraform) within an Azure context.

-Experience working within the Pharmaceuticals, Manufacturing, Consumer Products, or Retail industries.

-Possesses key qualities: entrepreneurial spirit, ambitious drive, proactive approach, detail-oriented mindset, and strong collaborative skills.

-Experience with other cloud platforms (AWS, GCP) or data platforms like Snowflake is a plus.

Benefits of Working With Us

At SDG, we’re constantly striving towards building a culture where people come first by creating an environment of transparency, collaboration and meritocracy. We take care of our global employees by making sure we offer the following:

-Full-time employment in an exciting and growing high-tech industry with a competitive salary

-A professional career with opportunities for personal and professional growth and rapid career advancement based on meritocracy; every six months you’ll meet with your manager to share feedback, discuss new challenges, and review your salary

-A creative and innovative work environment with flexible working options (flexible working hours, good mix of on-site and remote)

-Robust Healthcare and Benefits package including Medical, Dental, Vision, Disability coverage, and various other benefit options

-401k Retirement plan with Employer match

-3+ weeks paid vacation and flexible holiday schedule