Software Architect II
Click the Facebook, Google+ or LinkedIn icons to share this job with your friends or contacts. Click the Twitter icon to tweet this job to your followers. Click the link button to view the URL of the job, which then can be copied and pasted into an e-mail or other document.
Chicago, IL 60601
Blue Cross and Blue Shield Association seeks a Software Architect II in Chicago, IL.
Translate business needs into a data model, providing expertise on data modeling tools and techniques for designing data models for applications and related systems. Actively leads and participates in Data Governance Initiatives to support Enterprise Data Strategy across operational and analytical database environments. Leads and coordinates cross functional teams on a project basis to effectively communicate database design related activities with a wide range of technical, non-technical, and third-party team members.
Determine data modeling requirements from business and functional requirement documents. Use ERwin data modeling tool to: create a logical data model; create a physical data model; generate DDL; reverse engineer a data model from a database; use Complete Compare. Develop conceptual approach alternatives for each set of data requirements. Data model transactional systems and data hubs in normalized designs. Data model data warehouse/data mart systems in star-schema designs using SCD-2 dimensions. Integrate new requirements into the framework and structures of existing data models. Perform SQL queries, profile and analyze data. Determine data element commonality based on semantics. Write clear, concise, and complete data element definitions. Create source-to-target data mapping documentation. Maintain a corporate repository of all data architecture artifacts.
Requires a Bachelors degree in Computer Science, Information Systems, Business Administration or a related field. Requires 7 years of IT work experience including database design and implementation. Requires 5 years of experience working in a Sr. Data Modeler or Data Architect capacity with hands on experience RDBMS like Oracle, IBM DB2 and/or MS SQL Server. Requires 5 years of experience in data modeling and database design and performance tuning. Requires 5 years of experience in Structure Query Language (SQL). Requires 2 years of experience working with ERwin Data Modeler. In lieu of the Bachelor’s degree, employer will accept an educational equivalency evaluation.
Applicants who are interested in this position may apply https://www.jobpostingtoday.com/ Ref # 77110.