Manager, Data Engineering & ETL Development
Dallas, TX, United States
Applications have closed
Publicis Groupe
Company Description
Thank you for considering joining Spark Foundry for the next step in your career. Our exceptional people (Sparklers) are what make us special, set us apart from the pack, and lead our agency and our clients into the future. Voices like yours are essential to our ability to connect with and remain relevant with increasingly diverse audiences. The perspective you bring helps ensure our solutions are fresh, and modern and help our clients grow.
At Spark Foundry, our purpose is clear: we bring HEAT to brands. HEAT stands for Higher Engagement, Affinity & Transactions. In other words, we get consumers to pay more attention, care more deeply about the brand, and buy more of its products and services.
Our Sparklers “bring their heat” - their unique superpowers and individual backgrounds – with them to work every day, and that heat is what has driven the continued growth of our culture and our brand.
Spark Foundry is not just a media agency. To our clients, we are true partners. This is not only a huge benefit to the brands we work with, but to our people as they expand their skills and expertise. We offer clients the best of both worlds: a startup spirit and a powerhouse soul. Our spirit embraces our ability to deliver high-touch service, boutique insights, bold creativity, and ever-evolving product and process, just like a startup. And our powerhouse soul comes to life through our unique marketplace access, best-in-class partnerships, and unparalleled buying clout to deliver our clients' increased value.
We believe a fulfilling and rewarding personal life inspires fresh thinking and the ability to create great work.
Job Description
Overview:
The Manager, Data Engineering & ETL Development is a key driver to build data platform leveraging best in class ETL practice and is also a strategic thinker and a talented data visualization expert with emphasis on dashboard reporting. The primary responsibility will be developing business intelligence platform to support media and marketing data for our clients. This position will allow you to be a significant contributor as part of the team to support easy access of data and visualizations to fuel stronger insights and media optimizations.
This position requires strong technical and tactical skill sets with an eye for numbers, intellectual curiosity, proficiency at problem solving, and a critical understanding of online media. The candidate must have a proven track record in managing ETL’s, APIs and business intelligence platforms. Candidate should be a team player. A “roll up the sleeves” approach is mandatory and a “get it done” attitude is a must. Specific responsibilities include coordination between the research, analytics & media teams ensuring high quality data projects are effectively delivered.
Successful candidates will be multi-dimensional ‘rising-stars’ who are able to employ complex problem solving skills, and are able to communicate these succinctly to a broad client and media stakeholder audience.
Role Objectives:
- Responsible for loading and validating data into the data warehouse from various source systems
- Analyze, develop, fix, test, review and deploy functionality, and bug fixes in ETL data pipelines
- Query tuning, diagnosis, and resolution of performance issues leveraging ELT and push-down if required
- Building Data mappings between Source to Target systems
- Provides support for technical issues and ensuring system availability
- Work with business customers to identify and develop additional data and reporting needs
- Understand how business intelligence platform/data technologies work and offer the ability to explain technical concepts in ordinary terms (be technically savvy - understand the opportunities and limitations)
- Establish and manage data integrations utilizing a taxonomy nomenclature to make recommendations for data visualization to showcase media performance through the use of Datorama or Tableau
- Perform regular quality assurance/quality control checks on assigned client campaigns to ensure the data is processing accurately
- Design and build backend data streams and processes to automate reporting capability with data visualization tools
- Contribute to client status and reporting calls, including presentation of reporting as required
- Develop subject matter expertise in ETL, API development, and Business Intelligence platforms
- Clearly define project deliverables, timelines, and dependencies for junior team members, internal stakeholders and clients
- Collaborate on an inclusive team, where members openly communicate and collectively problem-solve
- Strong ability to evaluate new technologies and present findings to team
- Contribute to knowledge sharing efforts and mentorships
- Complete other duties as assigned.
Qualifications
- Bachelor’s degree or combination of education, and equivalent work experience is preferred in the field of computer science, management information systems or Information Technology
- 3+ years’ related experience ETL development and business intelligence platform management
- Understanding of BI/ETL development in the IT industry with recent development, system administration, application tuning and debugging experience.
- 3+ plus years’ development experience with database engines including Presto, Mongo db and Hadoop.
- 3+ years’ experience in ETL development, Strong Database (Modeling, SQL), SQL Server, Hadoop, AWS Redshift, Qubole.
- Experience managing team of 2 or more associates/analysts preferred
- Strong database modeling and SQL skills. Ability to write complex SQL statement, Procedures and data automation programs
- Knowledge of ETL tools like Airflow, AWS Glue, Alteryx, SSIS, Qubole/Spark is a must
- Knowledge of Python or similar programming languages required
- Proficiency with Datorama, Tableau, or other data visualization tools is preferred
- Experience working with AWS or other cloud technologies
- Advanced user Microsoft Office Suite and reporting tools
- Demonstrated expertise in core MS Excel functions (vlookup, pivot tables, data visualization)
- Experience in designing jobs that can be easily promoted from one (Dev) environment to another (Test or Prod) seamlessly, without modification.
- Strong analytical and problem-solving skills
- Strong verbal/written communication and interpersonal skills is required
- Self-starter with ability to thrive in a fast-paced environment and able to function independently while providing status updates to a team of analysts
- Cooperative, flexible, conscientious, dependable, resourceful, self-motivated, and team-oriented
- Problem solving, time management, and critical thinking skills with a professional and positive attitude
- Ability to work independently and as part of an agile team, participating in daily stand-ups, sprint planning and sprint review
Character:
The following qualities help drive success as member of the Spark Data and Analytics team:
- Entrepreneurial, engaging, resourceful, curious, and self-directed spirit
- Willing and easily roll sleeves up or down; love the nitty-gritty and the strategy
- Collaborative approach to building cohesive, strong teams
- Loving and living the intersections between brands, people, media, communications
- Relentlessly passionate and resolute
- Planning and time management excellence.
- Embrace challenges
- Proactive, especially in pushing for new opportunities, approaches, and ideas.
- Keenly focused on action and solutions; thrives with deep critical thinking and analysis.
- Pioneering insight attitude and research in-the-know.
- Resourcefulness, flexibility and adaptability, strong ability to pivot when the need arises.
- Inspired to be part of the insight journey/revolution with a growing, dedicated team
Additional Information
All your information will be kept confidential according to EEO guidelines.
22-3652
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Agile Airflow API Development APIs AWS AWS Glue Business Intelligence Computer Science Data pipelines Data visualization Data warehouse ELT Engineering ETL Excel Hadoop Pipelines Python Redshift Research Spark SQL SSIS Tableau
Perks/benefits: Career development Flex hours Startup environment
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Marketing Data Analyst jobs
- Open MLOps Engineer jobs
- Open Junior Data Scientist jobs
- Open AI Engineer jobs
- Open Data Engineer II jobs
- Open Senior Data Architect jobs
- Open Power BI Developer jobs
- Open Senior Business Intelligence Analyst jobs
- Open Data Analytics Engineer jobs
- Open Sr Data Engineer jobs
- Open Manager, Data Engineering jobs
- Open Principal Data Engineer jobs
- Open Business Data Analyst jobs
- Open Product Data Analyst jobs
- Open Data Quality Analyst jobs
- Open Data Manager jobs
- Open Sr. Data Scientist jobs
- Open Big Data Engineer jobs
- Open Data Scientist II jobs
- Open Business Intelligence Developer jobs
- Open Data Analyst Intern jobs
- Open ETL Developer jobs
- Open Principal Data Scientist jobs
- Open Azure Data Engineer jobs
- Open Data Product Manager jobs
- Open Business Intelligence-related jobs
- Open Data quality-related jobs
- Open Privacy-related jobs
- Open Data management-related jobs
- Open GCP-related jobs
- Open Java-related jobs
- Open ML models-related jobs
- Open Finance-related jobs
- Open Data visualization-related jobs
- Open Deep Learning-related jobs
- Open APIs-related jobs
- Open PyTorch-related jobs
- Open PhD-related jobs
- Open Consulting-related jobs
- Open TensorFlow-related jobs
- Open Snowflake-related jobs
- Open NLP-related jobs
- Open Data governance-related jobs
- Open Data warehouse-related jobs
- Open Airflow-related jobs
- Open Hadoop-related jobs
- Open Databricks-related jobs
- Open LLMs-related jobs
- Open DevOps-related jobs
- Open CI/CD-related jobs