Return To Job Search
Data Architect - COGNOS
Las Vegas Metro Area
Applications/Web Development
Database Developer/Engineer
JN -082019-22347

Crescent Solutions is committed to helping you as an esteemed IT Professional find the next right step in your career.  We match professionals like you to rewarding consulting or direct hire opportunities in your area of expertise.  During the initial discussion, we hope to learn more specifics about your background and skill set to determine what job opportunities will be most interesting to you. Our keep it simple approach is only part of what sets us apart from other firms in the challenging job market today.
We partner with the most innovative and well-known organizations in the industry providing you exceptional career opportunities.  We are currently seeking IT professionals who are searching for technology jobs for the following opportunity:

Database Architect - COGNOS


  • Determine database structural requirements by analyzing client operations, applications, and programming
  • Review objectives with clients
  • Evaluate current systems and data interactions
  • Install database systems by developing flowcharts
  • Coordinate installation actions; document actions
  • Maintain database performance by identifying and resolving production and application development problems
  • Calculate optimum values for parameters
  • Evaluate, integrate and install new releases; complete maintenance
  • Prepare users by coordinating training
  • Provide database support by coding utilities, responding to user questions, and resolving
  • problems
  • Manage and maintain the IBM/COGNOS database data analysis and reporting
  • Map and configure data from a state administered SACWIS system to the IBM/COGNOS database

Technical Skills:
  • Design data architecture including framework, principle, guideline and template to guide the delivery team to realize an optimized solution
  • Design the detailed data architecture including data governance, master data strategy, master data management, data quality, data modeling, ETL approach, data storage, etc.
  • Design optimal data warehouse and analytics solution to fulfill the business/technical requirement
  • Develop business intelligence and data management solution plan. The solution plan includes requirements, solution design, estimation, project plan and implementation considerations
  • Identify the gap between business requirement and data architecture and propose solution to resolve or shorten the gap
  • Shaping and leading large‐scale analytics projects; full life-cycle implementation activities
  • Producing security plans and implementing security in IBM/COGNOS Connection
  • Data Modeling using Visio and Framework Manager
  • Database maintenance including indexing and performance tuning
  • Design and develop custom reports, graphs and interactive dashboards using COGNOS
  • Design and develop dimensional modeled data warehouse using Kimball methodology
  • Design and develop cubes using Transformer, including developing scripts to schedule cube builds
  • ETL development using IBM/COGNOS Data Manager and SQL Server Integration Services (SSIS)
  • Requirements gathering with business users to design custom solutions, including enterprise data warehouses, reports, dashboards and cubes
  • Training end users in the COGNOS tools and the solutions
  • Design and develop custom reports using COGNOS ReportNet and Report Studio
  • Responsible for database and query/report SQL optimization and tuning
  • ETL development and deployment using Data Manager, Decision Stream and DataStage
  • Design and Development of Powerplay Cubes using Transformer, including developing scripts to schedule the cube builds
  • Experience in IBM/CONGOS SPSS software and predictive analytics


Previous MonthNext Month