*Hi,* Hope you are doing good !!
This is Vijay from *Reliable Software Resources Inc,* this mail is regarding the job opportunity as a* “Data Architect Intermediate”* Please find the requirement details and let me know your interest. Thanks !!! *Job Title: Data Warehouse Architect* *Location: Bridgeport, Connecticut* We have a new requisition for a* Data Architect Intermediate *with the Medicaid Agency for the State of Alabama. Additional information and submission format described below: *LOCATION:* Montgomery, AL *JOB DESCRIPTION AND ADDITIONAL DETAILS:* *Position Description * The Data Architect will work under the direction of the CARES Development Manager for the CARES Project. The Data Architect will develop architectural standards, patterns and practices and innovative solutions for the development of the State of Alabama’s Integrated Eligibility and Enrollment System, CARES. This position will support the CARES Project with the following: • Develop and manage complex data models (conceptual, logical, & physical) supporting data de-identification efforts. • Create, and maintain necessary databases to support data de-identification effort. • Creating Logical Models and converting the Logical models in to Physical models. • Create complex views and materialized views and tune for performance. • Review and assist SQL Developers with query optimization and bringing systems up to standards. If required, write the SQL queries, Stored Procedures, functions and perform analysis based on business requirement. • Should be able to work Hands-on in terms of developing prototypes, contributing code or evaluating technologies • Provide architectural strategic thinking, information solutions, and roadmaps to drive architectural recommendations. • Designing the future integration of data into the business process model through the use of ETL, API’s, XML and appropriate technologies. • Maintain a plan to address significant architecture gaps between current and target state. • Provide information architecture services to project teams. Solutions provided must meet requirements and adhere to CARES Program standards. • Work with product owners to develop the canonical data schema for the CARES Program • Ensure information architectural compliance of solutions and introduce recommendations for changes to reference models when needed. • Collaborate with business leaders to determine how to best use technology to enable growth and success (e.g. operational reporting and advanced analytics). • Participate in defining and driving architecture competencies, processes, and best practices across Integrated Eligibility and Enrollment systems. • Understand potential impacts of proposed solutions on other systems, processes or projects. Articulate and document designs, considering tradeoffs, costs, and benefits. • Develop ongoing knowledge of current and emerging technologies. Identify new and emerging solutions, assess relevance and potential value to the organization, and present findings to teammates and management. • Participate in day-to-day execution of the architecture strategy • Within the CARES Program governance process, support development of blueprints and conduct design reviews to ensure architectural compliance of solutions. • Work across multiple projects and systems to develop, communicate information • Provide guidance for technical standards enforcement • Design systems level architecture in compliance with industry standard approaches to enterprise architecture • Meet with other PMO level teams to facilitated a collaborative approach to systems development • Develop clear, technical documentation and communicate that documentation to management the development teams • Collaborate with a Program Director, Lead Business Analyst, Quality Assurance Manager, and Development Manager to provide advice and guidance to the development enterprise • Collaborate in gathering and documenting requirements from end users and management. Candidate will work from high-level conceptual ideas and translate them into technical requirements. • Design integrated data framework and canonical data schema for the CARES Program • Work with an Project Team to support database design and implementation • Design application components • Work with a Quality Assurance team to develop automated test plans • Monitor the development of application components to ensure compliance with architectural standards • Participate in security testing processes and implement recommendations to code revisions • Manage, troubleshoot, optimize, and tune web applications and features • Work with the Business Analyst and product owners to understand business rules and interpret data • Respond to ad hoc requests from Medicaid Eligibility team and others • Review, assess, analyze, design, build, implement, & support Medicaid Eligibility system(s) and/or associated projects as directed or assigned • Develop MITA technical and architectural Documentation • Facilitate technical interactions with multiple state agencies Provide support for the following deliverables per direction and assignment by the Agency Project Sponsor, the CARES Program Director and Project Manager : • Enterprise Architecture Standards for the CARES Program • Weekly status reports on EA efforts • Patterns and Practices for CARES development efforts • Training for developers in CARES patterns and practices • Project Status Reports • All identified project documents • Other deliverables as identified and assigned Skills Required • Expert level knowledge of T-SQL and Integration tools (DTS, SSIS etc.) • Expert level knowledge on CASE tools (Erwin, ER/Studio, etc.). • Expert level knowledge on reporting tools (Reporting Services, Crystal Reports, etc.) • Expert level knowledge of database design and information modeling • Excellent Written and Verbal Communication Skills • Advanced uses of database design toolsets, especially with Microsoft SQL Server solutions • Advanced understanding of data discovery/analysis/classification, data masking, data transformation, and SQL/data modelling. Experience Required Experience: • 7+ years of experience with systems design and development as an Information Architect/Data Architect; specific experience and knowledge of the following: • 7+ years of experience in Information Management, Data Analysis. • Experience with Integration tools (DTS, SSIS etc.) • Experience on CASE tools (Erwin, ER/Studio, etc.). • Experience on reporting tools (Reporting Services, Crystal Reports, etc.) • Experience developing complex Conceptual, Logical and Physical Data Models • Preferred experience with PHI/PII data de-identification/ anonymization / masking techniques • Ability to cross-walk existing legacy systems (business process, code, technology, programming and architecture) from Mainframe to Web and Web to Mainframe environments • Must have clear experience in coding and creating site maps, wireframes, understand object-oriented programming, and have skills in full-lifecycle software development. • Expert level experience on writing complex views and materialized views and tune for performance. Experience Preferred • Experience with Alabama Medicaid Beneficiary Services Eligibility Determination Operations is a plus Education Required • Bachelor’s Degree from an accredited four year college or University in an appropriate technical degree program or equivalent experience. -- *Regards,* *Vijay D* Sr. Recruiter (State Govt Support) Phone: 312 967 7072 22260 Haggerty Rd, Suite # 285,Northville, MI 48167. Email: *vija...@rsrit.com <vija...@rsrit.com> *I *www.rsrit.com <http://www.rsrit.com/>* *www.linkedin.com/in/vijay-d-97047a65 <http://www.linkedin.com/in/vijay-d-97047a65>* -- You received this message because you are subscribed to the Google Groups "Resumes" group. To unsubscribe from this group and stop receiving emails from it, send an email to resumes+unsubscr...@googlegroups.com. To post to this group, send email to email@example.com. Visit this group at https://groups.google.com/group/resumes. For more options, visit https://groups.google.com/d/optout.