Jobs


Data Architect

Location: Portsmouth, New Hampshire
Date Posted: 03 Sep, 2019

Data Architect
Are you a Data Architect looking for a great new opportunity? Our Portsmouth, NH client is poised for growth and ready for you to join their team. This client has a startup feel with a global presence. 

A day in the life: 
•      Help define the next generation data services architecture to support interactive transactions, reporting, and analytics
•      Work with distributed data lakes/marts/storage fabrics deployed at scale in industry leading cloud provider environments
•      Continuously monitor application data storage paradigms to inform product design initiatives
•      Help define modern data wrangling tooling to support client data operations and implementations
•      Design high performing logical and physical data models to support diverse application use cases
•      Work closely with development and operations to optimize data throughput from back end data stores
•      Help the implementation team to develop more complex data transformation techniques
•      Join an architectural discussion to weigh the pros/cons of using SQL versus NoSQL databases
•      Dive deep into query plans to determine why a particular query is not performing well
•      Advocate that HDFS or S3 is a better distributed data fabric based on the use case
•      Troubleshoot why the production Spark job has run out of memory.

Must haves: 
•      Designed, deployed, and optimized logical and physical data models consumed by web-based applications delivered through a cloud-based footprint
•      Practical experience designing role, row, and temporal based data access 
•      Inmon
•      Kimball, OLAP, star and snowflake schemas, dimension and measure tables
•      Cassandra, HDFS, S3, Vertica, Redshift
•      SQL
•      Experience with modern data storage architectures
 
Nice to have: 
•      Linux
•      Java/Scala/Python

Benefits
Medical Insurance
Dental Insurance
Group Term Life Insurance/AD & D
Short & Long-Term Disability Insurance
Flexible Spending Account
Dependent Care
401k Plan
Earned Time Off – vacation, personal, illness
Paid Holidays
Paid Time to Volunteer
Tuition Assistance
Bereavement Time
Breakfast daily, paid lunch 2x/wk, Friday hors d’oeuvres