Data Architect Job at Abode Techzone LLC, Philadelphia, PA

  • Abode Techzone LLC
  • Philadelphia, PA

Job Description

Data Architect with Payer Domain experience

Remote with Occasional Travel to Clients Office at Philadelphia PA

12 Months Contract OR Full Time

Must Have Skills

Erwin Data Modelers

Very strong knowledge in SQL / Advance SQL

Familiarity with a good reporting tool e.g. Power BI

Payer Experience and Government Programs - Medicare and Medicaid

The Enterprise Data Architect's role is to strategically design and implement data warehouses, data marts, and data stores while ensuring high levels of data availability for the data analytics team and for other business units. This individual is also responsible for working with the data analytics team and defining data standards and models for warehouse architectures. The Enterprise Data Architect will also assist in evaluating and selecting infrastructure components such as software, hardware, database management systems, and networking capabilities.


Assess and cultivate long-term strategic goals for data warehousing in conjunction with the enterprise data analytics team, data users, department managers, clients and other key stakeholders.

Work with other technical staff to develop database architectures, coding standards, and quality assurance policies and procedures.

Work with enterprise architect and other technical staff to design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective availability, protection, and integrity of data assets.

Conduct research and make recommendations on data warehouse products, services, protocols, and standards in support of procurement and development efforts.

Oversee data collection and master data and database(s).

Work with end users to identify, create, and deliver reports according to requirements.

Design and manage data warehouse improvement and growth projects.

Identify inefficiencies and gaps in current data extraction and reports and leverage solutions to ensure data standards.

Identify data discrepancies and data quality issues, and work to ensure data consistency and integrity.

Work with technical staff to monitor system details within the data warehouse, including stored procedures and execution time, and implement efficiency improvements.

Develop, implement, and maintain change control and testing processes for modifications on data systems.

Perform other duties as assigned or directed.

Minimum Qualifications:

Education Requirements:

Bachelor's degree in computer science, engineering, or comparable course of study

The following certifications are preferred, but not required:

Certified Data Management Professional (CDMP)

The Open Group Architecture Framework (TOGAF)

Microsoft Certified - Azure Data Engineer Associate or Azure Solution Architect Expert

Skills / Competencies:

Background working in the Healthcare Insurance industry is required.

Experience with Power BI, MS Azure Stack, and MS Azure Data Factory.

Managerial technical experience with designing, building, installing, configuring, and supporting enterprise data warehouses.

Experience with database platforms.

Strong knowledge of healthcare data, Medicare and Medicaid workflows, data analytics fundamentals, and technology.

Strong knowledge of data governance and compliance.

Strong understanding of relational database structures, theories, principles, and practices.

Hands-on experience with data architecting, data mining, large-scale data modeling, and business requirements gathering/analysis.

In-depth technical knowledge of network, PC, and platform operating systems.

Proven project management experience

Good knowledge of applicable data privacy practices and laws.

Strong written and oral communications skills.

Exceptional analytical, conceptual, and problem-solving abilities.

Ability to present ideas in user-friendly language.

Requires at least 8 years of experience responsible for the analysis and design of data models at the conceptual, logical, and physical levels and for the development and maintenance of existing enterprise models.

Requires at least 6 years of experience in building business semantic layer and canonical models.

Demonstrated ability to understand, produce, and extend large and complex data models for operational and dimensional reporting data stores.

Experience coordinating information requirements of multiple departments, including assessment of usefulness, reliability, and cleanliness of data from several sources.

Ability to effectively present complex technical information to non-technical audiences and to senior decision-makers

Strong SDLC knowledge, with excellent process and Strong SDLC knowledge, with excellent process and application system documentation skills

Solid understanding of Data Management and Metadata Management processes and principles, with the ability to effectively communicate and sell those ideas to others.

Demonstrated success working in a team-based environment.

Requires strong decision-making, organizational, planning, and problem-solving skills.

Excellent analytical skills are required.

Strong facilitation and negotiation skills are required.

Strong communication skills are required; technical and business writing skills are required.

Strong interpersonal skills, with competence in interfacing with business users required.

Ability to summarize and present design alternatives.

Ability to influence and sell soundness of design and deliverables.

Job Tags

Permanent employment, Full time, Contract work, Remote job,

Similar Jobs

The New School

Research Assistant for Beauty Documentary Job at The New School

 ...and purpose. The RA will investigate the existing academic literature on beauty, as in neuroaesthetics, semiotics, sociology, anthropology, media theory, etc etc. In addition, we would like to compile a review of all documentary and feature films revolving around... 



**SENIOR INTERIOR DESIGNER****Job no:** 253991-AS **Work type:** Partial Remote, Staff-Full Time **Department:**FP&M/CPD/CPD **Location:** Madison **Categories:** Architecture and Engineering Services Job Summary: Facility Planning & Delivery (FP&D), part... 

Walbec Group

Small Engine/Small Tool Repair Technician Job at Walbec Group

 ...Job Description Job Description Small Engine/Small Tool Repair Technician Zenith Tech a Walbec Group Company Waukesha, WI. Are you looking for an exciting career supporting our operations in road, highway, and bridge construction? Zenith Tech of the Walbec... 

Southern District YMCA Camp Lincoln

Summer Camp Counselor Job at Southern District YMCA Camp Lincoln

 ...Temporary Description POSITION SUMMARY: The YMCA's Camp Lincoln in Kingston NH is now hiring for the 2024 camp season (June...  ...This is a great seasonal opportunity where you will enjoy the summer being outdoors, on a lake, doing fun activities and making money... 

Pet Pros

Store Manager Job at Pet Pros

 ...General A Bentley's Pet Stuff Store Manager is responsible for establishing, providing and maintaining outstanding guest services...  ...and learning new systems and software. Basic understanding of Microsoft Office software including Excel, Word, Outlook Supervisory...