Merkle is a leading data-driven, technology-enabled, global performance marketing agency that specializes in the delivery of unique, personalized customer experiences across platforms and devices. For more than 30 years, Fortune 1000 companies and leading nonprofit organizations have partnered with Merkle to maximize the value of their customer portfolios. The agency’s heritage in data, technology, and analytics forms the foundation for its unmatched skills in understanding consumer insights that drive people-based marketing strategies. Its combined strengths in performance media, customer experience, customer relationship management, loyalty, and enterprise marketing technology drive improved marketing results and competitive advantage. With 9,600+ employees, Merkle is headquartered in Columbia, Maryland, with 50+ additional offices throughout the US, EMEA, and APAC. In 2016, the agency joined the Dentsu Aegis Network. For more information, contact Merkle at 1-877-9-Merkle or visit www.merkleinc.com.

Merkle is looking for experienced Senior Cloud Data Engineer/Analyst to join our Cloud data team. You will take responsibility for managing our master data set, developing reports, and troubleshooting data issues. To do well in this role you need a very fine eye for detail, experience as a data analyst, and a deep understanding of the popular data analysis tools and databases.

Key Responsibilities

• Managing master data, including creation, updates, and deletion.
• Managing users and user roles.
• Provide quality assurance of imported data, working with quality assurance analysts if necessary.
• Commissioning and decommissioning of data sets.
• Processing confidential data and information according to guidelines.
• Helping develop reports and analysis.
• Managing and designing the reporting environment (Data Model), including data sources, security, and metadata.
• Supporting the data warehouse in identifying and revising reporting requirements.
• Supporting initiatives for data integrity and normalization.
• Assessing tests and implementing new or upgraded software and assisting with strategic decisions on new systems.
• Generating reports from single or multiple systems.
• Troubleshooting the reporting database environment and reports.
• Evaluating changes and updates to source production systems.
• Training end-users on new reports and dashboards.
• Providing technical expertise in data storage structures, data mining, and data cleansing.

• Bachelor’s degree from an accredited university or college in computer science, information technology.
• Work experience as a data analyst or in a related field.
• Experienced in using Cloud Technologies such as Azure, GCP, Snowflake & AWS
• Ability to work with stakeholders to assess potential risks.
• Ability to analyze existing tools and databases and provide software solution recommendations.
• Ability to translate business requirements into non-technical, lay terms.
• High-level experience in methodologies and processes for managing large-scale databases.
• Demonstrated experience in handling large data sets and relational databases.
• High-level written and verbal communication skills.
• Understanding of relational and dimensional database concepts.
• Knowledge of SQL is a must. Experienced with any Big Database is fine (Teradata/Snowflake/Postgre/MS SQL/Oracle etc)
• Scripting Knowledge in Python or Shell scripting is good to have
• Worked on any BI/Reporting tool is good to have for presentation of data – Tableau/Power BI etc.
• Ability to understand and break down complex information in consumable portions.
• Excellent written and oral communication skills.
• Have a strong attention to detail and is entrusted with providing internal and external consultative expertise, accurately documenting requirements, and defining acceptance criteria for the project.
• Advanced Excel skills required: vlookups, nested formulas, pivots, VBA a plus
• Ability to troubleshoot technical issues and have creative problem-solving dexterity
• Understanding of Customer data, Master data, Data Governance is a plus
• Proficiency in all standard Microsoft Office programs, including Excel and PowerPoint

At Merkle, we believe that a diverse environment improves us as a community and as a business. We want to foster an environment of growth, where all ideas and contributions are encouraged. We need this culture of courage to continue to thrive in our fast-paced industry. We embrace differences of opinion. We value diversity of experience and thought, which help us to challenge and define industry-leading solutions, and support our goal of being a great place to work.

Merkle fosters a diverse environment that encourages original thinking about our business and empowers us to communicate with a global world of customers. We embrace differences of opinion and diversity of thought as they help us challenge and refine our solutions. Merkle, as a best-in-class marketing agency, welcomes big ideas, and believes they can come from anywhere. 

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

#LI-SP1