Data Architect
Location: Portsmouth, New Hampshire
Date Posted: 03 Sep, 2019
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