The Data Architect role involves designing and managing data systems, building ETL jobs, and ensuring data quality and integrity across projects for the Marketing team.
Position description:
Our ideal Advanced Data Engineer is a collaborative leader skilled in data analytics, data modeling, and database design. You're also committed to data integrity, are highly analytical, and can work on multiple projects at once. You'll use your skills to develop, monitor, and manage data systems across our platform. You will work on a variety of projects supporting the Marketing organization.
Key responsibilities and accountabilities:
Design, build, and measure complex ETL jobs to process disparate data sources and form a high integrity, high quality, clean data asset.
Working on a range of projects including batch pipelines, data modeling, and data mart solutions you'll be part of collaborative project teams working to implement robust data collection and processing pipelines to meet specific business need.
Goals:
Design, build, and measure complex ETL jobs to process disparate data sources and form a high integrity, high quality, clean data asset.
Executes and provides feedback for data modeling policies, procedure, processes, and standards.
Assists with capturing and documenting system flow and other pertinent technical information about data, database design, and systems.
Develop data quality standards and tools for ensuring accuracy.
Work across departments to understand new data patterns.
Translate high-level business requirements into technical specs.
Knowledge, skills and abilities ,Education & Experience
Required:
Bachelor's degree in computer science or engineering.
10+ years of experience with data analytics, data modeling, and database design.
10+ years of coding and scripting (Python, Java, Scala) and design experience.
Having experience working on Clickstream data.
Experience with ETL/ELT methodologies and tools.
Experience with Vertica OR Teradata
Expertise in tuning and troubleshooting SQL.
Strong data integrity, analytical and multitasking skills.
Excellent communication, problem solving, organizational and analytical skills.
Able to work independently.
Additional / preferred skills:
Familiar with agile project delivery process.
Knowledge of SQL and use in data access and analysis.
Experience with Airflow.
Ability to manage diverse projects impacting multiple roles and processes.
Able to troubleshoot problem areas and identify data gaps and issues.
Ability to adapt to fast changing environment.
Experience with Python.
Basic knowledge of database technologies (Vertica, Redshift, etc.).
Experience designing and implementing automated ETL processes.
Our ideal Advanced Data Engineer is a collaborative leader skilled in data analytics, data modeling, and database design. You're also committed to data integrity, are highly analytical, and can work on multiple projects at once. You'll use your skills to develop, monitor, and manage data systems across our platform. You will work on a variety of projects supporting the Marketing organization.
Key responsibilities and accountabilities:
Design, build, and measure complex ETL jobs to process disparate data sources and form a high integrity, high quality, clean data asset.
Working on a range of projects including batch pipelines, data modeling, and data mart solutions you'll be part of collaborative project teams working to implement robust data collection and processing pipelines to meet specific business need.
Goals:
Design, build, and measure complex ETL jobs to process disparate data sources and form a high integrity, high quality, clean data asset.
Executes and provides feedback for data modeling policies, procedure, processes, and standards.
Assists with capturing and documenting system flow and other pertinent technical information about data, database design, and systems.
Develop data quality standards and tools for ensuring accuracy.
Work across departments to understand new data patterns.
Translate high-level business requirements into technical specs.
Knowledge, skills and abilities ,Education & Experience
Required:
Bachelor's degree in computer science or engineering.
10+ years of experience with data analytics, data modeling, and database design.
10+ years of coding and scripting (Python, Java, Scala) and design experience.
Having experience working on Clickstream data.
Experience with ETL/ELT methodologies and tools.
Experience with Vertica OR Teradata
Expertise in tuning and troubleshooting SQL.
Strong data integrity, analytical and multitasking skills.
Excellent communication, problem solving, organizational and analytical skills.
Able to work independently.
Additional / preferred skills:
Familiar with agile project delivery process.
Knowledge of SQL and use in data access and analysis.
Experience with Airflow.
Ability to manage diverse projects impacting multiple roles and processes.
Able to troubleshoot problem areas and identify data gaps and issues.
Ability to adapt to fast changing environment.
Experience with Python.
Basic knowledge of database technologies (Vertica, Redshift, etc.).
Experience designing and implementing automated ETL processes.
Top Skills
Airflow
Elt
ETL
Java
Python
Scala
SQL
Teradata
Vertica
Similar Jobs at MassMutual India
Big Data • Fintech • Information Technology • Insurance • Financial Services
The Business Analyst will gather requirements, analyze processes, design and implement SAP solutions, provide training, and maintain documentation.
Top Skills:
ConcurSap Analytics CloudSap AribaSap Business Technology Platform (Btp)Sap Extension SuiteSap Integration Suite
Big Data • Fintech • Information Technology • Insurance • Financial Services
This role supervises team members and oversees private equity fund accounting processes, including capital calls, reconciliations, and performance metrics, ensuring accuracy and timely reporting.
Top Skills:
EfrontInvestranMicrosoft Office Suite
Big Data • Fintech • Information Technology • Insurance • Financial Services
The Mainframe Developer will manage incidents, collaborate on troubleshooting, analyze impacts, perform bug fixes, and ensure application stability.
Top Skills:
Ca7CobolCore JavaDb2EzplusInformaticaJclMainframe UtilitiesTws MaestroUdb Stored ProceduresWeb MethodsWeb Sphere
What you need to know about the Boston Tech Scene
Boston is a powerhouse for technology innovation thanks to world-class research universities like MIT and Harvard and a robust pipeline of venture capital investment. Host to the first telephone call and one of the first general-purpose computers ever put into use, Boston is now a hub for biotechnology, robotics and artificial intelligence — though it’s also home to several B2B software giants. So it’s no surprise that the city consistently ranks among the greatest startup ecosystems in the world.
Key Facts About Boston Tech
- Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
- Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
- Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
- Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories
