Data Engineer

Dentsu Aegis Network; New York (NY); Remote; USD 68,000 - 111,000; Full time

Job summary

A leading company seeks a Senior BI Developer to join their Business Platforms team. This role focuses on designing scalable data solutions and delivering business analytics using Azure technologies. Ideal candidates will have extensive experience in data warehousing, SQL, and PowerBI. This position offers a competitive salary and comprehensive benefits package, including medical insurance and flexible paid time off.

Benefits

Medical, vision, and dental insurance

Short-term and long-term disability insurance

Flexible paid time off

Paid holidays

Paid parental leave

Qualifications

• 7+ years of experience in Data Warehousing and Business Intelligence roles.
• Advanced proficiency in T-SQL and data warehousing principles.

Responsibilities

• Design and deploy scalable data solutions using Azure technologies.
• Create data pipelines and conduct complex business transformations.

Skills

SQL

Python

PowerBI

Data Warehousing

Data Modelling

Tools

Azure Data Factory

Azure SQL Data Warehouse

Azure Databricks

Azure DevOps

Git

Job description

The Data Engineer is a new role within our Business Platforms Americas team. We are looking for a well-rounded Senior BI Developer with knowledge of SQL, Python, PowerBI, and data warehousing techniques. You will help us deliver leading-edge business analytics using the latest and greatest BI tools, such as cloud-based databases, self-service analytics and leading visualization tools allowing our aim to become a digital organization. This is a remote position, reporting to Lead Solutions Architect.

Responsibilities:

• You will design and deploy scalable data solutions using Azure technologies such as Azure Data Factory, Azure SQL Data Warehouse, Azure Databricks, Power BI, Fabric, and Azure Synapse Analytics.
• You will create data pipelines, integrations, and transformations to ensure efficient data processing, storage, and retrieval.
• You will conduct complex business transformations to create dimensional models that serve as a foundation for analytical reporting by the analytics team.
• You will perform data profiling, validation, and cleansing to maintain data integrity and accuracy.
• You will perform unit test and conduct reviews with other team members to ensure code is rigorously designed, elegantly coded, and tuned for performance.
• You will identify internal process improvements: automate manual processes, debug inefficient pipelines, and redesign infrastructure for performance and scalability.
• You will deliver Technical Design Documents that outline processes, data flows, definitions, and business rules.
• You will collaborate with business analysts to understand requirements and use cases, translating them into technical stories and tasks.
• You will collaborate with partners to define data requirements and implement BI solutions.

Qualifications

• 7+ years of experience in Data Warehousing and Business Intelligence roles.
• 5+ years of experience in Business Intelligence Analyst or Developer roles.
• 4+ years of experience using Azure Data Factory (ADF) for data warehousing.
• 2+ years of experience developing data models and dashboards using Power BI within an IT department.
• Advanced proficiency in T-SQL, Azure Data Factory (ADF) Pipelines, SSIS packages, relational database design, data modelling, and data warehousing principles.
• Excellent programming skills in SQL, PL/SQL, Python etc.
• Demonstrated experience using and configuring Azure DevOps & Git for integrating cloud services and establishing CI/CD pipelines.
• Knowledge of Azure cloud services, relational database design principles, data warehousing, performance tuning, and optimization techniques.
• Expertise in performance analysis and tuning to ensure database performance.
• Collaborate with developers and partners to gather and refine requirements.
• Experience using Power BI to visualize data for analytics.
• Experience of data warehousing strategies and techniques (e.g., Kimball Data Warehousing).

Additional information

The annual salary range for this position is $68,000 - $110,400. Placement within the salary range is based on a variety of factors, including relevant experience, knowledge, skills, and other factors permitted by law.

Benefits available with this position include:

• Medical, vision, and dental insurance,

• Short-term and long-term disability insurance,

• Flexible paid time off,

• At least 15 paid holidays per year,

• Paid sick and safe leave, and

Dentsu also complies with applicable state and local laws regarding employee leave benefits, including, but not limited to providing time off pursuant to the Colorado Healthy Families and Workplaces Act, in accordance with its plans and policies. For further details regarding Dentsu benefits, please visit www.dentsubenefitsplus.com .

#AJ-1

