Database Developer

Wellesley, MA

Posted: 03/20/19 Category: Database/Data Warehousing Job Number: 7486

Position Title: Database Developer

Job Location:  Wellesley, MA

Interview Expectations:  phone & on-site

Local Candidate: not required

Required Skill Sets: Developer with 10-15 yrs experience. Strong SQL Server experience. Knowledgeable & able to work with .NET. Must have some architecture or designing experience.  Some insurance experience preferred. 

Vertafore AMS360 experience &  Cloud migration experience are nice to haves.

 

Job Description:

Our client has a unique aggregated data asset that includes insurance transactional and risk data with vast opportunities for value creation. They are seeking a Data Warehouse Engineer to maintain and enhance its existing data pipelines. The Data Warehouse Engineer would be responsible for all data extraction, cleaning, and storage of data, as well as implementing automated procedures. The Data Warehouse Engineer would work directly with the Chief Data Scientist and Chief Technology Officer to drive the company’ s technology agenda.

 

Position Overview:
  • Understand the existing environment, develop a long-term data management strategy, make data more readily accessible to the business
  • Bring a security-first mentality to ensure the safety and privacy of our data
  • Maintain the data warehouse environment and all associated pipelines to ensure critical applications run smoothly
  • Support the creation of a business intelligence environment and delivery of business insights to our end-users
  • Develop and execute a plan to improve the dataset over time and make recommendations to enhance the value going forward
  • Maintain data catalogs and data validations to ensure clarity and correctness of key business metrics
  • Drive and maintain a culture of quality, innovation and experimentation
  • Help drive the technology agenda of the company, maintain a culture of quality, innovation, and experimentation

 

Requirements:
  • Bachelor’ s or Masters Degree in Computer Science, Statistics, or other quantitative field
  • 5+ years of experience building and maintaining relational databases in a cloud-based environment
  • 5+ years of previous experience supporting data warehouse implementations
  • 5+ years ETL/ELT development
  • 5+ years of experience in relational and data warehouse database design, optimization and performance; preferably with MS SQL Server
  • Demonstrated expertise around Microsoft SQL Server and SSIS
  • Database administration skills is a plus
  • Strong understanding of the concepts and best practices of data warehouse design
  • Strong SQL query writing and knowledge of SQL objects
  • Proficient in building data pipelines from diverse data sources and integrated with multiple front-end applications
  • Basic SSRS/SSAS knowledge
  • 2+ Experience with Data profiling
  • Proficient in multiple general purpose object-oriented programming languages
  • Proficiency in requirements analysis, reporting build, or other data management related experience
  • Ensure systems meet industry best practices and business, security, privacy, and retention requirements
  • Experience in disaster recovery procedures
  • Experience working with insurance industry data is preferred, but not required

 

Tools and Technology

Must Have:
  • Microsoft SQL server 2014 or above
  • SQL query writing
  • Microsoft SSIS/SSRS 2012 or above
  • SQL Server Management Studio
  • Data Profiling

Preferred/Optional:
  • Microsoft SSAS
  • Power BI
  • XML
  • Other database knowledge such as Oracle, Access etc

Lindsay Melanson

Contact Lindsay today to learn more about this great opportunity!

Send an email reminder to:

Share This Job:

Related Jobs:

Login to save this search and get notified of similar positions.