Technical Lead Data Engineer - Power BI

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 Requirement: 

• Design, develop, optimize, and maintain data architecture and pipelines that adhere to ETL principles and business goals 
• Solve complex data problems to deliver insights that helps business to achieve their goals 
• Create data products for analytics and data scientist team members to improve their productivity 
• Advise, consult, mentor and coach other data and analytic professionals on data standards and practices 

• Foster a culture of sharing, re-use, design for scale stability, and operational efficiency of data and analytical solutions 
• Lead the evaluation, implementation and deployment of emerging tools and process for analytic data engineering in order to improve our productivity as a team 
• Develop and deliver communication and education plans on analytic data engineering capabilities, standards, and processes 
• Partner with tribe members and solutions architects to develop technical architectures for strategic projects and initiatives. 
• Learn about machine learning, data science, computer vision, artificial intelligence, statistics, and/or applied mathematics 

Skills: - 

▪Bachelor’s degree required; Computer Science, MIS, or Engineering preferred 

▪5 years of experience working in data engineering or architecture role 

▪Expertise in SQL and data analysis and experience with at least one programming language (Python or Scala preferred) 

▪Experience developing and maintaining data warehouses in big data solutions 

▪Experience with developing solutions on cloud computing services and infrastructure in the data and analytics space (preferred) 

▪Database development experience using Hadoop or Big Query and experience with a variety of relational, NoSQL, SAP BW and cloud database technologies 

▪Worked with BI tools such as Tableau, Power BI, Looker, Shiny 

▪Conceptual knowledge of data and analytics, such as dimensional modeling, ETL, reporting tools, data governance, data warehousing, structured and unstructured data. 

▪Exposure to machine learning, data science, computer vision, artificial intelligence, statistics, and/or applied mathematics. 

• ▪Experience in Tableau or any others tools would be an advantage 
• ▪Experience in ETl/ Data Eng will be good 
• ▪Exposure to machine learning, data science, computer vision, artificial intelligence, statistics, and/or applied mathematics 
• Python and cloud experience would be added advantage. 

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. 

• Business Development: 

Work with pre-sales and practice on business development and existing growth opportunities in terms of discovery, solution options, evaluation, estimation, training and creation of collaterals 

• Customer Relationship Management: 

Contribute to continuous service improvement plans (CSI). 

• Knowledge Management: 

Contribute and participate proactively in knowledge sharing sessions. 

• Audits 

Participate in security and compliance audits. 

What you will get: 

1. Competitive Salaries with flexi benefits  

1. Group Mediclaim Insurance and Personal Accidental Policy 

1. 30 Paid Leaves in a year  

1. Learning and Development of quarterly budgets for certification