Data Solutions Architect /Data Architect/Data Modeler

Dice is the leading career destination for tech experts at every stage of their careers. Our client, URSI Technologies Inc., is seeking the following. Apply via Dice today!

• All roles required: Payer domain exp(Cigna/UHG/Optum/ blue cross blue shield ETC) with Medicaid/ medicare
• Experience in processing claim files, Payment Schedules for Medicare, Medicaid, Fee schedules, Eligibility files, RX files from multiple states
• Remote with Occasional Travel to AmeriHealth Office
• If the candidate holds every skill mentioned below, request to shoot your resume to benchsales (dot) ursitech (at) gmail (dot) com

The Enterprise Data Solution 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.

• 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

• 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 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.

• Erwin Data Modelers (must have)
• Very strong knowledge in SQL / Advance SQL (must have)
• Familiarity with a good reporting tool e.g. Power BI (nice to have)
• Payer Experience and Government Programs - Medicare and Medicaid (must have)