IT - Business Intelligence (Advanced Analytics Developer) Business Intelligence (Advanced Analytics Developer)

Mindlance
Hybrid, CA
$70-$75 an hour
Full-time

Job Description : 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, performance bottlenecks.

Participates with applications 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 data refresh plan for 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.

Skill Set :

Experience with Oracle i, i and g including PL / SQL, SQL loader, external tables, partitioning and performance tuning. Strong knowledge of Oracle data structures, data dictionary, and RDBMS structures.

Experience as 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 medium to large scale DW / BI project implementation experience. Experience working with DW / BI environment to be able understand the concepts of STAR, data cleansing, transformation and aggregations.

  • years, current, development experience and inclination towards development. + 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 it using MDM. Ability to express business and technical concepts clearly and concisely both verbally and in writing.

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, 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, COGNOS.

Experience working with ETL tools like Data Stage, Informatica, Hummingbird. Experience working with meta data management. Experience with SAS.

Additional Regions : EEO :

EEO :

6 days ago
Related jobs
Mindlance
Saint-Bruno-de-Montarville, Quebec

Guides and moves forward an advanced BI/Data Mart system providing sophisticated and measurable business benefits. Owns the advanced analytics data environment to ensure that the data refresh from various sources, to facilitate research, is happening at regular intervals. Works with business intelli...

Promoted
CAE Inc
Montreal, Quebec

As "One CAE," we take affirmative action to ensure equal opportunity for all applicants regardless of race, nationality, colour, religion, sex, gender identity and expression, sexual orientation, disability, neurodiversity, Veteran status, age, or other legally protected characteristics. CAE is an e...

Promoted
RONA Inc.
Boucherville, Quebec
Remote

Reporting to the Business Intelligence Manager, the Web Analyst's main responsibility is to measure the performance of RONA's digital properties (rona. Using web analytics tools such as Adobe Analytics (primarily), as well as Google Analytics, they will develop recurring and ad hoc reporting solutio...

Promoted
IT Chapter
Montreal, Quebec

Excellentes aptitudes à la communication (verbale et écrite) capacité d’écouter, de comprendre et de répondre de façon pertinente et efficace. IT Chapter est à la recherche d'un analyste d'affaires pour accompagner les équipes RH dans l'implémentation d'un outil de gestion des horaires. Habileté à p...

Revau Advanced Underwriting, Inc.
Montreal, Quebec

IT and Business Unit Relations: Manage relationships between IT and business units. Ce rôle nécessite une étroite collaboration avec les différentes divisions afin d'aligner les systèmes d'information sur les orientations stratégiques concernant les lignes de produits d'assurance. Tests d'assurance ...

DELAN - IT Head Hunters
Montreal, Quebec

Meet with clients as needed, participate in architecture and technical specifications. Strong spirit of collaboration, leadership, and versatility. The C# Developer / Technical Lead will be responsible for the development of. Promote best practices and ensure the development of high-quality code. ...

S.i. Systems
Montreal, Quebec

Use a broad range of tools, technologies and platforms to provide developers, application administrators, and end users with the ability to perform their tasks. Facilitate collaboration with other engineers, product owners, and designers to solve interesting and challenging problems for delivering v...

DELAN - IT Head Hunters
Montreal, Quebec

Develop quality code and ensure the performance of the network as well as the functionalities developed. The Developer will be responsible for programming the Back-End and the network aspect of a company specializing in video game design. Design the network architecture and make technological choice...

Upskills
Montreal, Quebec

We are looking dedicated ITBusiness Analyst based in Canada to join our team and work onvarious projects in the Capital Market Trading System Businessexpertise and support. Work withdifferent IT teams across infrastructure and other divisions todeliver system solutions for the business. SQL, Python,...

Amaris Consulting
Canada

Proven ability to identify inefficiencies and propose solutions to streamline operations, reduce costs, and boost productivity in pharmaceutical business processes. Knowledgeable about regulatory requirements and industry standards including GCP, GMP, and ICH guidelines, with skills to assess and mi...