Lead Data Engineer/Architect

DCI Marketing; Karnataka; On-site; INR 15,00,000 - 20,00,000; Full time

Job summary

A leading marketing firm in Karnataka is seeking an experienced professional for a lead role in Business Intelligence and Analytics. You will translate functional requirements into effective designs, transform data into business decisions, and support Snowflake services. The ideal candidate has 8-10 years of experience in data architecture, strong knowledge of Snowflake DB, and excellent problem-solving skills.

Qualifications

• 8-10+ years of experience in data architecture and management.
• Experience with Snowflake DB and strong programming knowledge.
• Experience in writing complex SQL queries across large datasets.

Responsibilities

• Translate functional requirements into development specifications.
• Transform data into actionable business insights.
• Architect and support Snowflake services.

Skills

Data architecture and management

Snowflake DB programming

Data modeling tools

Machine learning methods

Complex SQL queries

Data pipelines management

MS SQL Server

Tools

Snowflake

Azure SQL DB

Google Analytics

Job description

DCI Marketing, Inc. is part of the global industrial organization Marmon Holdings, which is backed by Berkshire Hathaway. We are committed to making a positive impact on the world, providing diverse learning and working opportunities, and fostering a culture where everyone is empowered to be their best.

The DCI Marketing Team is seeking an experienced and highly motivated professional to work in an individual contributor (IC) lead role for the Business Intelligence and Analytics team. This role is both hands-on and serves to meet timelines and quality requirements. The candidate will assist with building a functional Analytics Center of Excellence practice in both custom and purchased platform environments.

Key Responsibilities / Functions

• Translate functional and non-functional requirements into effective designs and development specifications.
• Responsible for transforming Data into Information, Knowledge, and Business Decisions
• Delivers extensive data warehouse, data mart, and dimensional models for Analytics Center of Excellence.
• Responsible for streamlining dataflow pipelines across various programs and products.
• Responsible for identifying trends and patterns in data leading to increased effectiveness of digital programs.
• Responsible for Data related documentation and visual communications.
• Provide guidance to other delivery and operations team members.
• Architect, design, develop, and support Snowflake services and warehouse.

Required Qualifications

• 8-10+ years of experience in data architecture and management.
• Experience with Snowflake DB (strong programming knowledge using Snowflake, SnowSight, and Snowpipes) is a requirement.
• Experience with data modeling tools and techniques is essential, including Data warehouse, OLAP/Cube, Tabular Model/Cube design experience using Kimball Method best practices.
• Experience in the use of machine learning methods, such as linear regression, correlation, and statistical modeling.
• Experience with MS SQL Server, Cosmos DB
• Experience in writing complex, highly optimized SQL queries across large data sets.
• Experience in managing Data pipelines.
• Azure MSBI Architect/Develop Experience (Azure SQL DB, ADLS, Azure DW, ADF)
• Google Analytics and Social Media Analytics experience desired. Prescriptive/predictive analytics experience desired.
• Experience implementing Database Management Systems for custom developed and purchased business applications.

Personal Characteristics and Attributes

• Solid English written and verbal communication skills.
• Able to engage other leaders to understand strategy, articulate options, evaluate tradeoffs, and influence key decisions.
• Strong analytical and complex problem-solving skills.
• Inquisitive nature and self-starter who can implement with minimal guidance.
• Ability to communicate complex information to technical and non-technical stakeholders.
• Strong desire to learn new technologies and methodologies
• Senior technical expert that has worked with global teams and mentors other team members

Following receipt of a conditional offer of employment, candidates will be required to complete additional job-related screening processes as permitted or required by applicable law.