MCPNew: now works with Claude & AI assistants
crystalrunhealthcare1

crystalrunhealthcare1

Data Architect

Role

Data Architect

Job type

Full-time

Found on Mokaru

114 months ago

Share this job

Salary

Not disclosed by employer

Job description

The Data Architect position requires a high level of
analytical and creative skills, along with in-depth knowledge of data systems
and database methodology, design and modeling.
The Data Architect
will be responsible for designing logical models for relational and
multi-dimensional data stores and subsequently building the physical database
model. The architect defines
data/information architecture standards, processes and data warehouse policies
and procedures. This role facilitates standard business analysis practices and
their translation into functional technical requirements that are integrated
into the enterprise information system architecture. The Data Architect ensures
enterprise solution development is suitable to achieve consistency of
information assets across the application framework.



DUTIES AND
RESPONSIBILITIES



  • Perform source system analysis and meet with
    business stakeholders in order to create appropriate requirement definition
    artifacts.

  • Work closely with Business Intelligence Analysts, Data
    Analysts and Software Developers to ensure customer needs are being met in the
    areas of reporting and analytics.

  • Design and develop highly scalable and optimized
    data models, by utilizing modeling software to document and maintain versions
    to support Data Marts, Cubes, Data Warehouse, and Operational Data Stores
    (ODS).

  • Develop data standards in terms of nomenclature,
    storage, design and deployments.

  • Design ETL and ELT guidelines to ensure efficient
    and accurate data transfer within the entire BI System.

  • Assist with optimizing source system replication
    models and operations

  • Implement a robust data solution using available
    database tools.

  • Design and maintain enterprise meta-data solution to
    communicate data definitions to the BI audience.

  • Design and develop data quality rules for Data
    Warehouse and Data Mart solutions to ensure data integrity levels are met.

  • Research new database technologies and recommend
    solutions in order to improve performance, scalability, & storage.

  • Must be able to communicate timely and
    effectively in order to plan and coordinate team resources.

  • Train, lead, and mentor staff that may include
    database engineers, data architects, and DBAs

  • Providing leadership in establishing and
    documenting data standards

  • Creating and testing database prototypes

JOB REQUIREMENTS



  • Bachelor’s degree in computer science,
    information systems or a related field, Masters preferred; or equivalent relevant
    experience

  • Minimum 7 years of experience in computer
    science, information systems or a related field, plus several years of
    experience working with major database platforms, such as Microsoft SQL Server,
    Oracle and IBM DB2. Microsoft SQL Server
    is preferred.

  • Experience with building and maintaining physical
    and logical database models

  • Knowledge of a typical Software Design Lifecycle
    (SDLC)

  • Knowledge of Master & Meta data management
    tools and techniques

  • Experience with MS SQL Server and the MS development
    stack

  • Knowledge of clinical and financial systems within
    a Healthcare environment desired

  • Knowledge of Data profiling and data validation
    tools

  • Knowledge of Data Matching, Data Monitoring, Data
    Enrichment & Data Standardization

All your information will be kept confidential according to EEO guidelines.

Resume ExampleCover Letter Example

Explore more