Data Architect

2 weeks ago


Massachusetts, United States codeforce360 Full time

Required Skills:SQL.CDMP or similar certification. Hands on experience with ETL tools and processes.Familiarity with AWS hosting.Basic Qualifications:Bachelor’s degree in Computer Science, Computer Information Systems, Information Management or equivalent work experience.Proven track record of designing and implementing complex and large scale Enterprise Databases.+10 years of o designing relational database creating conceptual, logical and physical data models documenting databases using Entity Relationship Models and Data Dictionaries writing SQL scripts working in a software development environment.Deep understanding of database concepts, data domain concepts, security concepts, Normal Forms, Data.Job Summary:The Senior Database Analyst/Designer will work on the Data Cleanup and Standardization project at the Registry of Vital Records and Statistics (RVRS) in Dorchester, MA. Goal of the project is to consolidate the data from multiple data sources on multiple platforms into one single SQL Server instance which will become the Operational Datastore (ODS) at RVRS.This project is part of a larger program to modernize all the IT environment at RVRS. The Senior Database Analyst/Designer will work closely with the staff at the RVRS, the IT Application Manager, ETL Developer/s and a Senior IT Project Manager as well as a Business Analysts to analyze and document the current data sources and generate work instructions for the ETL Developer/s.Job Duties:  (Detailed list of Duties and Responsibilities):Create and maintain an inventory of all data sources in use by RVRS.Create and maintain a data dictionary for all data sourcesDesign data/table structure on a staging environmentTranslate business rules and requirements into design specifications for data standardization, normalization/de-normalization, access security...Create a data model and Data Dictionary for all data domains/entities (Birth, Death, Fetal Death, Marriage, Divorce, Providers, Morgues....) on the ODSTranslate requirements and business rules into instructions for ETL programmer and SQL developers to write the transition scriptsWrite test plans and acceptance criteriaQualifications:  (Special Skill sets, Education or Experience):Bachelor’s degree in Computer Science, Computer Information Systems, Information Management or equivalent work experience.Proven track record of designing and implementing complex and large scale Enterprise Databases.+10 years of Designing relational database.Creating conceptual, logical and physical data models.Documenting databases using Entity Relationship Models and Data Dictionaries. Writing SQL scripts.Working in a software development environment. Deep understanding of database concepts, data domain concepts, security concepts, Normal Forms, Data Warehousing. Eliciting and writing requirements, design specifications and work instructions for developers.Strong Project Management and leadership skills.Working through ambiguity.Communicating clearly with technical and non-technical stakeholders.CDMP or similar certification.Hands on experience with ETL tools and processes.Familiarity with AWS hosting.Experience working in a healthcare environment.Experience working with PHI.Experience:10+ yearsSkills:Aws, SQL, ETL


  • Data Architect

    4 days ago


    Massachusetts, United States Horizontal Full time

    Requirements BS Degree in Computer Science or a related fieldProven experience as a Cloud Data Architect or in a similar role, with a focus on designing and implementing cloud-based data architectures.10+ years experience, ideally from a data engineering backgroundStrong knowledge in GCPSQL and Python for data manipulation and transformation.

  • Data Architect

    4 weeks ago


    Boston, Massachusetts, United States Publicis Sapient Full time

    Job Description Publicis Sapient is looking for a Data Architect to join our team of bright thinkers and doers. You will team with top-notch technologists to enable real business outcomes for our enterprise clients by translating their needs into transformative solutions that provide valuable insight. Working with the latest data technologies in the...


  • Waltham, Massachusetts, United States Dynatrace Full time

    Job Description Define target state architecture and develop phased roadmaps that front load business value and deliver critical capabilities to enable digital transformation.   Work with Solution architects, Business teams, Product Owners, Business Systems Analysts, Developers to define end to end architecture that incorporates application, information,...


  • Boston, Massachusetts, United States Publicis Sapient Full time

    Job Description Job Description A  Manager Data Engineering Google Cloud Platform (GCP) is responsible for leading and managing a team of GCP experts and engineers to develop and deliver effective cloud solutions for clients. This position requires in-depth knowledge and expertise in GCP services, architecture, and best practices. The Manager will work...


  • Boston, Massachusetts, United States Publicis Sapient Full time

    Job Description Publicis Sapient is looking for a Manager, Data Engineer - GCP to join our team of bright thinkers and doers. You will team with top-notch technologists to enable real business outcomes for our enterprise clients by translating their needs into transformative solutions that provide valuable insight. Working with the latest data technologies...


  • Massachusetts, United States Evenbreak Full time

    Job DetailsCompanyJob Description As a Dynamics 365 CRM Solution Architect, you are considered a Solution Specialist and have in depth knowledge of D365 CE and Power Platform. You are energetic and passionate about Dynamics 365 CE and the Power Platform and how it can be used to solve complex business problems. You have in-depth knowledge of Dynamics 365 CE...


  • Boston, Massachusetts, United States Sleeping Dog Properties Full time

    We are looking for a thorough Construction estimator to calculate possible costs and gains of construction projects. You will collect and analyze data according to a series of useful variables. The ideal candidate will be very comfortable with numbers and analytical. You must have great attention to detail and excellent communication skills. The goal is to...


  • Boston, Massachusetts, United States Publicis Sapient Full time

    Job Description Your Impact:  Clients You are focused on designing and implementing customer and patient centric journeys, ensuring interoperability and optimize collaboration among players using a variety of Martech SAAS platforms. Lead the development of multi-year business capability roadmaps for a company’s business units such as Marketing, Sales,...


  • Needham, Massachusetts, United States CJ Full time

    Job Description Location: Needham, MA   The Client Integration Engineer is the main technical resource who works cross-functionally and with clients to demonstrate the value of CJ’s products and provide guidance on the product roadmap. It is a unique hybrid role that combines aspects of a web technologist, business analyst, and solutions...

  • Sales Engineer

    2 weeks ago


    Needham, Massachusetts, United States CJ Full time

    Job Description Location: Needham, MA   The Sales/Client Integration Engineer is the main technical resource who works cross-functionally and with clients to demonstrate the value of CJ’s products and provide guidance on the product roadmap. It is a unique hybrid role that combines aspects of a web technologist, business analyst, and solutions...

  • Solutions Engineer

    2 weeks ago


    Needham, Massachusetts, United States CJ Full time

    Job Description Location: Needham, MA   The Solutions Engineer (Client Integration Engineer) is the main technical resource who works cross-functionally and with clients to demonstrate the value of CJ’s products and provide guidance on the product roadmap. It is a unique hybrid role that combines aspects of a web technologist, business analyst, and...

  • Sales Engineer

    20 hours ago


    Needham, Massachusetts, United States CJ Full time

    Job Description     Location: Needham, MA   The Sales Engineer/Client Integration Engineer is the main technical resource who works cross-functionally and with clients to demonstrate the value of CJ’s products and provide guidance on the product roadmap. It is a unique hybrid role that combines aspects of a web technologist, business analyst, and...

  • Solutions Engineer

    20 hours ago


    Needham, Massachusetts, United States CJ Full time

    Job Description     Location: Needham, MA   The Client Integration Engineer/Solutuons Engineer is the main technical resource who works cross-functionally and with clients to demonstrate the value of CJ’s products and provide guidance on the product roadmap. It is a unique hybrid role that combines aspects of a web technologist, business analyst,...

  • Sr. Software Engineer

    4 weeks ago


    Springfield, Massachusetts, United States Blackhawk Network Full time

    About Blackhawk Network: Blackhawk Network is building a digital platform and products that bring people and brands together.  We facilitate cross channel payments via cash-in, cash-out and mobile payments. By leveraging blockchain, smart contracts, serverless technology, real time payment systems, we are unlocking the next million users through...

  • Programmer Analyst

    3 weeks ago


    Boston, Massachusetts, United States Tufts University Full time

    Overview: The mission of the USDA Human Nutrition Research Center on Aging at Tufts University (HNRCA) is to promote healthy aging through nutrition science to empower people seeking to enjoy long, active, and independent lives. HNRCA investigators examine how nutrition and physical activity play a role in the prevention of the major chronic degenerative...


  • Natick, Massachusetts, United States Gallagher Full time

    About Us: Indulge your passion for problem-solving and embrace the thrill of addressing risk head-on at Gallagher's global brokerage team. Join a family of diverse minds, united by a relentless pursuit of excellence. As part of our team, you'll be the architect of protection, safeguarding businesses and empowering their ambitions. Together, we'll build a...


  • Natick, Massachusetts, United States Gallagher Full time

    About Us: Indulge your passion for problem-solving and embrace the thrill of addressing risk head-on at Gallagher's global brokerage team. Join a family of diverse minds, united by a relentless pursuit of excellence. As part of our team, you'll be the architect of protection, safeguarding businesses and empowering their ambitions. Together, we'll build a...