Business Intelligence Developer

Nisum is a leading global digital commerce firm headquartered in California, with services spanning digital strategy and transformation, insights and analytics, blockchain, business agility, and custom software development. Founded in 2000 with the customer-centric motto “Building Success Together®,” Nisum has grown to over 1,800 professionals across the United States, Chile,Colombia, India, Pakistan and Canada. A preferred advisor to leading Fortune 500 brands, Nisum enables clients to achieve direct business growth by building the advanced technology they need to reach end customers in today’s world, with immersive and seamless experiences across digital and physical channels.

What You'll Do

• Provides development leadership and expertise for advanced BI analysis and analytics.
• Guides and moves forward an advanced BI/Data Mart system providing sophisticated and measurable business benefits.
• Drives data, ETL, and system architecture and development.
• Owns the advanced analytics data environment to ensure that the data refresh from various sources, to facilitate research, is happening at regular intervals.
• Supports a group of multi-disciplinary data professionals and analysts. Drives development (coding using PL/SQL, Perl or any other scripting language, ad-hoc queries using SQL).
• Ensures that the data infrastructure can scale to meet defined performance, load, and functional objectives Effectively manages the execution of parallel projects of varying scope and duration.
• Responsible for all database objects including tables, indices, triggers, views, sequences, packages, and procedures.
• Works with Systems and Database Administration for infrastructure needs related to support, storage, backups, monitoring, and performance bottlenecks.
• Participates in application development and quality assurance in the management of application releases.
• Advises senior management on “best practices” concerning web analytics, data warehousing, data architecture, and data development. Works with business intelligence and other source system owners to build a data refresh plan for the research environment.
• Owns web click stream data collection and supports product managers to implement best practices for data definition.
• Supports project management and documentation needs of the group.

What You Know

• Experience with Oracle 8i, 9i, and 10g including PL/SQL, SQL loader, external tables, partitioning, and performance tuning.
• Strong knowledge of Oracle data structures, data dictionary, and RDBMS structures.
• Experience as a data architect and/or DW/BI architecture.
• Experience in database design and administration, strong in performance tuning, software installation, scripting, PL/SQL coding, backup & recovery process.
• At least 2 medium to large scale DW/BI project implementation experience.
• Experience working with DW/BI environment to be able to understand the concepts of STAR, data cleansing, transformation, and aggregations.
• 4+ years, of current, development experience and inclination towards development.
• 1+ years experience with web analytics products like Web Trends, NetTracker, Omniture, etc.
• Experience working in an environment that has come across customer integration issues or has addressed them using MDM.
• Ability to express business and technical concepts clearly and concisely both verbally and in writing.
• An aggressive approach to staying current with developments within the internet world, related web analytics & data management.
• Experience working in a team-oriented, collaborative environment.
• Good to Have Skills:
• Experience working with various business applications like campaign management, CRM, and ERP.
• Experience with Java scripts or any other web front-end scripting.
• Experience with column-oriented database solutions such as HBase or Infobright.
• Experience with Hadoop.
• Oracle database administration experience.
• Experience working with various data reporting tools like Business Objects, MicroStrategy, and COGNOS.
• Experience working with ETL tools like Data Stage, Informatica, and Hummingbird.
• Experience working with metadata management. Experience with SAS.

Education

• Bachelor’s degree in Computer Science, Information Systems, Engineering, Computer Applications, or a related field

Benefits

• In addition to competitive salaries and benefits packages, Nisum US offers its employees some unique and fun extras:
• Professional Development - We offer in-house technical training and professional learning programs aimed at developing skills across a broad spectrum of topics such as technology, leadership, role-based training, and process expertise. We also offer an annual stipend for employees to attend external courses in order to maintain professional certifications
• Health & Wellness Benefits - We believe that your health and welfare are important, and we strive to ensure that you have affordable options available to you, including some plans that are subsidized for employees and their families up to 90%. We also have dental and vision plans in the US where Nisum pays 100% of premiums for employees
• Volunteerism Pay - We believe in giving back and in the US, our employees are eligible for up to 40 hours of paid time off each year to volunteer towards the causes that they are most passionate about. This is in addition to personal PTO and paid holidays
• Additional Benefits - We offer all the other important benefits to keep employees and their families healthy and financially secure, such as 401(k) retirement savings with a company match, pre-tax parking and transit programs, disability insurance, and Basic Life/AD&D, alongside exclusive employee discounts on a wide variety of products and services

Compensation Band

• $120-125k per year

Nisum is an Equal Opportunity Employer and we are proud of our ongoing efforts to foster diversity and inclusion in the workplace.