Data Engineer

Company Description

As the Human Experience Company, we are a global media agency that believes in the alchemy of people and technology to create experiences people love and actions brands need. It’s in our DNA. We’re powered by the strength of our innovative, driven and, intelligent people who are deeply passionate about achieving best-in-class results on behalf of our clients –some of the world’s leading marketers.

We value you and the work you do. We work hard, but also enjoy scores of perks rooted in our legacy of having one of the strongest agency cultures. Our top-notch health insurance plans and paid time off allow you much-needed time to recharge and achieve the work-life balance you need to bring your absolute best self to work.

Job Description

Starcom is seeking a Data Engineer, a specialist in Microsoft SQL Server and Azure, to join its Analytics + Technology’s Engineering team.  Candidate will contribute towards building custom data-driven applications for decision support, data exploration, and media activation.  Candidate will provide support to media planners, buyers, and analysts, providing automation and incorporating their methodologies into applications for scaling across the organization.

The Data Engineer role will contribute towards designing, developing, deploying, and supporting end-to-end solutions within our Hybrid (on-prem + Azure Cloud) infrastructure. This is a full stack engineering role.  Custom solutions developed internally are used across the organization to help internal teams optimize media planning and buying.

With responsibilities across multiple clients, this candidate will gain exposure to a variety of strategic business problems and the opportunity to contribute to our team’s set of innovative methods to solve them.

Experience:

• BA/BS in Computer Science or a related degree

• 3+ year building relational databases, ETL packages with in-depth understanding of theories, principles, and practices.

• 2+ year experience working in Azure
• Azure certification on Data Engineering or Synapse Analytics preferred

Core Skills

• Must have experience designing, implementing, and managing ETL packages using SQL Server Integration Services (SSIS)
• Excellent understanding of SQL database engine, query tuning, database objects and structures
• Production support of automated jobs/packages and related database servers.
• Migrate/Import data from various sources into a uniform SQL Server database schema
• Optimize database scripts, data storage, and packages to improve application performance.
• Strong understanding and experience of RESTful API's.
• Prior experience working in Azure Synapse Analytics
• Experience in managing data pipelines and workflows within Azure.

Qualifications

Functional Role:

• Excellent at working with cross-functional teams to develop use cases and propose engineering solutions.

• Ability to rapidly brainstorm and develop testable ideas alone or with teams.
• Highly effective communicator, both spoken and written

• Key role in testing and deployment

• Self-reliant, demonstrated desire to take ownership of projects
• Ability to prioritize and manage concurrent projects
• Demonstrate initiative and work independently with minimal supervision

Valued Skills

• Expertise in Azure management, including VMs, Compute/App Engine, Storage, and Security
• Experience in Azure Data Lake, Azure Data Factory, Azure Data Flow, and Azure Functions a big plus
• Database application and process development using scripting using languages such as R, Python, PySpark
• Best practices on managing enterprise data assets

Additional Information

All your information will be kept confidential according to EEO guidelines.