You are viewing a preview of this job. Log in or register to view more details about this job.

Data Engineer (SQL Server / Azure / Power BI)

The Marketing Advantage, Inc
Email

Expertise/Skills

  • Azure SQL Server 
  • Microsoft Azure platform, including Azure Data Factory, Azure Blob Storage etc.
  • Security Azure network (RBAC, Microsoft Entra ID Platform)
  • Power BI, Data Analysis Expressions (DAX) and Power Query (M)
  • Excel (Microsoft Office Suite)
  • Communication
  • IT Management

Please visit www.MarketingAdvantage.com/careers/data-engineer-handshake and fill out our application to be considered for this position. Submissions made via Handshake will not be reviewed.
NOTE:  This position is fully in-person at our Stamford, CT office.

Nice to Have

  • Microsoft Azure certifications (e.g., Azure Data Engineer Associate)
  • Microsoft Power BI certification (e.g., PL-300: Data Analyst Associate) 
  • Other relevant Microsoft cloud certifications or equivalent cloud/data platform credentials
  • Python, C#, VB

 

Responsibilities

  • Design, develop, and maintain databases using Azure SQL Server 
  • Design-Implement-Maintain Azure Data Factory pipelines to ingest our client's data from different external sources.
  • Maintain documentation and ensure data integrity and security for database structures and processes 
  • Support deployment, upgrades, and ongoing database maintenance
  • Design and develop interactive dashboards and reports using Microsoft Power BI 
  • Build and optimize data models, Power Query (M), relationships, and DAX calculations 
  • Connect to multiple data sources (SQL, APIs, cloud platforms) 
  • Implement data security, including row-level security (RLS) 
  • Collaborate with stakeholders and developers to gather requirements and deliver insights 
  • Publish reports, schedule refreshes, and maintain Power BI Service content 
  • Troubleshoot issues and continuously improve reporting solutions

 

Qualifications

  • Minimum of a bachelor’s degree in STEM. 
  • Experience/knowledge with SQL queries and databases and managing Microsoft SQL Server.
  • Experience/knowledge with Power BI, Data Analysis Expressions (DAX) and Power Query (M).
  • Experience/knowledge with IDEs like Visual Studio, Visual Code, SQL Server Management Studio etc. and Microsoft Cloud Services like Azure Data Factory, Azure Blob Storage etc.
  • Ability to learn business processes and procedures for application development and database management.
  • Self-motivated and ability to work independently and work well on a team.
  • Exceptional organizational skills, attention to detail, ability to handle multiple tasks, ability to prioritize, and execute tasks under pressure.