Technical Lead Data Engineer - Power BI, Tableau

Company Description  

 Material is a modern marketing services firm powered by sophisticated analytics, deep human understanding and a specialized type of creativity, design thinking. Headquartered in LA, the company has grown consistently for nearly 50 years to 1200+ employees in 20 offices including NY, Chicago, San Francisco, Austin, and London. Material has actively acquired a portfolio of businesses to build a unique, integrated marketing services business with key capabilities in analytics, intelligence, and experience for an array of top-tier clients in entertainment, tech, retail, healthcare, and packaged goods.  

We believe people are people, not data points. Diverse and inclusive problem-solving. Data and creativity is complementary and equally essential. Breaking down silos improves efficiency and creativity. Combining people, insights, and ideas uncovers hidden truths. Putting humans at the center of everything we do creates opportunities to improve lives.  

Material is a global strategy, insights, design, and technology partner to companies striving for true customer centricity and ongoing relevance in a digital-first, customer-led world. By leveraging proprietary, science-based tools that enable human understanding, we inform and create customer-centric business models and experiences + deploy measurement systems – to build transformational relationships between businesses and the people they serve.  

Skills and Requirements: 

• 5+ years’ professional experience developing reports using enterprise reporting tools 
• Minimum 4 years’ experience designing and developing dashboards using Tableau Desktop for various organizational metrics and indicators using best practices and industry standards 
• 4 + years of experience with Data Visualization tools such as Power BI & Tableau required; 

• Well organized, with attention to detail and a strong focus on accuracy; 
• Has the ability to work effectively in a fast-paced environment, juggling multiple priorities; 
• You possess demonstrated analytical and critical thinking skills; 
• Data artisan – can tell a story with the data in a dashboard. 
• Highly Experience with Tableau Server and Tableau Desktop across various versions of Tableau 9.x/10.x- Good in BI and data warehousing concepts Experience with BI applications comprised of multiple / inconsistent data sources 

• Understanding of ETL process- good database knowledge and experience, should be able to write complex SQL queries against RDBMS (such as Oracle, MySQL etc.) and NoSQL databases (such as MongoDB, Couchbase etc.) 
• Particularly good understanding of SDLC and Agile processes. 
• Experience in data modelling, data loading, data migration, data analysis (must), along with semantic (business rules) layer implementation 
• Understanding of the Data warehouse life cycle right from data source to ETL to transformations to multidimensional models like data marts, star schema and Reporting 
• Experience with Cloud native BI/ Analytics implementation and service integration 

• Preferred experience with Tableau / Looker / Power-BI / Alteryx 
• Excellent communication and inter-personal skills, accustomed to work in a team environment with tight schedules and capable of working efficiently under pressure 
• Ability to interact with stakeholders throughout the organization 
• Solid understanding of data and database technologies (data analysis, data prep, ETL, ELT, etc.) required; 

Responsibilities: 

Requirement Gathering & Analysis: 

Responsible for participating in business requirements gathering exercise and translating business requirements into functional and technical specifications. 
Participate and provide inputs during requirements feasibility analysis and provide alternate solutions based on application architecture. 
Responsible for functional requirements interpretation and guiding the team on design and development process. 

Technology Review: 

Responsible for end-to-end analysis of the application portfolio and provide inputs for transformation opportunities for a given line of business. 

• Testing: 
  Responsible for creating the test plan and associated functional test cases. 
  Perform functional testing as required for a given release. 
• Project Support: 

 Guide the delivery team during impact analysis of incidents by providing inputs on upstream and downstream dependencies. 
Provide inputs for prioritizing incidents and problems. 
Participate and provide inputs during change impact analysis and prioritization process. 
Assist the delivery team in complying with regulatory and compliance requirements. 
Participate in release acceptance exercise and provide inputs for business signoff. 

People Management: 

Drive the SME development program to assess and develop domain experts. 
Create a career road map for Application SME to become domain experts and track the progress periodically. 

 What you will get: 

1. Competitive Salaries with flexi benefits 
2. Group Mediclaim Insurance and Personal Accidental Policy 
3. 30+ Paid Leaves in a year  
4. Learning and Development of quarterly budgets for certification