Data Architect

| Greater Boston Area
SessionM is looking to add a Data Architect to support key initiatives with large enterprise level customers. The ideal candidate will be experienced in building complex data processing pipelines and refined data lakes in Big Data ecosystems using S3, Redshift, EMR and other AWS services. 
The ideal candidate must have a strong background in Data Warehousing Architecture, SQL and data analysis skills. Knowledge of Redshift, Hive and Spark is a must.

Responsibilities

  • Design, implement and support in production Enterprise Data Warehouse and ETL procedures and workflows. 
  • Learn new technologies, improve the existing tools and processes.
  • Onboard new customers. Help with the customer specific data needs: ETL integration with 3rd party data sources and data exports. Custom scripts and procedures.
  • Develop methodology to address various analytic challenges, covering both internal and client-driven needs.
  • Produce and automate the production of necessary reports and analyses. 
  • Perform complex data analysis in support of ad-hoc and standing requests and demand for insights and be able to present results to non-technical audiences.
  • Research new data sources, analytical tools, and methodologies; contribute to new product development, operational delivery, and presentation.

Requirements

  • 5+ years of relevant work experience in data analytics and data warehousing.
  • Prior commercial experience with Big Data AWS services (Spark, Hive and Redshift).
  • Must have work experience in processing data and writing ETL jobs. Should understand data modeling and writing complex SQLs, stored procedures, etc. 
  • Strong diagnostic and insight skills; ability to find trends and patterns in data and explain them clearly.
  • Willingness to work and share with other team members and learn new skills.
  • Prior object oriented or functional programming language experience. 
  • Should have experience in deploying code in production system and supporting it.
  • Demonstrated results orientation and follow-through.

What we’re offering you

  • A unique, supportive, and flexible work environment
  • Challenges related to working in a fast-paced, growing environment
  • A management team that empowers people
  • Competitive compensation based on experience level
  • Flexible PTO
  • Healthcare HMO & PPO
  • 401k
  • Flexible Spending and Transit Reimbursement Accounts
Read Full Job Description

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • .NETLanguages
    • C#Languages
    • GolangLanguages
    • JavaLanguages
    • JavascriptLanguages
    • PythonLanguages
    • RubyLanguages
    • SqlLanguages
    • HadoopFrameworks
    • Node.jsFrameworks
    • Ruby on RailsFrameworks
    • SparkFrameworks
    • CassandraDatabases
    • HiveDatabases
    • MemcachedDatabases
    • Microsoft SQL ServerDatabases
    • MySQLDatabases
    • RedisDatabases
    • JIRAManagement
    • HubSpotCRM
    • SalesforceCRM

Location

Based in the Seaport of Boston, SessionM is lucky to be right on the water, conveniently located by public transport, restaurants, bars and shopping!

An Insider's view of SessionM

What’s the vibe like in the office?

One of the things I am always impressed by when I walk into our offices is how many concurrent conversations and discussions are taking place - near peoples' desks, in the kitchen, on the various couches etc. There is a true sense of collaboration and "problem-solving mode" at all times. It's very energizing and highly motivating!

Matthias

Director, Talent Acquisition

What's the biggest problem your team is solving?

Our clients are committed to providing their customers with best in class omnichannel marketing experiences. We are constantly working to build efficient products allowing for personalization at scale. An exciting challenge on my team is balancing how to capitalize on market opportunities quickly while also taking the time to design an amazing UX!

Christine

Director of Product

What makes someone successful on your team?

Passion, grit, and thirst for learning. It's amazing what you can accomplish when you love the work you do, work hard at it, and never stop honing your craft.

Josh

Senior Director, Strategy & Analytics

What are SessionM Perks + Benefits

Culture
Friends outside of work
Eat lunch together
Open office floor plan
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Retirement & Stock Options Benefits
401(K)
Company Equity
Child Care & Parental Leave Benefits
Flexible Work Schedule
SessionM provides employees with a flexible work schedule that includes flexible start and end times.
Remote Work Program
Vacation & Time Off Benefits
Unlimited Vacation Policy
Generous PTO
Paid Holidays
Perks & Discounts
Beer on Tap
Casual Dress
Commuter Benefits
Company Outings
SessionM hosts company outings Semi-annually - usually a summer outing, and a holiday party!
Stocked Kitchen
SessionM's kitchen has cold brew on tap, endless snacks, candy, and a Bevi seltzer machine!
Some Meals Provided
We provide free breakfast on Friday. Employees get free lunch on Wednesday.
More Jobs at SessionM13 open jobs
All Jobs
Data + Analytics
Dev + Engineer
Internships
Operations
Product
Sales
Sales
new
Boston
Developer
new
Boston
Developer
new
Boston
Data + Analytics
new
Boston
Data + Analytics
new
Boston
Product
new
Boston
Data + Analytics
new
Boston