Data/Business Intelligence Architect
Viventium Software Inc. New York, NY DOE

Viventium is looking for a Data/BI architect for our dev team. This person will be responsible for the end-to-end implementation and maintenance of Business Intelligence including system architecture; design and development of analytic solutions and can understand business challenges & translate them into requirements/solutions. The person must have strong analytical skills, along with experience on BI tools, SQL development/optimizations, data modeling, and ETL, and will be working together with our Product, DBA, SQL and report developers.


1.      Requirement Analysis 

              a. Analyze business requirements and design appropriate solutions

              b. Work with Product to design BI solution for clients

              c. Work with different departments to understand their data needs and design solutions accordingly

2.      Implementing BI solutions, both client-facing and internal: 

              a. Dashboards

              b. Reports

              c. KPI’s

              d. Predictive analytics

3.      Data modeling 

              a. Analyze data model requirements 

              b. Design/Implement data models

              c. Maintain data models in sync with environments

4.      Database architecture and optimization 

              a. Design database architecture to meet BI and reporting needs

              b. Design/Implement star and/or snowflake schemas

              c. Design/Implement Table structure, location, partitioning

              d. Design/Implement Indexes, Constraints, Keys, Data Types, Column Store Indexes

5.      SQL Development and optimization 

              a. Develop SQL queries, procedures, functions, views for BI and reporting purposes

              b. Develop queries for complex reports

              c. Analyze and tune SQL performance 

              d. Optimize SQL queries

6.      ETL Implementation

              a. Analyze ETL requirements

              b. Design/Implement ETL process

              c. Monitor and maintain ETL processes


  1. 5+ years of experience in BI tools like Birst, Microstrategy, Business Objects, Cognos OBIEE, Qlikview
  2. 5+ years in business analysis
  3. 5+ years of experience in SQL with MS SQL Server
  4. Experience in Birst is a big advantage
  5. Experience in data modeling for data warehousing - star, snowflake schema designs
  6. Experience in ETL/data integration tools like Informatica, MSFT SSIS, Oracle Warehouse Builder, Data Integrator, Data Stage, Ab Initio 
Viventium Software Inc. is an EEO employer - M/F/Vets/Disabled
By clicking the button, I agree to the GetHired Terms of Service member? Login to Apply