Location:

New York

Job Description:

The Data Engineer is a new role within our Business Platforms Americas team. We are looking for a well-rounded Senior BI Developer with knowledge of SQL, Python, PowerBI, and data warehousing techniques. You will help us deliver leading-edge business analytics using the latest and greatest BI tools, such as cloud-based databases, self-service analytics and leading visualization tools allowing our aim to become a digital organization. This is a remote position, reporting to Lead Solutions Architect.

Responsibilities:

• You will design and deploy scalable data solutions using Azure technologies such as Azure Data Factory, Azure SQL Data Warehouse, Azure Databricks, Power BI, Fabric, and Azure Synapse Analytics.
• You will create data pipelines, integrations, and transformations to ensure efficient data processing, storage, and retrieval.
• You will conduct complex business transformations to create dimensional models that serve as a foundation for analytical reporting by the analytics team.
• You will perform data profiling, validation, and cleansing to maintain data integrity and accuracy.
• You will perform unit test and conduct reviews with other team members to ensure code is rigorously designed, elegantly coded, and tuned for performance.
• You will identify internal process improvements: automate manual processes, debug inefficient pipelines, and redesign infrastructure for performance and scalability.
• You will deliver Technical Design Documents that outline processes, data flows, definitions, and business rules.
• You will collaborate with business analysts to understand requirements and use cases, translating them into technical stories and tasks.
• You will collaborate with partners to define data requirements and implement BI solutions.

Qualifications

• 7+ years of experience in Data Warehousing and Business Intelligence roles.
• 5+ years of experience in Business Intelligence Analyst or Developer roles.
• 4+ years of experience using Azure Data Factory (ADF) for data warehousing.
• 2+ years of experience developing data models and dashboards using Power BI within an IT department.
• Advanced proficiency in T-SQL, Azure Data Factory (ADF) Pipelines, SSIS packages, relational database design, data modelling, and data warehousing principles.
• Excellent programming skills in SQL, PL/SQL, Python etc.
• Demonstrated experience using and configuring Azure DevOps & Git for integrating cloud services and establishing CI/CD pipelines.
• Knowledge of Azure cloud services, relational database design principles, data warehousing, performance tuning, and optimization techniques.
• Expertise in performance analysis and tuning to ensure database performance.
• Collaborate with developers and partners to gather and refine requirements.
• Experience using Power BI to visualize data for analytics.
• Experience of data warehousing strategies and techniques (e.g., Kimball Data Warehousing).

Additional information

The annual salary range for this position is $68,000 - $110,400. Placement within the salary range is based on a variety of factors, including relevant experience, knowledge, skills, and other factors permitted by law.

Benefits available with this position include:

• Medical, vision, and dental insurance,

• Life insurance,

• Short-term and long-term disability insurance,

• 401k,

• Flexible paid time off,

• At least 15 paid holidays per year,

• Paid sick and safe leave, and

• Paid parental leave.

Dentsu also complies with applicable state and local laws regarding employee leave benefits, including, but not limited to providing time off pursuant to the Colorado Healthy Families and Workplaces Act, in accordance with its plans and policies. For further details regarding Dentsu benefits, please visit www.dentsubenefitsplus.com .

#LI-Remote

#AJ-1

Location:

New York

Brand:

Dentsu

Time Type:

Full time

Contract Type:

Permanent

Dentsu is committed to providing equal employment opportunities to all applicants and employees. We do this without regard to race, color , national origin, sex , sexual orientation, gender identity, age, pregnancy, childbirth or related medical conditions, ancestry, physical or mental disability, marital status, political affiliation, religious practices and observances, citizenship status, genetic information, veteran status, or any other basis protected under applicable federal, state, or local law.

Dentsu is committed to providing reasonable accommodation to, among others, individuals with disabilities and disabled veterans. If you need an accommodation because of a disability to search and apply for a career opportunity with us, please send an e-mail to [e-mail] by clicking on the link to let us know the nature of your accommodation request and your contact information. We are here to support you.

About the company

Dentsu Aegis Network Ltd. is a multinational media and digital marketing communications company headquartered in London, United Kingdom, and a wholly owned subsidiary of the Japanese advertising and public relations firm Dentsu.