Company Overview
Position Overview
The Data Transformation Engineer plays a key role in the development and execution of automatic data collection and integration processes. This position focuses on the importing of data from a variety of sources into the Platform for reporting. The Data Transformation Engineer is part of the Database team which is dedicated to providing clean and useable marketing data to our clients. As part of the MSIGHTS team, this position requires a great capacity to take initiative, an ability to consistently deliver above expectation, a passion for continuous improvement, and a willingness to work hard and be rewarded.
Responsibilities and Duties
- Position is responsible for the ETL process which includes the different marketing channels, validations, and preparation of the data for Reporting or System to System interconnection.
- Responsible for understanding Data models, how to normalize data and prepare information in the form of views and report sets.
- Implement Solutions in different Database engines that incorporate Dat Flows and/or Data Streams.
- Implement Client Business Rules to use and group data.
- Monitor and improve query execution, performance for all clients.
- Using Agile and Scrum methodologies, deliver a plan and follow it to successfully release the applications.
- The candidate is required to document, generate ideas, follow coding standards, and follow coding patterns.
Qualifications and Skills
- 2+ years of experience working on Cloud Computing in AWS services.
- Working knowledge in any of the following database services Redshift, Athena, In -memory database, SQL Server, PostgreSQL.
- Experience with Data Models, Data Normalization, Automatic,Data Sanitization, Data Flows, Data Streams, and Data Maps.
- Desirable non-SQL databases.
- Must be a self-starter, willing to take the initiative and propose innovation in MSIGHTS products and/or processes.
- Fluent in the English Language with strong communications skills - both written and verbal — and the ability to work well with an internal team.
- Must be detail-oriented, committed to quality, and client-focused, all while being flexible and entrepreneurial in a fast-paced international work environment.
- Bachelor’s Degree or equivalent.
Skills Required
- 2+ years experience with Cloud Computing in AWS services
- Working knowledge of Redshift
- Working knowledge of Athena
- Working knowledge of In-memory databases
- Working knowledge of SQL Server
- Working knowledge of PostgreSQL
- Experience with Data Models and Data Normalization
- Experience with Automatic Data Sanitization, Data Flows, Data Streams, and Data Maps
- Desirable experience with non-SQL (NoSQL) databases
- Ability to implement client business rules and prepare data for reporting
- Experience monitoring and improving query execution and database performance
- Familiarity with Agile and Scrum methodologies
- Ability to document work, follow coding standards, and propose improvements
- Fluent English with strong written and verbal communication skills
- Detail-oriented, client-focused, flexible, entrepreneurial
- Bachelor's Degree or equivalent
What We Do
Founded in 2004, North Carolina-based MSIGHTS provides cloud-based marketing data integration services to some of the world’s most sophisticated global advertisers. As marketing channels proliferate, so do the data sources marketers must examine in order to quantify results and guide strategy. MSIGHTS services make marketers more efficient and successful by providing a single view of overall marketing performance with actionable insights on what works and what doesn’t. The MSIGHTS cloud-based platform automatically collects and reconciles disparate data, making it immediately available to fuel a wide variety of analytical and visualization tools.
