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.
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
Implementing BI solutions, both client-facing and internal:
d. Predictive analytics
a. Analyze data model requirements
b. Design/Implement data models
c. Maintain data models in sync with environments
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
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
a. Analyze ETL requirements
b. Design/Implement ETL process
c. Monitor and maintain ETL processes
Who we are Looking for:
5+ years of experience in BI tools like Birst, Microstrategy, Business Objects, Cognos OBIEE, Qlikview
5+ years in business analysis
5+ years of experience in SQL with MS SQL Server
Experience in Birst is a big advantage
Experience in data modeling for data warehousing - star, snowflake schema designs
Experience in ETL/data integration tools like Informatica, MSFT SSIS, Oracle Warehouse Builder, Data Integrator, Data Stage, Ab Initio
At Viventium, you don’t work, you build. We enable companies and their employees to do their best work. We know that employees want to thrive and employers want to do what is right. The human element of HCM is what we create through our technology, service and sales. HCM is a mindset, not a catch phrase, and it certainly is not a spectator sport! We promise a career changing experience where you matter. We believe that our future is dependent on the talent we recruit, develop, unleash, and retain. We believe that our client’s success is the only thing we care about. If we can be strategic to our clients then their success will ensure ours.
Our company motto “in it with you” represents our philosophy on what it means to be a company that addresses the Human Capital Management (HCM) needs of small and midsized businesses. Being “in it with you” means we impact HCM in a way that is meaningful and drives business outcomes. We believe that while the SMB market has similar business challenges, there is also a uniqueness that often demands customization.
Driving our passion to address these needs is our cutting edge cloud-based software. We choose to have one platform that is scalable and dynamic. Coupled with our intuitive software is our up-skilled client services team that exists to ensure a positive experience with every call. It is the reason our clients are loyal and promote Viventium. We believe that the SMB market deserves the best in each functional area of business management surrounding managing employees. We partner and integrate with the best and most innovative companies to service need outside of the core payroll and HR functions.
Viventium Software is a privately held company with locations in New York and New Jersey. We have been in business for over 25 years and have nearly 5,000 clients.