Data Engineer (SQL Server / Azure / Power BI

Company Description

The Marketing Advantage®, Inc. (“TMA”) is a life science consulting company using advanced analytics, AI, and inspiring creativity to provide superior sales compensation & sales optimization solutions for pharmaceutical, biotechnology and medical device companies. Founded in 1985, the company dedicated itself to the life sciences industry in 1991 and has remained at the forefront of developing the innovations needed to face the constantly changing healthcare landscape.

Please visit www.MarketingAdvantage.com/careers/data-engineer-linkedin and fill out our application to be considered for this position. Submissions made via LinkedIn will not be reviewed.

NOTE: This position is fully in-person at our Stamford, CT office.

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

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.