Cloud Data Architect | 889389

Revel IT

Apply Now

Our client has a permanent to hire opportunity for a Cloud Data Architect
Positions is based out of Boston, but the team appears to be remote-based currently. We would require candidates to be based locally within the MA area (or RI or NH)
Cloud Data Architect
Job Summary:

  • The Cloud Data Architect is a member of BILH’s Enterprise Data and Analytics team.
  • This role uses HealthCare Domain knowledge to assist and work closely with the leadership Team in designing, architecting and developing data warehousing solutions catering to the current landscape across different hospitals and bringing the data solutions together to serve the Enterprise.
  • The Architect interfaces with business teams and other Technologists to develop the right solutions for the business that are flexible and scalable.
  • He /She must be a self-driven individual who can work with data stewards, Technology leads, Developers and stakeholders across the health system and mentor other data analysts, Data Engineers, and Report writers on Data Management side in the team.
  • The individual in this role must bring a strong combination of Business, Architecture, and Technology acumen and be able to provide solutions that balance the unique needs of both the business and technology.

Primary Responsibilities:

  • Responsible for designing and developing multiple data streams and data services portfolios that include Analytics Frameworks, Data Engineering pipelines, data portals and Data Governance tools. Designing and Developing code using various ETL and Reporting tools ‘ SSAS, Informatica, Power BI, Tableau etc. with EPIC as the primary source system.(essential) 
  • Expertise in creating data pipelines on Cloud Platforms (AWS, Azure, GCP) using ADLS Gen2, Databricks, Snowflake/Synapse/Redshift etc. Manage build phase and quality assure code to ensure fulfilling requirements and adhering to ETL architecture. (essential)
  • Identify, recommend and implement ETL process and architecture improvements. Use hands-on approach to provide solutions and follow standard project lifecycle and development methodologies. (essential)
  • Knowledge of EPIC cogito Analytics Framework including caboodle, Clarity and Reporting workbench (RWB). Has Exposure to IoT data sets, NoSQL data bases and Data Services using API’s. Extensive knowledge of state-of-the-art technologies, frameworks, and libraries of the specific technological domain of the Hadoop ecosystem (HDFS, Apache Spark, Apache Ni Fi, Sqoop, Hive). (essential)
  • Develop best practices and routines to ensure for the data accuracy and integrity. Monitor and Manage existing data mart and data feed routines/ETL Jobs. Monitor and Manage ADT HL7 and CCD data Feeds. Design ETL Framework and add enhancements to the existing ETL Jobs as business demands. (essential)
  • Work collaboratively with different teams to smoothly slide the project from various environments to production. Effectively analyze, troubleshoots issues, defects encountered in applications and follow-up with vendor support team on product defects. (essential)
  • Work with the business systems architects and application developers to streamline data governance, data cleansing, data normalization and usage patterns. Design, build and deploy streaming and batch data pipelines capable of processing and storing large amounts of data quickly and reliably. (essential)
    Perform data evaluation, data profiling, and identification of potential problem areas and make appropriate recommendations. (essential)
  • Work on Analysis of requirements and design solutions to meet business requirements. Provide design proposals following best practices considering data, business and service layers for all system changes such as defects, business impacts, work prioritization and estimation. (essential)
  • Ability to Program in SQL, Python, Linux bash, and cloud services APIs to automate the processing of patient-level healthcare transactions and aggregated public health data. Experience in Data Science/ML is a plus. (essential)


Required Qualifications:

  • Bachelor’s degree required.
  • 5-8 years related work experience required in data disciplines (data design/architecture, data modeling, integration, business intelligence, or analytics.).
  • Solid experience in Designing and developing Data warehouses and BI systems along with other data governance initiatives. Extensive experience for collecting business requirements from customers and aligning them with organization objectives and direction.
  • Solid working experiences on: Data Warehouse, Data Modelling and ETL Concepts. RDBMS concepts, SQL and NoSQL Queries and Performance tuning. Health care standards like HL7, CCD and FHIR, and Coding systems (like ICD, CPT etc.)
  • Advanced technical computer skills as required for technical support specific to functional area and related systems.


  • Decision Making: Ability to make decisions that are guided by precedents, policies and objectives. Regularly makes decisions and recommendations on issues affecting a department or functional area.
  • Problem Solving: Ability to address problems that are highly varied, complex and often non-recurring, requiring staff input, innovative, creative, and Lean diagnostic techniques to resolve issues.
  • Independence of Action: Ability to set goals and determines how to accomplish defined results with some guidelines. Manager/Director provides broad guidance and overall direction.
  • Written Communications: Ability to summarize and communicate in English moderately complex information in varied written formats to internal and external customers.
  • Oral Communications: Ability to comprehend and communicate complex verbal information in English to medical center staff, patients, families and external customers.
  • Knowledge: Ability to demonstrate in-depth knowledge of concepts, practices and policies with the ability to use them in complex varied situations.
  • Team Work: Ability to lead collaborative teams for larger projects or groups both internal and external to the Medical Center and across functional areas. Results have implications for the management and operations of multiple areas of the organization.
  • Customer Service: Ability to provide a high level of customer service to patients, visitors, staff and external customers in a professional, service-oriented, respectful manner using skills in active listening and problem solving. Ability to remain calm in stressful situations.


Reference: 889389

Don’t meet every single requirement? Studies have shown that women and people of color are less likely to apply to jobs unless they meet every qualification. At Revel IT, we are dedicated to building a diverse, inclusive, and authentic workplace, so if you’re excited about this role, but your experience doesn’t align perfectly with every qualification in the description, we encourage you to apply anyway. You might be the right candidate for this or our other open roles!  

Revel IT is an Equal Opportunity Employer. Revel IT does not discriminate on the basis of race, religion, color, sex, gender identity, sexual orientation, age, non-disqualifying physical or mental disability, national origin, veteran status or any other basis covered by appropriate law. All employment is decided on the basis of qualifications, merit, and business need.


Apply Now

  • Hidden
  • Max. file size: 128 MB.
  Apply with Google   Apply with Twitter
  Apply with Github   Apply with Linkedin   Apply with Indeed
  Stack Overflow